The following Figure 2 shows an EER schema for a database that can be used to track sales at a car dealership. Map this schema into a relational data model, including all primary keys and referential integrity constraints (foreign keys). For the VEHICLE to CAR/TRUCK/SUV generalization, consider the four Step 8 options presented in the lecture notes for mapping specializations/generalizations. Show the relational schema design under each of those four options (8A, 8B, 8C, 8D).

Swing Jazz Club ERD Problem Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information.   Remember the ERD will eventually turn into the design for a database from a top down view.  Make sure you resolve any many to many conflicts.  Label an identifier or primary key and all pertinent attributes given.   If an attribute is not readily apparent from the user information, then make one up that makes sense for the particular entity.  Therefore, all entities should end up with at least an identifier and another attribute that makes sense.  You may use any of the approaches shown by the book, though the ER-Model and Crow’s foot are the most common.  Make sure you show entities, relationships, cardinality, and optionality.  Swing Jazz Club The Swing Jazz Club teaches swing and jazz dancing and offers both private and group lessons.  Swing Jazz charges $60 dollars per hour for a private lesson and $10 dollars per hour for a group lesson.…

The ABC Engineering (ABCE) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company's training program. The ABCE administrator gives you the description of the training group's operating environment. ABCE has 12 instructors and can handle up to 30 trainees per class ● It offers five Advanced Technology courses, each of which may generate several classes. If a class has fewer than 10 trainees, it will be canceled. Therefore, it is possible for a course not to generate any classes Each class is taught by one instructor Each instructor may teach up to two classes or may be assigned to do research only Each trainee may take up to two classes per year Complete the table to define all of the entities and relationships. First one is done for you. Consider one of the relations as a composite relationship. ENTITY INSTRUCTOR RELATIONSHIP Teaches CONNECTIVITY 1:M ENTITY CLASS