Q Draw an E-R diagram for each of the followingsituations : Q Draw an E-R diagra

Question

Q Draw an E-R diagram for each of the followingsituations:

Q Draw an E-R diagram for each of the followingsituations:

1. Each of Corporation division is composed of many departments.Each of the departments has many employees assigned to it, but eachemployee works for only one department. The attributes of EMPLOYEEinclude NAME, ADDRESS, BIRTHDATE and the attributes of DEPARTMENTare DEPT_NO and DEPT_NAME.  

2. During some period of time, a customer can rent many videosfrom the Video Store. Each of the VideoStore’s can be rentedto many customers during that period oftime.   

3. An Airline can be assigned to fly many flights, but each flightis flown by only oneairline.              

Explanation / Answer

b) During some period of time, a customer can rent many videotapes from the BigVid store. Each of the BigVid’s videotapes can be rented to many customers during that period of time. solution

c) An airline can be assigned to fly many flights, but each flight is flown by only one airline . solution

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.