Same school, new name. The School of Informatics and Computing is changing its name effective January 11, 2023. Learn more about the name change

INFO-I 308 Information Representation

3 credits

  • Prerequisites: None
  • Delivery: On-Campus, Online
  • Semesters offered: 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.

    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.