Select Page

Step 1. Place your order

Fill in the order form and provide all details of your assignment.

Step 2. Make Payment

Choose the payment system that suits you most.

Step 3. Receive your paper

Once your paper is ready, we will email it to you.

Project Can be any business other than a bicycle shop (sales/repair) 1 Person 20

by | Apr 23, 2022 | Computer Science homework help

 

Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates

For This or a Similar Paper Click To Order Now

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.

 

Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates

For This or a Similar Paper Click To Order Now

Treat Yourself to Much Needed Assistance