Modern Database Management (12th Edition)
12th Edition
ISBN: 9780133544619
Author: Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 4, Problem 4.31PAE
For your answers to the following Problems and Exercises from prior chapters, transform the EER diagrams into a set of relational schemas, diagram the functional dependencies, and convert all the relations to third normal form:
a. Chapter 2, Problem and Exercise 2-37b
b. Chapter 2, Problem and Exercise 2-37g
c. Chapter 2, Problem and Exercise 2-37h
d. Chapter 2, Problem and Exercise 2-37i
e. Chapter 2, Problem and Exercise 2-43
f. Chapter 2, Problem and Exercise 2-46
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these 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."
Give a Relational Model that corresponds to the Entity-RelationshipDiagram in Figure 1. You must present this model as a RelationalDatabase Schema and not as a diagram. Primaryand foreign keys must be declared where required. Please keep thenames of attributes and role names where required and do not re-place them with different names. Provide NOT NULL constraintsonly where semantically justified by the Entity-Relationship diagram.
Question- Translate the following ER diagram into the appropriate relational schema(s):
Chapter 4 Solutions
Modern Database Management (12th Edition)
Ch. 4 - Prob. 4.1RQCh. 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 - For your answers to the following Problems and...Ch. 4 - Transform Figure 2-15a, attribute version, to 3NF...Ch. 4 - Prob. 4.41PAECh. 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
- Please draw an relational ERD with multiplicities and all the attributes based on following description: ( Please identify the primary key in each entity.) An Adult Education Department runs various courses during the daytime and evenings, and at different times of the year. For example, ‘Spanish level 1’ is offered on Monday mornings, Monday evenings or Wednesday evenings, and runs over 25 weeks from October to March. On the other hand, ‘Introduction to Digging Up Your Ancestors’ only runs for 8 weeks, but is offered on Tuesday or Wednesday evenings from October to December, January to March, and April to June, with an optional field week in August. There is always a maximum number of places for each course offering, which is dependent on the individual teacher. For example, ‘Spanish level 1’ on Monday evenings may be limited to 20 places, but on Wednesday evenings the limit may be 25. Each course offering is only taken by one teacher, however teacher may take…arrow_forwarda. 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_forwardHow do you make the relational schemas for these problems? I got all the other information.arrow_forward
- Transform the following entity relationship diagram into a relational schema.arrow_forward1. According to what you understand, what is the relationship between Functional Dependency and Normalization? 2. There are several attribute relationships, including partial dependency and transitive, give an example of the two relationships. 3. Why do we do the normalization stage in database design, especially in the logical stage?arrow_forwardConvert the following E-R diagram into a relational schema.arrow_forward
- You 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_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_forwardCreate a relational schema for this diagramarrow_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
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY