TOPIC 

COLLECT AN ER DIAGRAM  WITH  EXAMPLE (MUST CONTAIN ONE EXTENDED FEATURE).

QUESTION

A car selling shop sells variety of cars. Shop consists of two types of employee. They are salesman and mechanic. Complete an ER Diagram based on the information given below:

a)   Each employee  have employee number and name. Employe is identified using employee number.

b)   Each car sold by the shop had a car licence.Car is also specified for its manufacturer,model,value.

c)    Salesman buy a particular car by noting its date,price and value

d)   Salesman sells car by noting down the date,  commission ,values to the clients.

e)    Clients are the persons who buys car from the salesman.Client ID will refer  for each client. Salesman note down  client   name,address,phone for future use.

f)     Car shop will also take care of the repair job and is done by the mechanic.

g)   Each repair job is recorded by repair number, cost,description.Cost for repair job is calculated by the work done and the parts got repaired/changed.

 IDENTIFYING THE ENTITIES

a)    EMPLOYEE

 

b)    MECHANIC

 

c)    SALESMAN

 

d)    REPAIR JOB

 

e)    CAR

 

f)      CLIENT

 IDENTIFYING THE PRIMARY KEYS

a)    EMPLOYEE    >>  NUMBER

b)    REPAIR JOB  >>   NUMBER

c)     CAR               >>   LICENCE

d)    CLIENT         >>     ID

IDENTIFYING OTHER RELEVANT ATTRIBUTES.

a)    EMPLOYEE   >>   NAME

b)    REPAIR JOB  >>   DESCRIPTION , COST

c)     CAR              >>   MANUFACTURER , MODEL , YEAR

d)    CLIENT         >>   NAME , PHONE , ADDRESS

RELATIONSHIPS 

relation1

relation 2

ERDIA

Advertisements