Project
Can be any business other than a bicycle shop (sales/repair)
1 Person 20 Tables
2 People 38 Tables
3 People 56 Tables
4 People 74 Tables
(Average 5 Columns per table)
Should be normalized to 3rd Normal Form
1 (per person) instance where 1st, 2nd, or 3rd normal form is violated, give a detailed explanation as to why you designed this violation (you can have more than one, but it must be explained)
Create Select/Insert/Update/Delete statements for each table (other than many-to-many tables)
Create at least 12 business rules, 10 should be built into the design (Per person)
Naming convention – explain the naming convention you used.
Data Dictionary
10 rows of dummy data in each table (where possible)
DDL Scripts for each table, PK, and FK
Using https://app.diagrams.net/ create the ERD using Crow’s Foot Notation (No other Notation will be accepted)
If you are working as a team, make sure it is obvious who created which pieces. Color code the ERD, showing who did what.
One person should submit the project for the team.
Data Dictionary
| Table Name | Column Name | Data Type | PK or FK | FK Referenced Table | Description |
| Parts | PartID | INT | PK | Primary Key | |
| Mfg_PartNumber | Varchar(100) | Part Number provided by Vendor | |||
| VendorId | INT | FK | Vendors | FK to Vendor Table | |
| WholesaleCost | Decimal | Wholesale cost from vendor | |||
| RetailPrice | Decimal | Price we charge customers | |||
| Vendors | VendorId | INT | PK | Primary Key | |
| Name | Varchar(100) | Vendors Name | |||
| Address | Varchar(100) | Mailing Address | |||
| StateCode | Char(2) | State | |||
| ZipCode | Char(9) | Zip |
