CIS 331: Database Management Using SQL
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
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
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
- 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.