Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 4, Problem 4.39PAE
Program Plan Intro
(a)
To transform the given EER diagrams into relational schemas with functional dependencies and convert them into 3NF.
Program Plan Intro
(b)
To transform the given EER diagrams into relational schemas with functional dependencies and convert them into 3NF.
Program Plan Intro
(c)
To transform the given EER diagrams into relational schemas with functional dependencies and convert them into 3NF.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Answer D and E only
** ERD attached (the second picture)
** Relational model:
c) Entity Relationship to Relational Model:
To convert the given diagram to a relational model, below are the steps:
Create Relations from Diagram:
The relations in the model are as below:
1. Subscriber: (SubscriberID, Name, Address, Email, Phone)
2. SubscriptionTypes(TypeCode, Name, Description, DuartionDays)
3. Subscriptions(SubscriptionID, Price, StartDate, EndDate)
Solve the relationships by adding referential integration:
1) Subscription will have one Subscriber: Thus add a new foreign key SubscriberID
2) Subscription will have one SubscriptionType, thus add a new foreign key TypeCode.
FINAL RELATIONAL MODEL
1. Subscriber: (SubscriberID, Name, Address, Email, Phone)
Primary key: SubscriberID
Foreign key: NA
2. SubscriptionTypes(TypeCode, Name, Description, DuartionDays)
Primary key: TypeCode (Either D or S)
Foreign key: NA
3. Subscriptions(SubscriptionID, Price, StartDate, EndDate,…
Convert the following Conceptual Model to Relational Model.
# 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.
Chapter 4 Solutions
Modern Database Management
Ch. 4 - Define each of the following terms: determinant...Ch. 4 - Prob. 4.2RQCh. 4 - Prob. 4.3RQCh. 4 - Describe the primary differences between the...Ch. 4 - Summarize six important properties of relations.Ch. 4 - Describe two properties that each candidate key...Ch. 4 - Describe the three types of anomalies that can...Ch. 4 - Demonstrate each of the anomaly types with an...Ch. 4 - Fill in the blanks in each of the following...Ch. 4 - What is a well-structured relation? Why are...
Ch. 4 - Prob. 4.11RQCh. 4 - Describe how the following components of an E-R...Ch. 4 - Prob. 4.13RQCh. 4 - Prob. 4.14RQCh. 4 - Briefly describe four typical problems that often...Ch. 4 - Prob. 4.16RQCh. 4 - Explain how each of the following types of...Ch. 4 - Prob. 4.18RQCh. 4 - Prob. 4.19RQCh. 4 - Prob. 4.20RQCh. 4 - Prob. 4.21RQCh. 4 - What is the relationship between the primary key...Ch. 4 - Prob. 4.23RQCh. 4 - Explain what can be done with primary keys to...Ch. 4 - Prob. 4.25RQCh. 4 - Explain three conditions that suggest a surrogate...Ch. 4 - Prob. 4.27RQCh. 4 - For each of the following E-R diagrams from...Ch. 4 - Prob. 4.29PAECh. 4 - Prob. 4.30PAECh. 4 - For your answers to the following Problems and...Ch. 4 - Figure 4-3212 shows a class list for Millennium...Ch. 4 - Prob. 4.33PAECh. 4 - Prob. 4.34PAECh. 4 - Prob. 4.35PAECh. 4 - Prob. 4.36PAECh. 4 - Prob. 4.37PAECh. 4 - Prob. 4.38PAECh. 4 - Prob. 4.39PAECh. 4 - Transform Figure 2-15a, attribute version, to 3NF...Ch. 4 - The Public Safety office at Millennium College...Ch. 4 - Prob. 4.42PAECh. 4 - Prob. 4.43PAECh. 4 - Prob. 4.44PAECh. 4 - For your answers to Problem and Exercise 3-33 from...Ch. 4 - Prob. 4.46PAECh. 4 - Prob. 4.47PAECh. 4 - Figure 4-38 includes an EER diagram for a...Ch. 4 - Prob. 4.49PAECh. 4 - Prob. 4.50PAECh. 4 - Prob. 4.51PAECh. 4 - Prob. 4.52PAECh. 4 - Figure 4-40 shows an EER diagram for a university...Ch. 4 - Explore the data included in Table 4-9. Assume...Ch. 4 - Prob. 4.55PAECh. 4 - Prob. 4.56PAECh. 4 - Prob. 4.57PAECh. 4 - Prob. 4.58PAE
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
- a) Describe five features of a relational model in your own words.In your explanation, please include no more than five guidelines from the "Date's 12 rules of distribution."arrow_forwardThe text states that you can argue that “the only reason for having relations is to store instances of functional dependencies.” Explain, in your own words, what this meansarrow_forwardCourse: DataBase Management System Question no 01: Note: 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 a Customers. Each credit request is identified by a Request ID and is described by a Request Date and Requesting party Name. The loan office also received results of credit checks. A credit check is identified By a credit check ID and is described by the credit check Date and the credit rating. The loan office Matches credit requests with credit check results. A credit request may be recorded before its result Arrives; a particular credit result may be used in support of several credit requests. Draw ERD for this Situation. Requirements: ER Diagram of system implemented in tool such as Sqlyog & Draw.io (Available online). Note: DRAW ERD ASAParrow_forward
- A data model is a collection of data description constructs. The main purpose of a data modeling is to assist in the understanding of the meaning (semantics) of the data and facilitate communication about the information requirements. Discuss FIVE (5) evaluation criteria for a good data model. [Hint: As a database designer, you have to interview customers, you are required to include questions you may ask to customers in your answers]arrow_forwardThe following are the objectives for the design of the logical schema:arrow_forwardjust answer true/false a]Disjointness means that every entity of a supertype must be an entity in one of the subtypes in the generalization hierarchy. b]Record is a set of more fields that describe a person, place or thing. c]Cardinality is the number of tuples in a relation. d]Referential integrity must have null values only.arrow_forward
- Produce a relational schema diagram that corresponds to the linked ER diagram for a database for the television show Saturday Night Live (SNL). Your relational schema diagram should include primary and foreign keys. Often-times in database system development, requirements will change after the conceptual data model has been drafted: in your rela- tional schema diagram, add the following three additional attributes: attribute “birth.date" for the relation schema Host; attribute “start.date" for the relation schema Writer; and attribute “salary" for relation schema Cast Member. Please refer back to the requirements in Question 6, for additional details that may constrain the design of the relational schema model. Use the tool linked to create an image. Hints: please carefully note that "rerun date", “address", and “phone" are multi-valued attributes; how would those be depicted in the relational schema diagram? Also, please carefully note the many-to-many relationships; how would those…arrow_forwardQuestion 3 Normalize table 1 to a set of Third Normal Form (3NF) relations. Your answer should show all the three stages of normalization (1NF, 2NF and 3NF) by using the Database Design Language format (underline all primary keys, composite keys and use an * to indicate the foreign keys). State the component(s) that is/are removed from each Normal Form. Besides that, INF must be divided into repeating and non-repeating group relations. a) PatientID PatientName BloodID BloodType ExamDate DiseaselD DiseaseDesc HospitallD HospitalName 08/01/2020 D5001 08/01/2020 D3222 |11/11/2020 D5001 |11/11/2020 D7788 15/11/2020 D5001 12/12/2020 D3222 12/12/2020 D5001 Alice Hospital KL Hospital KL Hospital PJ Hospital SB Hospital SB Hospital KL Hospital PJ P7010 B001 B001 B001 A+ COVID-19 Н223 P7010 Alice A+ Diabetes H223 Alice Thomas P7010 A+ COVID-19 H881 P8888 B008 O- SARS H666 Penny Penny Julie P3000 B009 AB+ COVID-19 H666 P3000 B009 AB+ Diabetes H223 P4455 B008 0- COVID-19 H881 Table 1: Details of…arrow_forward32. In a relational model, relations are termed as a. Tuples b. Attributes c. Rows d. Tablesarrow_forward
- Consider the below given statements: 1. Referential integrity constraints are always specified between two entities in a schema. 2. Referential integrity constraints are always specified between entities having recursive relation. Which of the above statements is incorrect?arrow_forwardLab 3: Normalization Assignment: Problem #11 from Chapter #6. (Be sure to note that this is PROBLEM and not REVIEW QUESTION). Normalize a set of data to 1st, 2nd and 3rd normal form by creating relational schemas, dependency diagrams and an Entity Relationship Diagram (crow’s foot notation). For this lab, complete problem #11 in Chapter 6. Be sure to complete each letter (a thru c) for the problem. The ERD for letter cmust be completed with the use of Microsoft Visio. Remember to include headers on all documents you submit to include a brief descriptive title, your name and a date. Question 11: Given the sample records in the CHARTER table shown in Table P6.11, do the following: Write the relational schema and draw the dependency diagram for the table structure. Make sure that you label all dependencies. CHAR_PAX indicates the number of passengers carried. The CHAR_MILES entry is based on round-trip miles, including pickup points. (Hint: Look at the data values to determine the…arrow_forwardBuild a relational model for the following ER schemaarrow_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