Can be any business other than a bicycle shop

  

ProjectCan be any business other than a bicycle shop (sales/repair)1 Person 20 Tables2 People 38 Tables3 People 56 Tables4 People 74 Tables(Average 5 Columns per table)Should be normalized to 3rd Normal Form1 (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 Dictionary10 rows of dummy data in each table (where possible)DDL Scripts for each table, PK, and FKUsing 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.

Don’t use plagiarized sources. Get Your Custom Essay on
Can be any business other than a bicycle shop
Just from $13/Page