Could be any enterprise apart from a bicycle store (gross sales/restore)
1 Individual 20 Tables
(Common 5 Columns per desk) Necessary observe: I want 100 attributes in whole in 20 20 tables(it might be both 5-6 attributes 1 desk or Three-Four attributes in one other desk)
Must be normalized to third Regular Type
1 (per particular person) occasion the place 1st, 2nd, or third regular type is violated, give an in depth rationalization as to why you designed this violation (you may have multiple, however it should be defined)
Create Choose/Insert/Replace/Delete statements for every desk (apart from many-to-many tables)
Create not less than 12 enterprise guidelines, 10 ought to be constructed into the design (Per particular person)
Naming conference – clarify the naming conference you used.
Information Dictionary(want in excel)
10 rows of dummy information in every desk (the place doable)(neeed in excel)
DDL Scripts for every desk, PK, and FK
Utilizing https://app.diagrams.internet/ create the ERD utilizing Crow’s Foot Notation (No different Notation can be accepted)
If you’re working as a crew, be sure that it’s apparent who created which items. Shade code the ERD, displaying who did what.
One particular person ought to submit the venture for the crew.
Any enterprise that is not a bicycle retailer (gross sales/restore) is eligible.
20 Tables for 1 particular person
(Every desk has a mean of 5 columns.) Necessary observe: I want a complete of 100 attributes throughout 20 tables (it might be both 5-6 attributes 1 desk or Three-Four attributes in one other desk)
The information ought to be normalized to the third regular type.
Give a transparent rationalization of why you deliberate this breach in 1 (per particular person) occasion when the first, 2nd, or third regular type is violated (you may have multiple, however it should be defined)
For every desk, create Choose/Insert/Replace/Delete statements (apart from many-to-many tables)
Create a minimal of 12 enterprise guidelines, with not less than 10 of them being embedded into the design (Per particular person)
Clarify the way you got here up along with your naming conference.
Dictionary of Information (want in excel)