Below is a copy of an assignment where we were required to normalize a database into the third normalized form and subsequently create a schema for the normalized database.
Database Schema Creation
The below file contains the solution to an assignment where we were tasked with creating a database schema. The schema refers to each table and its relationships with other tables in the database.
The below file contains twenty-eight SQL statements. These statements were created as part of an assignment where questions were posed to a pre-created database and we had to create SQL statements to retrieve the requested data.
More Database Design
More Database design principles, such as a data dictionary, can also be viewed within the Systems Analysis and Design Page.