CIS 331: Database Management Using SQL

Project Requirements

DATABASE MANAGEMENT USING SQL (CIS331)
TENTATIVE TERM PROJECT (20 points total)

The following description of this project is tentative. Before submitting any phases be sure to check with your instructor regarding any changes and additions.

To test his or her ability to design and create a database using SQL, each student will complete an individual project following these instructions. The project will involve a database that includes at least four tables. The content of the tables is to be chosen by the student, subject to instructor approval. It would be best to choose data relevant to the student’s interests.

Phase 1: Description (4 points)

A typed description of the proposed project must be submitted. This will include descriptions of:

• Four related entities.
• Typical attributes of each entity.
• Relationship between entities.
• There must be sufficient data for the tables to create at least 40 records, total.

Phase 2: Design (4 points)

Database design of all tables for the project. Also, Phase 1 description should be resubmitted with any necessary revisions.

Phase 3: Basic Database (5 points)

Creation and loading of database. Turn in full listings of all data in all tables to verify this has been done. As noted above, there must be a total of at least 40 records.

Phase 4: Completed Database (7 points)

Database including tables, queries, and reports. All should be clearly labeled.

• There must be at least one query and one script that would create a view or a report from each table.
• There must also be at least two queries and two scripts that would create views or reports, all using data in multiple tables.