Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 3, Problem 3.25PAE
For a library, the entity type HOLDING has four subtypes: BOOK, AUDIO BOOK DVD, and SOFTWARE. Draw a separate EER diagram segment for each of the following situations:
- At a given time, a holding must be exactly one of these subtypes.
- A holding may or may not be one of these subtypes. However, a holding that is one of these subtypes cannot at the same time be one of the other subtypes.
- A holding may or may not be one of these subtypes. On the other hand, a holding may be any two (or even four) of these subtypes at the same time.
- At a given time, a holding must be at least one of these subtypes.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The distinction between a weak and a strong entity collection has to be clarified.
ENHANCED CHEN METHODOLOGYEER MODEL3-25For a library, the entity type HOLDING has four sub-types: BOOK, AUDIO BOOK, DVD, and SOFTWARE. Draw a separate EER diagram segment for each of the following situations:a. At a given time, a holding must be exactly one of these subtypes.b. A holding may or may not be one of these subtypes. However, a holding that is one of these subtypes cannot at the same time be one of the other subtypes.c. A holding may or may not be one of these subtypes. On the other hand, a holding may be any two (or even four) of these subtypes at the same time.d. At a given time, a holding must be at least one of these subtypes. 3-26A bank has three types of accounts: checking, savings, and loan. Following are the attributes for each type of account:CHECKING: Acct No, Date Opened, Balance, Service ChargeSAVINGS: Acct No, Date Opened, Balance, Interest RateLOAN: Acct No, Date Opened, Balance, Interest Rate, PaymentAssume that each bank account must be a member of exactly one…
The following ERD refers to an borrow system of a library. Member can borrow different books, which were written by different authors and published by different publishers. A writer can be contracted to one or more publishers. Each member can have different borrows with different books to different expiring dates.a)Give two Attributes for each entity. Draw them directly into the ER-diagram. b)Give a primary key for each entity. Draw it directly into the ER-diagram. c)Create the SQL statement for implementing the table for one of the entities of the up standing ERD
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
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
- The disjoint rule specifies that if an entity instance of the supertype is a member of one subtype, it MUST simultaneously be a member of another subtype. Select one: O a. FALSE O b. TRUEarrow_forwardTalk about what weak and strong entity sets are.arrow_forwardEER MODEL IN THIS ONE EXPERT ALREADY ANSWERD TILL 3-25 c SO I NEED ANS FROM D 3-25For a library, the entity type HOLDING has four sub-types: BOOK, AUDIO BOOK, DVD, and SOFTWARE. Draw a separate EER diagram segment for each of the following situations:a. At a given time, a holding must be exactly one of these subtypes.b. A holding may or may not be one of these subtypes. However, a holding that is one of these subtypes cannot at the same time be one of the other subtypes.c. A holding may or may not be one of these subtypes. On the other hand, a holding may be any two (or even four) of these subtypes at the same time.d. At a given time, a holding must be at least one of these subtypes. 3-26A bank has three types of accounts: checking, savings, and loan. Following are the attributes for each type of account:CHECKING: Acct No, Date Opened, Balance, Service ChargeSAVINGS: Acct No, Date Opened, Balance, Interest RateLOAN: Acct No, Date Opened, Balance, Interest Rate, PaymentAssume that each…arrow_forward
- Construct an (E)ER diagram for a hospital system with the following requirements: Patients are described using unique ss# as well as name, insurance, admitted date, and checked-out date Doctors are described using unique dss# as well as their names and specialization. Each patient may have a set of tests, described by test id, test name, date, time, and results. These tests are performed by doctors. Then convert the (E)ER diagram to a collection of relation tables (Relational database schema). Determine all the primary and foreign keys.arrow_forwardPrepare an Entity Relationship Diagram for the application described in the following paragraph. Pick and Shovel Construction Company is a multi-state building contractor specializing in medium-priced town homes. Assume that Pick and Shovel’s main entities are its customers, employees, projects and equipment. A customer can hire the company for more than one project, and employees sometimes work on more than one project at a time. Equipment, however, is assigned to only one project at a time. Draw an ERD showing those entities.arrow_forwardDraw an Entity Relationship Diagram for all of those below. (a simple one) Each lecturer is identified by a unique number, name and phone. A lecturer teaches several courses, and for each course there is a unique code and title (not necessarily unique). There might be several lecturers in a course. Each course requires one or more text books. Each text book is used in at least one course. A text book is identified by a unique ISBN, and its title, authors, publisher and year of publication are known. Each course has a unique code. The bank has many customers. Every customer has at least one account with the bank. An account may be shared by several customers. Each customer has a unique number, type, the opening date and the balance. A flight carries many passengers on a specific airplane. Each airplane has a unique number, while each flight has a code (unique), destination and origin. A passenger has a name, passport number and nationalityarrow_forward
- Assuming that appropriate names are supplied for entity types, reference modes, and predicates and that appropriate constraints are added, which of the following conceptual schema diagrams are legal? Where illegal, briefly explain the error.arrow_forwardWhat distinguishes a weak entity set from a strong entity set?arrow_forwardExplain the difference between a candidatekey and the identifier of an entity type.arrow_forward
- Question 1:The following ERD refers to an borrow system of a library. Member can borrow different books, which were written by different authors and published by different publishers. A writer can be contracted to one or more publishers. Each member can have different borrows with different books to different expiring dates.a) Give two Attributes for each entity. Draw them directly into the ER-diagram. b) Give a primary key for each entity. Draw it directly into the ER-diagram. c) Create the SQL statement for implementing the table for one of the entities of the up standing ERD.arrow_forwardDraw an Entity Relationship Diagram for the following scenario A, B, and C are entities. There is a relationship between all three, called D. For each A and B there is one C. For each B and C there can be many A’s. For each A and C, there is one B. Every time the relationship, D, is satisfied, a single value, “Note”, will be storedarrow_forwardDesign an EER diagram for a library as described below. Show relevant constraints. a. Each employee has an SSN, fname, lname, and address. b. An employee is classified into one of three categories: managerial, research, and floor. Floor employees are paid by the hour and have an hourly wage rate. The other two categories have a salary. Research workers have a specialty, while managerial workers have a job title. c. Customers are identified by their card number, and also have a fname, lname, and address. d. Each book is identified by its LCN (Library of Congress Number). It has a title, and one or more authors. e. An author has as a key an author code, since fname, lname does not suffice. We also keep track of their birth date and date of death. f. Customers may check out books. We keep track of the date it was checked out, as well as the date of return if it has been returned. g. Each time a book is checked out, we want to track which employee was involved in that transaction.…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY