What This Document Is
This document is a graded assignment (Assignment 3) for New Jersey Institute of Technology’s Data Management Systems Design course (CS 631). It requires students to translate a given Entity-Relationship (ER) diagram of a university database schema into a relational database schema and then express that schema using SQL Data Definition Language (DDL) statements. A second part of the assignment involves formulating relational algebra and SQL queries based on a separate supplier-parts database schema.
Why This Document Matters
This assignment is intended for students enrolled in CS 631 who are learning about database design and implementation. It’s used to assess their ability to map conceptual data models (ER diagrams) into practical database structures and to demonstrate proficiency in SQL for schema creation and data retrieval. Successful completion demonstrates understanding of relational database principles, normalization, and query construction.
Common Limitations or Challenges
This assignment focuses on the *design* and *declaration* of a database, not on data manipulation or performance optimization. It does not cover advanced SQL features like stored procedures or triggers. Students will need a solid understanding of relational algebra and SQL syntax to complete it successfully.
What This Document Provides
The full document includes:
* A university database schema presented as an ER diagram.
* Instructions to map the ER diagram into a relational schema.
* A set of SQL DDL statements for creating the university database, including referential integrity constraints with specified actions (reject, cascade, set to NULL, set to default).
* A second database schema (suppliers, parts, catalog) and a set of queries to be expressed in both relational algebra and SQL.
* This preview *does not* include the student’s answers or solutions to the assignment questions. It only presents the problem statement and schema definitions.
