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
First normal form
a) prohibits multi-valued attributes
b) prohibits composite attributes
c) is part of the definition of relation in the basic relational model
d) all of the above
31.
In the relational models, cardinality is termed as:
a.
Number of tuples
b.
Number of attributes
c.
Number of table
d.
Number of constraints
Draw the Dependency Diagram that is in 3NF for each relation. For each relation show the level of Normalisation achieved, and for any not to Third Normal Form, explain why. Discuss PK and FK for each relation.
Data Dictionary that translates your relational data structures, which includes (as in the picture):
table names,
column names and field types
primary keys identified
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_forward117. The type of algorithm in which decomposition of relation schema is constructed from other specific set of functional dependencies is classified as a. relational synthesis algorithm b. decomposition algorithm c. schema synthesis algorithm d. none of abovearrow_forwardRead the following business rules carefully and use common sense when necessary to come up with a good database design as follows: 1- First, develop an ER model. Make sure to use meaningful entity names and relations. 2- Translate ER model into a set of tables, relations and constraints. 3- Label appropriate columns as primary keys and foreign keys. Business rules: A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor and one patient. Emergency cases do not require an appointment. However, for appointment management purposes, an emergency is entered in the appointment book as “unscheduled.” If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment. With each visit, the patient’s records are updated to provide a medical history Each patient visit…arrow_forward
- a. Provide the relation (relational notation) that represents the user view for the school advising system.b. Transform the user view into the third normal form. Show the intermediate steps in the normalization process, i.e. 1NF, 2NF, 3NF.arrow_forwardProvide a normalized relational logical schema for the same database (NB It is not mandatory to report the restructured ER diagram) Define referential integrity constraints for 2 relationships of your choice among those defined in the conceptual schema Normalized logical relational schema EMPLOYEE( CodE, NameE, Qualification*, Type)SEASIDE_RESORT(CodS, NameS, WebPage*)TIME (SDate)WORK_AT (CodE, CodS, SDate, EndDate, JobRole)BEACH_SEAT(CodS, CodBS, sea_distance, CodPR)PRICE_RANGE(CodPR, Amount) Referential integrities 1) RELATIONSHIP IN BEACH_SEAT(CodS) REFERENCES SEASIDE_RESORT(CodS) 2) RELAZIONE WORK_AT WORK_AT(CodE) REFERENCES EMPLOYEE(CodE)WORK_AT(CodS) REFERENCES SEASIDE_RESORT(CodS)WORK_AT(SDate) REFERENCES TIME(SDate)arrow_forwardDiscuss each of the following concepts in the context of the relational data model: (a) relation (b) attribute (c) domainarrow_forward
- Create a relational model with foreign and primary keysarrow_forwardConsider the following relational schema for a library database: Book (Title, Author, Catalog_no, Publisher, Year, Price, bookCoverType, contractDate) Collection (Title, Author, Catalog_no) Assume {Author, Title} is the key for both relations Additional functional dependencies are Title,Author --> Catalog_no Catalog_no --> Publisher, Year, bookCoverType Publisher, bookCoverType --> Price Author --> contractDate a) Explain what normal form the relation is in. b) Apply normalization until the 3rd State reasons behind each normalizationarrow_forwardYou are required to: Provide a normalized relational logical schema for the same database (NB It is not mandatory to report the restructured ER diagram) Define referential integrity constraints for 2 relationships of your choice among those defined in the conceptual schema solution: AUTHOR( author_id , name, surname) BOOK ( ISBN , title , num_page s , price ) CUSTOMER( customer_id , phone_number*, type, name*, surname*, vat_number*) CLERK( clerk_id , name) BUY( customer_id, clerk_id, ISBN ) WRITTEN_BY( author_id, ISBN ) 1) WRITTEN_BY (author_id) REFERENCES AUTHOR(author_id) WRITTEN_BY (ISBN) REFERENCES BOOK(ISBN) 2) BUY(customer_id) REFERENCES CUSTOMER(customer_id) BUY (clerk_id) REFERENCES CLERK(clerk_id) BUY (ISBN) REFERENCES BOOK (ISBN) i gave the solution. but i do not have any idea where it came from and how im supposed to formulate a similar solution so please help me understand how was this was reached and how i should solve these type of questions in…arrow_forward
- Question- Translate the following ER diagram into the appropriate relational schema(s):arrow_forward4. (a) Why is normalization important in database design? Consider the universal relation R = {A, B, C, D, E, F, G, H, I, J} and the set of functional dependencies F = { AB → C, A → DE, B → F, F → GH, D → IJ }.What is the key for R? Decompose R into 2NF (Second Normal Form) and then 3NF (Third Normal Form) relations. (b) Consider a relation schema R = (X, Y, Z) on which the following functional dependencies hold: { XY → Z, Z → X }. Show that the schema R is not in BCNF (Boyce-Codd Normal Form) but it is in 3NF (Third Normal Form).arrow_forward1. what is the relationship between Functional Dependency and Normalization? 2. partial dependency and transitive, give examples of the two relationships. 3. 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 Learning
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
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Fundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
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
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning