淫妻社

淫妻社

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 别诲.,听听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)