EBK MODERN DATABASE MANAGEMENT,
13th Edition
ISBN: 9780134792279
Author: TOPI
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 3, Problem 3.34PAE
Program Plan Intro
Draw an EER model for the given situation using EER notation, Visio notation or the subtypes inside supertypes notation.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students 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…
Please written by computer source
Part I - Modeling You are building a database for a comic book store customer management system. Given the database specification below, your job is to turn the specification into an ER diagram. Your notation must be consistent with the notation used in our lecture notes. You can use all constructs and notations discussed in our lecture notes and nothing else (i.e.. oven notations used in the textbooks but not in our lectures cannot be used). Your ER diagram should capture all the information and constraints in the specification but, at the same time, be minimal. It means that redundant entities, relationships, attributes and constraints should be avoided. You may use any drawing tool of your choice (for example, Dia, diagrams.net, Lucidchart, etc.) to draw your ER diagram. Hand drawings will not be accepted. Database Specification The database keeps information about comic books, customers, orders, inventory and reviews. First, the database should…
Chapter 3 Solutions
EBK 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
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Subject: Database Topic: EERD Please use UML Modelling Notation. (Don't use Chen’s Notation or Crow’s Feet Notation). The attached EERD is not the answer. it's for your reference only about UML Modelling Notation. -Based on the information given below, draw the conceptual EERD where you should include the enhanced features. You are required to design a database for a car championship. The requirements are as follows: In the championship, each car’s information such as the car model, the top speed and the acceleration will be stored, and it is identifiable through a unique car ID. Each car will be drove by only one driver. Each driver’s info such as the unique driver number, driver name and the experience level of the driver are stored as well. A driver may have many trainers from more experience drivers and these experience drivers would have at least one trainee who follow them. Each of these drivers are usually supported by a team which each team have a name and is identifiable…arrow_forwardSubject: Database Topic: EERD Please use UML Modelling Notation. (Don't use Chen’s Notation or Crow’s Feet Notation). The attached EERD is not the answer. it's for your reference only about UML Modelling Notation. -Based on the information given below, draw the conceptual EERD where you should include the enhanced features. A car dealership wishes to maintain data about the customers who purchase a car. Each customer may purchase one or more vehicles and each vehicle can be purchased by many different customers over time (for example, a customer maypurchase a new vehicle, trade that vehicle in and someone else can purchase the vehicle traded in.) Data that the dealership wishes to keep regarding customers includes customer identification number, name, address, homephone, work phone, cell phone and e-mail address. Information about vehicle includes vehicle identification number, make, model, year, transmission type, engine size and color. Vehicles can be a member of one of the following…arrow_forwardThe ABC Engineering (ABCE) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company's training program. The ABCE administrator gives you the description of the training group's operating environment. ABCE has 12 instructors and can handle up to 30 trainees per class ● It offers five Advanced Technology courses, each of which may generate several classes. If a class has fewer than 10 trainees, it will be canceled. Therefore, it is possible for a course not to generate any classes Each class is taught by one instructor Each instructor may teach up to two classes or may be assigned to do research only Each trainee may take up to two classes per year Complete the table to define all of the entities and relationships. First one is done for you. Consider one of the relations as a composite relationship. ENTITY INSTRUCTOR RELATIONSHIP Teaches CONNECTIVITY 1:M ENTITY CLASSarrow_forward
- We want to design a database to allow queries of Mountain High RV inventory of new and used RVs. Assume there are three Mountain High RV dealership locations in a region that shares one relational database management system (RDBMS). The basic data fields for each RV include stock number (a common name for SKU (Stock Keeping Unit)), vehicle identification number (VIN), condition (new or used), type (or class), make, model, year, color and price. Identify the possible candidate keys, the likely primary key, probably foreign keys, and potential secondary keys for the Vehicle table. Identify other tables the Vehicle table might need to form a relationship (or link with) to support Mountain High operations.arrow_forwardThe ABC Engineering (ABCE) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company's training program. The ABCE administrator gives you the description of the training group's operating environment. ABCE has 12 instructors and can handle up to 30 trainees per class ● ● It offers five Advanced Technology courses, each of which may generate several classes. If a class has fewer than 10 trainees, it will be canceled. Therefore, it is possible for a course not to generate any classes Each class is taught by one instructor Each instructor may teach up to two classes or may be assigned to do research only Each trainee may take up to two classes per year Create an ERD to show the relationship between the entities listed in Part (a). If there are any M:N relations, create a composite entity to serve as a bridge.arrow_forwardQuestion a. Normalization is an important concept for database professionals. Whether you are the designer, database analyst or administrator, it is useful for designing, situation verification as well as performance tuning. In your opinion discuss the basic issues to be aware of before carrying out the normalization process. b. Given the following relational schema and its functional dependencies: Rentallnfo custNo propertyNo custName pAddress rentStart ownerNo OName fd1 fd2 fd3 fd4 fd5 Specify candidate keys and state the primary key. Assuming that the relation is in first normal form (1NF), describe and illustrate the process of normalizing the relational schema to second (2NF) and third (3NF) normal forms. Identify the primary and foreign keys in your third normal forms. ii.arrow_forward
- Subject: Database Topic: EERD Please use UML Modelling Notation. (Don't use Chen’s Notation or Crow’s Feet Notation) -Based on the information given below, draw the conceptual EERD where you should include the enhanced features. A car dealership wishes to maintain data about the customers who purchase a car. Each customer may purchase one or more vehicles and each vehicle can be purchased by many different customers over time (for example, a customer maypurchase a new vehicle, trade that vehicle in and someone else can purchase the vehicle traded in.) Data that the dealership wishes to keep regarding customers includes customer identification number, name, address, homephone, work phone, cell phone and e-mail address. Information about vehicle includes vehicle identification number, make, model, year, transmission type, engine size and color. Vehicles can be a member of one of the following categories: cars, trucks, minivans or SUVS. A vehicle can be amember of only one category at a…arrow_forwardConsider 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.arrow_forwardThe following exercises are based on the BITS database user views as designed in Your Turn 6-1 in this chapter. In each exercise, represent your answer in DBDL and with an Entity Relationship Diagram. 5. Indicate the changes you need to make to the BITS database design to support the following situation. The client address may or may not be the same as the Bill To address on the client's invoice.arrow_forward
- USE PAPER TO MAKE THE UML DESIGN For the example below Create the proper UML Design for your DB system. Assume the following scenario: Due to COVID-19 pandemic Your client has decided to design a database system to control the number of reservations on their resort mountain. The reservation system will take in consideration the following criteria. The maximum allocation based on the product type, take in consideration that the reservation type can be expanded in the future to more than these basic types. The reservation types are Tubing. Mountain. The Product Variant will store information such as the reservation type, the session that the product use such as: Session 1 Reservation. Session 2 Reservation. Session 3 Reservation. Session 3 in the Reservation require that both Session 1 and Session 2 to have availability in the system. The Maximum reservation limit depends on the minimum availability for the 3 Session in the system. Each day has its own reservation limit.…arrow_forwardQuestion 4 Given the Database Design Language (DBDL) for Rio Massage Centre as follows: Note: Date format is 'DD/MM/YYYY'. Customer(CustID, CustName, CustContact) Therapist (TheralD, TheraName, TheraContact, TheraBiodata) Service (ServicelD, ServiceDesc, Price) CustomerAppointment (ApptNo, RecordDate, ApptDate, ArrivalTime, CustID*) AppointmentDetails (ApptNo*, ServicelD*, AddOnCharges, TheralD*) You are required to use the aliases for the given tables as below (whenever it is appropriate): • for Customer, T for Therapist, S for Service, CA for CustomerAppointment, A for AppointmentDetails. Question 4 continued Write a Structured Query Language (SQL) statement for each of the following questions: Create the AppointmentDetails table with the following requirements: Appropriate data types. • All keys can store between 6 to 10 characters. • All the columns must have values (cannot be empty). • Add on charges is set to 0.00 by default. Enforce entity and referential integrities. a)arrow_forwardIndicate the changes you need to make to the BITS database design to support the following situation. The region where clients are located is divided into territories. For each territory, store the territory number (a unique identifier) and territory name. Each consultant is assigned to a single territory. Each client also is assigned to a single territory, but the territory must be the same as the territory to which the client’s consultant is assigned. Could you also please make a diagram that shows me the type of relation between tables? for example, if it lines of the connectiones finishes with a dot or something like that.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Database 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
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher: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: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
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning