Answered step by step
Verified Expert Solution
Link Copied!

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Mary Z. Last

8th edition

1285427106, 978-1285427102

More Books

Students also viewed these Databases questions