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
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,…
i need the answer quickly
Lab 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…
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
- Table 4-8 shows a portion of a shipment table for a large manufacturing company. Each shipment (identified by Shipment#) uniquely identifies the shipment Origin, Destination, and Distance. The shipment Origin and Destination pair also uniquely identifies the Distance. Question: a. Develop a diagram that shows the functional dependencies in the SHIPMENT relation. b. In what normal form is SHIPMENT? Why? c. Convert SHIPMENT to third normal form if necessary. Show the resulting table(s) with the sample data presented in SHIPMENT.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_forwardLet R(a,b,c), S(a,b,c), and T(a,b,c) be three relations.Write one or more Datalog rules that define the result of each of the followingexpressions of relational algebra: d) (R U S)- T f) πa,b (R)arrow_forward
- Let R(a, b, c), S(a, b, c), and T(a, b, c) be three relations. Write one or more Datalog rules that define the result of each of the following expressions of relational algebra. (a) (RUS) – T (b) (R – S)n (R – T)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_forwardI NEED ONLY ENTITY RELATIONSHIP & RELATIONAL DIAGRAM.arrow_forward
- d) Both a and b 5. Suitable level of partitioning is found within the range of a) Tuple and attribute b) Tuple and relation c) Attribute and relation d) Tuple/Attribute and relation ible horizarrow_forwardSwing Jazz Club ERD Problem Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information. Remember the ERD will eventually turn into the design for a database from a top down view. Make sure you resolve any many to many conflicts. Label an identifier or primary key and all pertinent attributes given. If an attribute is not readily apparent from the user information, then make one up that makes sense for the particular entity. Therefore, all entities should end up with at least an identifier and another attribute that makes sense. You may use any of the approaches shown by the book, though the ER-Model and Crow’s foot are the most common. Make sure you show entities, relationships, cardinality, and optionality. Swing Jazz Club The Swing Jazz Club teaches swing and jazz dancing and offers both private and group lessons. Swing Jazz charges $60 dollars per hour for a private lesson and $10 dollars per hour for a group lesson.…arrow_forwardHow does the "third normal form" improve upon the "second normal form" in relational data modeling?arrow_forward
- 3. Normalization: Let R bea relational schema and FR corresponding set of functional dependencies. R = ABCDE FR = {A → C, B → D, C → A} a) What normal form is the R schema in? b) Gradually normalize the scheme to 3NF, and for each new scheme, specify the keys and associated functional dependenciesarrow_forwardNormalization of the relational model up to the 3rd Normal Form;arrow_forwardER model relationships are represented using a.) relationship keys b.) primary keys c.) crows foot symbols d.) main keys What do the cardinalities in an ER model show, (please select all that apply)? a.) only a one to one relationship. b.) the minimum number of entities that can be involved in a relationship. c.) only a many to many relationship.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 EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable 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