This course will cover the following topics: (1) Logical and physical aspects of database management systems (2) Data models including entity-relationship (ER) and relational models (#) Physical implementation (data organization and indexing) methods. (3) Query languages including SQL and relational algebra. (4) High level concepts: transactions, relation normalization, and security and privacy. Students will gain experience in creating and manipulating a database, and gain knowledge on professional and ethical responsibility and on the importance of privacy/security of data.
College of Engineering and Computer Science