Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 3, Problem 3.36PAE
Program Plan Intro
Draw an ERR model for the given scenario with addition of supertypes and subtypes.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The 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.
1. Indicate the changes you need to make to the design of the BITS database to support the following situation. A client is not necessarily represented by a single consultant but can be represented by several consultants.
please answer with proper explanation and step by step solution.
Question:
Briefly describe the difference between the domain of an attribute and the data type of an attribute. Why do we need to distinguish between them?
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
Similar questions
- The 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. 4. Indicate 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, which may not be the same as the territory to which the client's consultant is assigned.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. 3. Indicate 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 signle 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.arrow_forwardBased on 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. 2. Indicate the changes you need to make to the design of the BITS database to support the following situation. There is no relationship between clients and consultants. When a client places an order (service request), it may be performed by any consultant. On the order, identify both the client placing the order and the consultant responsible for the order.arrow_forward
- Draw an ERD that shows the entities, attributes, primary key(s), foreign key(s), and relationships. Each relationship must be labeled. List all identifying relationships (if any). List all non-identifying relationships (if any). List all independent entities (if any). List all dependent entities (if any). Whenever patients are seen for the first time, they complete a patient information form that asks their name, address, phone number, and insurance carrier, all of which are stored in the patient information file. Patients signed up to be seen by doctor must be a member of at least one insurance carrier. Each time a patient visits the doctor, an insurance claim is generated and will later be sent to the carrier for payment. The claim must contain information about the visit, such as date, purpose, and cost. It would be possible for a patient to submit two claims on the same day. The relational notation for the database is: Patient (Patient ID, Name, Address, Phone, Primary Carrier,…arrow_forwardPart 2: Relational data model. Take a subset of the ideas from the conceptual model you constructed in Part 1 and design a simple relationship model similar to the ones we discussed in Module 2, Video 4 Your model should have at least 5 tables You should include at least 20 attributes, or fields, in your model (20 total across all tables, not per table) Your model should be normalized Identify the primary key in each table, and state whether it is a natural or surrogate key For each relationship between tables, identify any foreign keys needed to define the relationship For each table, identify what type of system or systems you think the data might come from, like those we discussed in Module 1, Video 6.arrow_forwardNote: Please make sure that all the points/rules must be implemented.Draw the ERD Diagram to create relational model corresponding to the described Scenario. The loan office in a bank receives from various parties, requests to investigate the credit status of aCustomers. Each credit request is identified by a Request ID and is described by a Request Date andRequesting party Name. The loan office also received results of credit checks. A credit check is identifiedBy a credit check ID and is described by the credit check Date and the credit rating. The loan officeMatches credit requests with credit check results. A credit request may be recorded before its resultArrives; a particular credit result may be used in support of several credit requests. Draw ERD for thisSituation. Requirements:ER Diagram of system implemented in tool such as Sqlyog & Draw.io (Available online).arrow_forward
- Please make the authentic ERD AND RELATIONAL MODEL BY KEEPING ALL RULES OF IT IN MIND A cooking club organizes several dinners for its members. The purpose of the club is to allow several members to get together and prepare a dinner for the other members. The club president maintains a database that plans each meal and tracks which members attends each dinner, and also keeps track of which members creates each dinner. Each dinner serves many members and any member is allowed to attend. Each dinner has an invitation. This invitation is mailed to each member. The invitation includes the date of the dinner and location. Data about members like their name, membership no, contact no and email address are saved.Each dinner is based on a single entrée (starter) and a single dessert. This entrée and dessert can be used again for other dinners.• Consider the above scenario you are required to create ERD for the above scenario first then covert the ERD into Relational Modelarrow_forwardDesign an Entity-Relationship for each system described below. Use the (min,max) notation. State clearly any additional assumptions you make. Give the relational model by applying the mapping rules (WITH REFERENCES AND ARROWS). NOTE: USE CHEN ER DIAGRAM (YOU CAN USE VISIO MICROSOFT(TEMPLATE=CHEN) ONLY SHOWING THE ENTITIES/ATTRIBUTES/WEAK ENTITIES/RELATIONSHIPS/PRIMARY KEY-FK/ (MIN-MAX) NOTATIONS ALSO NOT FORGETTING THE REFERENCES ON THE MAPPING TABLES WITH ARROWS REFERRING THE FOREIGN KEYS. YOUR WORK SHOULD BE SPECIFIC WITH JUSTIFICATION. We want to build a database for a community of paleontologists, storing information about the fossils kept in different museums. Each fossil is described by the year and place of discovery, the name of the paleontologist who discovered it, the room where it is exposed, and the presumed species. Each fossil may be assigned to different species with different degrees of probability. Museums are characterized by their rooms, their paleontologists and…arrow_forward# Question 2. Please select the correct statement(s) regarding keys in relational models. A. A candidate key is a key (super key) with a minimal set of attributes (cannot remove any attributes from this set, and the remaining one(s) still satisfy the key constraint). B. A candidate key is another term for key (super key) in relational models, and they have exactly the same meaning. C. One of the candidate key(s) is selected to be the primary key, and other candidate keys can be declared as UNIQUE. D. We can select multiple candidate keys to be multiple primary keys for a relation (multiple primary keys, not a primary key with multiple attributes). E. The attribute in a primary key does not accept NULL.arrow_forward
- Read the scenario carefully You have to propose and optimal database design in RDBMS for a super store. In which clients came and can purchase products according to their likes and dislikes. Super store have same products of different companies. In the end client received a receipt of their purchase from counter he/she go for bill. Database also save records of stock according to FIFO system.Your required to define1) Entities and their attributes2) Attributes Types 3) Each Attribute Required space.4) Define keys of each entity 5) Defile relationship between the entities.arrow_forwardWhat is the objective of a business rule in data modelling? Actually, Data model is very important tool because it is something which is sued for designing the database for a DBMS and no DBMS can exist independent of any data model, now if we use a specific DBMS but are not sure about the data model it uses for data abase usage, we can not create a proper database. What is the objective of a business rule in data modelling?arrow_forward1. There are several attribute relationships, including partial dependency and transitive, give an example of the two relationships.2. Why do we do the normalization stage in database design, especially in the logical stage?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database 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 LearningA Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher: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
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr