INFO-I 308 Information Representation
- Prerequisites: None
- Delivery: On-Campus, Online
Fall, Spring, Summer 2
The above are the semesters this course is generally offered. View the course schedule to confirm.
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.