Database Design

CIS 310: Database Design

This course provides a solid and practical foundation for the design and implementation of database systems. Emphasis is on relational database models, with significant coverage of basic relational database concepts, normalization, E-R modeling, locking, SQL, and distributed databases. The software used for this course was Microsoft SQL server. Below you will find database design documents primarily composed of Entity Relationship Diagrams.

Assignment 2
This assignment focused on database design with business rules. The link shows the business rules at the top with the resulting ERD and example tables that satisfy those rules.

Assignment 3
This assignment shows the resulting tables of different types of joins. Additionally, a given database was analyzed for proper design and a resulting ERD was generated.

Assignment 4
Another database design this time with more complex business rules.

Assignment 5
This assignment was an exercise in normalization. The beginning database starts in First Normal Form and ends in Third Normal Form. Includes final normalized ERD.