INFO-I 308 Information Representation
This course covers information representation in computer systems. Topics include relational databases in the ER model; SQL commands; database design, implementation, and normalization; database triggers; backup, security, and other data management tasks; data extraction from JSON and XML and their use for transmitting objects between browser and server; and social and ethical issues.
Upon completion of this course, students will:
- Design and implement relational databases using tables, keys, relationships, and SQL commands to meet user and operational needs.
- Diagram a relational database design with entity–relationship diagrams (ERDs) using crow’s foot notation to enforce referential integrity.
- Evaluate tables for compliance to third normal form and perform normalization procedures on noncompliant tables.
- Write triggers to handle events and create views to enforce business rules within a relational database.
- Perform data management tasks associated with the data lifecycle including backup and security.
- Transmit objects between the browser and server by converting them into JSON.
- Evaluate the social and ethical implications of data management.