Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 3, Problem 3.33PAE
Program Plan Intro
Draw an ERR model for the given scenario.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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:
An international school of technology has hired you to create a database management system to
assist in scheduling classes. After several interviews with the president, you have come up with
the following list of entities, attributes, and initial business rules:
• Room is identified by Building ID and Room No and also has a Capacity. A room can be
either a lab or a classroom. If it is a classroom, it has an additional attribute called Board
Type.
• Media is identified by MType ID and has attributes of Media Type and Type Description.
Note: Here we are tracking type of media (such as a VCR, projector, etc.), not the
individual piece of equipment. Tracking of equipment is outside the scope of this project.
• Computer is identified by CType ID and has attributes Computer Type, Type Description,…
Develop an EER model for the following situation using EER notation, as specified by your instructor.
An international school of technology has hired you to create a database management system to assist in scheduling classes. After several interviews with the president, you have come up with the following list of entities, attributes, and initial business rules:
• Room is identified by Building ID and Room No and also has a Capacity. A room can be either a lab or a classroom. If it is a classroom, it has an additional attribute called Board Type.
• Media is identified by MType ID and has attributes of Media Type and Type Description. Note: here we are tracking type of media (such as a DVD, projector, etc.), not the individual piece of equipment. Tracking of equipment is outside of the scope of this project.
• Computer is identified by CType ID and has attributes of Computer Type and Type Description, Disk Capacity, and Processor Speed. Please note: as with Media Type, we are tracking…
Consider the following business rule:An employee can manage multiple customers. A customer can be managed by multiple employees.
How does this business rule(s) affect the database design?
a.)
The business rules define that there isn't a need for a relationship between the EMPLOYEE and CUSTOMER entities, as the relationship isn't a strong one.
b.)
The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and a 1:M relationship between those two entities.
c.)
The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and an M:N relationship between those two entities requiring a bridge table.
d.)
The business rules define that there is a relationship between EMPLOYEE and CUSTOMER, and a 1:1 relationship between those two entities.
Chapter 3 Solutions
Modern Database Management
Ch. 3 - Define each of the following terms: supertype...Ch. 3 - Match the following terms and definitions:...Ch. 3 - Contrast the following terms: supertype; subtype...Ch. 3 - State two conditions that indicate when a database...Ch. 3 - Prob. 3.5RQCh. 3 - Give an example (other than those discussed in the...Ch. 3 - What is the attribute inheritance? Why is it...Ch. 3 - Give an example of each of the following: a...Ch. 3 - What types of business rules are normally captured...Ch. 3 - What is the purpose of a subtype discriminator?
Ch. 3 - Prob. 3.11RQCh. 3 - In what ways is starting a data modeling project...Ch. 3 - Prob. 3.13RQCh. 3 - Prob. 3.14RQCh. 3 - What do you purchase when you acquire a packaged...Ch. 3 - In Figure 3-5b, why must the minimum cardinality...Ch. 3 - When is a member of a supertype always a member of...Ch. 3 - Examine the hierarchy for the university EER...Ch. 3 - Add a subtype discriminator for each of the...Ch. 3 - For simplicity, subtype discriminators were left...Ch. 3 - Refer to the employee EER diagram in Figure 3-2....Ch. 3 - Refer to the EER diagram for patients in Figure...Ch. 3 - Figure 3-13 shows the development Of entity...Ch. 3 - Refer to Problem and Exercise 2-44 in Chapter 2...Ch. 3 - For a library, the entity type HOLDING has four...Ch. 3 - A bank has three types of accounts: checking,...Ch. 3 - Refer to your answer to Problem and Exercise 2-4...Ch. 3 - Refer to your answer to Problem and Exercise 3-24...Ch. 3 - Prob. 3.29PAECh. 3 - Draw an EER diagram for the following situation:...Ch. 3 - Develop an EER model for the following situation,...Ch. 3 - Prob. 3.32PAECh. 3 - Prob. 3.33PAECh. 3 - Prob. 3.34PAECh. 3 - Based on the EER diagram constructed for Problem...Ch. 3 - Prob. 3.36PAECh. 3 - Prob. 3.37PAECh. 3 - Add the following to Figure 3-16: An EMPLOYMENT...
Knowledge Booster
Similar questions
- An objective of this task is to denormalize a conceptual schema to speed up processing of a given class of applications. The following conceptual schema represents a database domain where the contract and permanent employees are assigned to the projects. (see image below) Requirements Steps Involved: - Elimination of generalization using Association, Subset or Superset method - Simplifications: •Elimination of association classes •Elimination of link attributes •Elimination of many-to-many associations Perform simplification of the conceptual schema above and re-draw the simplified conceptual schema.arrow_forwardThis test concerns database design, including both the logical design via the Entity Relationship (E - R) model and the physical model via relational database tables. The subject of the model is the registration of students in college classes, and there may be multiple classes for each course. The college model should include: courses (for example the CBU catalog), the current classes (or course-sections) given for courses (for example the CBU schedule for a term), the faculty qualified to teach courses, the scheduling of classes (to buildings/rooms, times, and faculty members), the assignment of faculty to students for advising (1 advisor per student), and the scheduling of students to classes.For unique identifiers you can use the following abbreviations:SID Student IDCID Course ID (ie MIS 471, …)SEC Course Section (ie A, B, C, …)BID Building ID (ie BU, BH, K, …)RID Room NumberFID Faculty IDTID Timeslot ID (ie TR 9:30, MWF 8am, …)CRN Course Record Number (an auto key for each…arrow_forwardConsider the following Scenario.Design a database for an airline. The database must keep track of customers andtheir reservations, flights and their status, seat assignments on individual flights,and the schedule and routing of future flights. Your design should include an E-Rdiagram, a set of relational schemas, and a list of constraints, including primary-keyand foreign-key constraints.Please determine the entities, attributes and relationships that should exist in thedatabase and draw an E-R diagram.arrow_forward
Recommended textbooks for you
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
- Fundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning