Venture
Can be any business other than a bicycle shop (gross sales/restore)
1 Individual 20 Tables
(Common 5 Columns per desk) Vital notice: I want 100 attributes in complete in 20 20 tables(it might be both 5-6 attributes 1 desk or Three-Four attributes in one other desk)
Ought to be normalized to third Regular Type
1 (per particular person) occasion the place 1st, 2nd, or third regular kind is violated, give a detailed rationalization as to why you designed this violation (you possibly can have extra than one, however it should be defined)
Create Choose/Insert/Replace/Delete statements for every desk (other than many-to-many tables)
Create not less than 12 business guidelines, 10 ought to be constructed into the design (Per particular person)
Naming conference – clarify the naming conference you used.
Knowledge 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 other Notation will be accepted)
In case you are working as a staff, be certain it’s apparent who created which items. Coloration code the ERD, exhibiting who did what.
One particular person ought to submit the undertaking for the staff.
—
Venture
Any business 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.) Vital notice: 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 info ought to be normalized to the third regular kind.
Give a clear rationalization of why you deliberate this breach in 1 (per particular person) occasion when the first, 2nd, or third regular kind is violated (you possibly can have extra than one, however it should be defined)
For every desk, create Choose/Insert/Replace/Delete statements (other than many-to-many tables)
Create a minimal of 12 business 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 Knowledge (want in excel)
10
