Computer Science
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 |
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
