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. Table1(PrimaryKey, Field2, Field3, ...) Table2(PrimaryKey, Field2, Field3, ...)

Create a text document with your logical database design (table names and field names) for one of the listed datasets

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.

8. Choose your own dataset similar to the above with at least three related entities.

The requirements are:

A company wants a database to track their organizational structure by department, employee, and location.

I don't see any location information.

The requirements are to use the format:

Table1(PrimaryKey, Field2, Field3, ...)

Please write using this format.