Search
School of Informatics and Computing Menu

INFO-I 308 Information Representation

3 credits

Prerequisties: None

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.

Learning Outcomes

Upon completion of this course, students will:

  1. Design and implement relational databases using tables, keys, relationships, and SQL commands to meet user and operational needs.
  2. Diagram a relational database design with entity–relationship diagrams (ERDs) using crow’s foot notation to enforce referential integrity.
  3. Evaluate tables for compliance to third normal form and perform normalization procedures on noncompliant tables.
  4. Write triggers to handle events and create views to enforce business rules within a relational database.
  5. Perform data management tasks associated with the data lifecycle including backup and security.
  6. Extract data from JavaScript Object Notation (JSON) and XML documents.
  7. Transmit objects between the browser and server by converting them into JSON.
  8. Evaluate the social and ethical implications of data management.

Course Delivery

  • On-Campus
  • Online

Course Schedule

Syllabi