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 …
- Design relational databases.
- Understand normal forms and perform normalization.
- 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. - Write SQL queries to retrieve and modify information from a database
system. - 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)