Design a normalized (3NF) database representing one or more of the following datasets. Each table must...

Transcribed Image Text:

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. 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.