Project
Can be any business other than a bicycle shop (sales/repair)
1 Person 20 Tables
(Average 5 Columns per table) Important note: I need 100 attributes in total in 20 20 tables(it may be either 5-6 attributes 1 table or 3-4 attributes in another 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(need in excel)
10 rows of dummy data in each table (where possible)(neeed in excel)
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.
—
Project
Any business that isn’t a bicycle store (sales/repair) is eligible.
20 Tables for 1 person
(Each table has an average of 5 columns.) Important note: I need a total of 100 attributes across 20 tables (it may be either 5-6 attributes 1 table or 3-4 attributes in another table)
The data should be normalized to the third normal form.
Give a clear explanation of why you planned this breach in 1 (per person) instance when the 1st, 2nd, or 3rd normal form is violated (you can have more than one, but it must be explained)
For each table, create Select/Insert/Update/Delete statements (other than many-to-many tables)
Create a minimum of 12 business rules, with at least 10 of them being embedded into the design (Per person)
Explain how you came up with your naming convention.
Dictionary of Data (need in excel)
10
