Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Design a normalized (3NF) database representing one or more of the following datasets. Each table must have multiple fields and no repeating groups, with
Design a normalized (3NF) database representing one or more of the following datasets. Each table must have multiple fields and no repeating groups, with each field dependent upon the entire primary key. This is a logical design only (do not use a DBMS). The physical design will be added in a future lesson. Use the following syntax to document your completed design. Use PascalCase for table and field names. Table names should be plural. Tablel (PrimaryKey, Field2, Field3, ...) Table2 (PrimaryKey, Field2, Field3, ...) 1. A car dealership wants a database to track sales by customer, vehicle, and sales person. 2. A college wants a database to track enrollment by student, course, and instructor. 3. A company wants a database to track their organizational structure by department, employee, and location. 4. A computer repair company wants a database to track repairs by customer, computer, and technician. 5. A doctor's office wants a database to track patient visits by doctor, patient, and visit. 6. A library wants a database to track books by title, author, and genre. 7. A YouTube subscriber wants a database to track videos by subject, YouTuber, and playlist. 8. Choose your own dataset similar to the above with at least three related entities.
Step by Step Solution
★★★★★
3.35 Rating (158 Votes )
There are 3 Steps involved in it
Step: 1
Here are normalized 3NF database designs for the provided datasets 1 Car Dealership Database Customers CustomerID FirstName LastName Email Phone Address CustomerID Primary Key Vehicles VehicleID Make ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started