Electrical Engineering and Computer Science

EECS 4560 - Database Management Systems Course Syllabus

Credits/Contact Hours
3 credit hours (3 hrs lecture, no lab) / Engineering Topic
Textbook

Fundamentals of Database Systems, 7th ed.,  Ramez Elmasri & Shamkant Navathe;  Pearson Higher Education, 2015  

ISBN-13: 978-0133970777

Course Information

Catalog Description: Introduction to Database Systems, Data Modeling, Entity-Relationship Diagrams, The Relational Model, SQL, Relational Algebra, Relational Calculus, Normal Forms (1NF, 2NF, 3NF, BCNF, 4NF, PJNF/5NF), Cadidate keys, superkeys, schema decomposition, Funcional dependency, Entity and Referential Integrity.  

 Prerequisite: EECS 2510 with min. grade of D‐ 

Required Course for CSE 
Specific Goals - Student Learning Objectives (SLOs)

Upon successful completion of the course, the student will be able to …  

1. Design relational databases.
2. Understand normal forms and perform normalization.
3. Design and develop a relational database system with appropriate
   functionality to process the data and with constraints to maintain data
   integrity and avoid data redundancy. 
4. Write SQL queries to retrieve and modify information from a database
   system.
5. Create queries to retrieve information from structured, semi-structured,
   and unstructured data.

Topics

Introduction to Database Systems: 

• Approaches to and evolution of database systems 
• Components of database systems  
• Database architecture and data independence 
• Use of a declarative query language 
• Systems supporting structured and/or stream content 

Data Modeling: 

• Conceptual models (e.g., entity-relationship, UML diagrams) 
• Spreadsheet models 
• Relational data models 

Relational Databases: 

• Mapping conceptual schema to a relational schema 
• Entity and referential integrity 
• Relational algebra and relational calculus 
• Relational Database design 
• Functional dependency 
• Decomposition of a schema; lossless-join and dependency- 
  preservation properties of a decomposition 
• Candidate keys, superkeys, and closure of a set of attributes 
• Normal forms (1NF, 2NF, 3NF, BCNF) 
• Multi-valued dependency (4NF) 
• Join dependency (PJNF, 5NF)