Computer Science

DATA BASE DESIGN

 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 Co

May 12, 2025 1 views

Check out this sample solution our expert writers created for a client with a "write assignment" task.

 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 for the team.

Need a similar assignment?

Our expert writers can help you with your specific requirements. Get started today.

Order Your Custom Solution

Get a Price Estimate

Price Estimate

Deadline.

Number of Pages.

Price: $12

Order Now

Why Students Choose Us

  • 150+ subject experts with advanced degrees
  • 100% original work with plagiarism reports
  • Secure confidentiality and data protection
  • 24/7 customer support and progress updates
  • Unlimited revisions until you're satisfied