top of page
Flow Chart

Database Design

Database Design: Welcome

Coursework

Assignment 1

Assignment shows potential update anomalies that can occur because of the data redundancies

Assignment 2

Shows how to create a set of data tables that were without redundancy and showed the primary and foreign keys. Those tables were then used to create a Crow’s Foot ERD to show the relationships between each table.

Assignment 3

This assignment shows SQL activity utilizing business rules

Assignment 4

This assignment shows the understanding of data integrity.

Assignment 5

This assignment shows SQL activity utilizing joins

Assignment 6

This assignment shows the understanding of converting a table that is in first normalization form to second normalization form then finally to third normalization form. The tables created from third normalization form where then used to create a Crow’s Foot ERD showing the relationships between the new tables.

Assignment 7

Diagram shows the relationships between the tables that are used for the SQL code in the SQL code sample section for assignment 7.

Assignment 8

This assignment shows SQL activity utilizing data relationships

Assignment 9

This section shows the relationships between tables used for the SQL code in the SQL sample code section for assignment 9.

Assignment 10

Demonstrates how to create a database using SQL code then use complex procedures to manipulate the data. Assignment 10 is a culmination of all of the SQL coding.

Database Design: Files
bottom of page