The course introduces the student to the theory and practice of database management, that is, the application of database technology to the solution to business and information-related problems. It covers an introduction to the relational model of data, and focuses on the use of Structured Query Language (SQL). Database concepts, terminologies and data structures of the relational database model will be discussed, and briefly compared with other models (such as hierarchical, network, and object). Database design in the practice of normalization is included, but the emphasis is on the use of Entity-Relationship modeling for a graphical approach to the analysis of requirements and the design of a conceptual schema. The student will have hands-on experience working with a database management system such as MS Access, Oracle, or SQL Server.

Prerequisites: 75 credits and ARTM3210, INFS2120, INFS2130, INFS2140, INFS2184, INFS2151, INFS2150, INFS2160, or MATH2070