Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A car dealer shop decides to store all information about the cars and the technicians by using a relational DBMS. Your task is to design

image text in transcribed
A car dealer shop decides to store all information about the cars and the technicians by using a relational DBMS. Your task is to design an EER model to organize such information. The requirements are summarized as follows: - The dealer has employees. Each employee has a unique identifier, a first name, a last name, a SSN, addresses, a phone, and a salary. There are two types of employees: Salespersons and Technicians. Every employee belongs to one of these types. Besides salary, a salesperson may get additional pay. The additional pay could include a cash bonus, commission, and profit sharing. - For insurance purposes, the dependents of an employee are tracked. Each dependent's first name, gender, birth date, age, and relationship to the employee are documented. - Each car is identified by its registration number aid has the year made, primary color, number of doors, and a window price. - Each car is of a specific model. - Each model is identified by a number. In addition, its capacity, horse power, and mile per gallon need to be recorded. - Each technician is certified for one or more model(s)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Informix Database Administrators Survival Guide

Authors: Joe Lumbley

1st Edition

0131243144, 978-0131243149

More Books

Students also viewed these Databases questions

Question

8 5 8 . .

Answered: 1 week ago