I include the template given by the professor. Please do not copy from any sources .
NO PLAGIARISM
ONLY RESPONSE WHO CAN DO IT
Venture
May be any enterprise apart from a bicycle store (gross sales/restore)
1 Individual 20 Tables
2 Individuals 38 Tables
three Individuals 56 Tables
four Individuals 74 Tables
(Common 5 Columns per desk)
Needs to be normalized to third Regular Kind
1 (per individual) occasion the place 1st, 2nd, or third regular kind is violated, give an in depth rationalization as to why you designed this violation (you possibly can have a couple of, but it surely should be defined)
Create Choose/Insert/Replace/Delete statements for every desk (apart from many-to-many tables)
Create at the very least 12 enterprise guidelines, 10 needs to be constructed into the design (Per individual)
Naming conference – clarify the naming conference you used.
Knowledge Dictionary
10 rows of dummy knowledge in every desk (the place doable)
DDL Scripts for every desk, PK, and FK
Utilizing https://app.diagrams.web/ create the ERD utilizing Crow’s Foot Notation (No different Notation shall be accepted)
If you’re working as a workforce, be sure that it’s apparent who created which items. Colour code the ERD, displaying who did what.
One individual ought to submit the mission for the workforce.
instpubs.sql
instnwnd.sql
Chinook_SqlServer.sql
Adventureworks.sql
Knowledge Dictionary Template.xlsx
————–
I use the template that the professor offered. Please do not plagiarize from any sources.
NO plagiarized content material
ONLY THOSE WHO ARE ABLE TO RESPOND
Venture
Any enterprise that is not a bicycle retailer (gross sales/restore) is eligible.
20 Tables for 1 individual
38 Tables for two Individuals
three Tables 56 Individuals
74 Tables for four Individuals
(Every desk has a mean of 5 columns.)
The info needs to be normalized to the third regular kind.
Give a transparent rationalization of why you deliberate this breach in 1 (per individual) occasion when the 1st, 2nd, or third regular kind is violated (you possibly can have a couple of, but it surely 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 at the very least 10 of them being embedded into the design (Per individual)
Clarify the naming conference.
