Database Design

Database Normalization

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.


SQL Writing

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.