I include the template given by the professor. Please do not copy from any sources .
NO PLAGIARISM
ONLY RESPONSE WHO CAN DO IT
Project
Can be any business other than a bicycle shop (sales/repair)
1 Person 20 Tables
2 People 38 Tables
3 People 56 Tables
4 People 74 Tables
(Average 5 Columns per 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
10 rows of dummy data in each table (where possible)
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 ( help with nursing paper writing from experts with MSN & DNP degrees) for the team.
instpubs.sql
instnwnd.sql
Chinook_SqlServer.sql
Adventureworks.sql
Data Dictionary Template.xlsx
————–
I use the template that the professor provided. Please don’t plagiarize from any sources.
Get a custom-written paper by an expert in this subject. Plagiarism-free, on time, any citation style.
- ✓ PhD & Masters qualified writers
- ✓ Turnitin-safe — 0% similarity
- ✓ Free revisions + money-back guarantee
From $11/page · All academic levels
NO plagiarized content
ONLY THOSE WHO ARE ABLE TO RESPOND
Project
Any business that isn’t a bicycle store (sales/repair) is eligible.
20 Tables for 1 person
Our expert writers specialise in this subject and deliver original, well-researched papers.
Nursing & Healthcare · PhD Edinburgh
Business & Law · MBA London
38 Tables for 2 People
3 Tables 56 People
74 Tables for 4 People
(Each table has an average of 5 columns.)
Join 12,400+ students who trust us with their academic success. Every order includes: free revisions within 30 days, plagiarism report, on-time delivery guarantee, and full confidentiality.
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 the naming convention.
