AI Summary
[DOCUMENT_TYPE: user_assignment]
**What This Document Is**
This document outlines the requirements for Phase 2 of the course project in CISC 637: Database Systems at the University of Delaware. It serves as a guide for students working in groups to translate a previously designed data model into a functional database system. This phase focuses on the practical implementation aspects of database design, bridging the gap between theoretical modeling and real-world application.
**Why This Document Matters**
Students enrolled in CISC 637 will find this document essential as they progress through the course project. It’s particularly valuable when you’re ready to move beyond conceptual design and begin building a working database. Understanding the expectations detailed within will ensure your group’s work aligns with the project goals and grading criteria. Refer to this document frequently during the implementation and data loading stages of your project to stay on track and address potential challenges proactively.
**Topics Covered**
* Relational Schema Design
* Database Implementation using MySQL
* Data Import and Management
* Normalization (3NF and BCNF considerations)
* Functional Dependencies
* SQL Command Usage
* Data Pre-processing Techniques
* Project Timeline and Deadlines
**What This Document Provides**
* A clear breakdown of the three key steps involved in Phase 2.
* Details regarding the datasets provided for use in the project, including the types of information contained within each file.
* Information on accessing the designated MySQL server environment.
* Guidance on utilizing command-line tools for data import.
* The specific due date for Phase 2 submission, along with a recommendation for proactive completion.
* Important context regarding upcoming course events, such as the midterm examination.