Questions from Database Management


Q: Refer to Problem and Exercise 2-44 in Chapter 2,

Refer to Problem and Exercise 2-44 in Chapter 2, Part f. Redraw the ERD for your answer to this exercise using appropriate supertypes and subtypes. Data from Problem and Exercise 2-44: Virtual Campus...

See Answer

Q: An electronics goods store has devices such as mobile phones, laptops

An electronics goods store has devices such as mobile phones, laptops, televisions, and refrigerators for sale. a. Is it possible to apply a supertype/subtype hierarchy to this situation? How? b. Cons...

See Answer

Q: Observe the kind of people who work in your college or university

Observe the kind of people who work in your college or university. Interview an official who collects data on these people. Ask about the attributes on which data is collected. Is there a supertype/su...

See Answer

Q: An institute’s students participate in three types of sports events: long

An institute’s students participate in three types of sports events: long jump, discus throw, and the 100-meter race. The following attributes are recorded for each event: Long Jump: Student Roll Numb...

See Answer

Q: Refer to your answer to Problem and Exercise 2-44 in

Refer to your answer to Problem and Exercise 2-44 in Chapter 2. Develop entity clusters for the final version of this E-R diagram and redraw the diagram using the entity clusters. Explain why you chos...

See Answer

Q: Refer to your answer to Problem and Exercise 3-24.

Refer to your answer to Problem and Exercise 3-24. Develop entity clusters for this E-R diagram and redraw the diagram using the entity clusters. Explain why you chose the entity clusters you used. D...

See Answer

Q: Draw an EER diagram for the following problem using this text’s EER

Draw an EER diagram for the following problem using this text’s EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor: In a typical university,...

See Answer

Q: Draw an EER diagram for the following problem: AmazingMemories, a

Draw an EER diagram for the following problem: AmazingMemories, a travel agency, specializes in holidays to Southeast Asia. It provides bespoke holidays that are set up and handled by an agency rep. E...

See Answer

Q: Develop an EER model for the following situation using the traditional EER

Develop an EER model for the following situation using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor: Wally Los Gatos an...

See Answer

Q: Based on the EER diagram constructed for Problem and Exercise 3-

Based on the EER diagram constructed for Problem and Exercise 3-34, develop a sample definition for each entity type, attribute, and relationship in the diagram. Data from Problem and Exercise 3-34:...

See Answer