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
Question
Chapter 4, Problem 4.44PAE
Program Plan Intro
Creating relations from EER Diagram.
Program Plan Intro
Functional dependency of each relation.
Program Plan Intro
Convert relations into 3NF
Program Plan Intro
An integrity constraint that would ensure that no property is rented twice during the same time interval.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
1. The BOOK CHECKOUT relation stores data about books checked out by students at a university. The functional dependencies are
given below for this relation.
a. Which normal form is this relation in and why?
b. Using the normalization steps develop a set of 3NF relations for this view. Describe the relational schema for the 3NF relations that
you developed. Be sure to list the referential integrity constraints
BOOK CHECKOUT (StudentID, StudentName, StudentPhoneNumer, ISBN, BookTitie, CheckOutDate, ReturnDate)
StudentID > StudentName, StudentPhoneNumer
ISBN -> BookTitle
StudentiD, ISBN ->CheckOutDate, ReturnDate
QUESTION 1
Create relational schemas for the ER diagram given below. Indicate clearly the primary and foreign
keys of each relation.
Туре
Address
NoPersons
Area
No
No
1
M
House
Has
Room
Using the invoice table stucture do the following:a.Write the relational schema ,draw its dependency diagram,and identy all dependencies,including all partial and transitive dependencies.You can assume that the table does not contain repeating groups and that an invoice number references more than one product.b.Remove all partial dependencies,write the relational schema,and draw the new dependency diagrams.Identify the normal forms for each table structure you created.c.Remove all transitive dependencies,write the relational schema,and draw the new dependency diagrams.Also identify the normal forms for each table structure you created.d.Draw the Crow's Foot ERD.
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
Similar questions
- Please transform the following Entity-Relationship Schema (Diagram) into a Relational Schema. Please do not forget to specify the keys and constraints for each relation. (RESP_ENG: the engineer responsible for the project. WORKS_ON: the project an engineer works on). MANAGES SSNO FName PNo PROJECT EMPLOYEE LName PName |1 Address \ISA WORKS ON ENGINEER Speciality RESP ENGarrow_forwardI got stuck on step one through four. I was wondering if you guys know how. each step says: Write the relational schema for the data in its current form. Identify all partial dependencies and transitive dependencies for the data in its current form. Write the relational schema to meet 3NF requirements to the greatest extent possible. If necessary, add or modify attributes to create appropriate determinants, create appropriate foreign keys, and to adhere to naming conventions. Analyze the given data and identify the business rules reflected in the data.arrow_forwardMapping: Create relational schemas for the ER diagram given below. Indicate clearly the primary and foreign keys of each relation. 2 Book-Chapter Title M N Role Written by Reviewed By Name M Author Narrow_forward
- PLZ help with the following: Translate your ER diagram into a relational schema in the form of SQL DDLs. Choose appropriate data types for each attribute and include primary key and foreign key constraints, Check and Not Null constraints. Normalize the relations to 3NF.arrow_forwardUsing the STUDENT table structure in picture, do the following: 1. Write the relational schema, draw its dependency diagram and identify all dependencies, including all partial and transitive dependencies. You can assume that the table does not contain repeating groups and that any invoice number may reference more than one product. (Hint: This table uses a composite primary key.) 2. Remove all partial dependencies, write the relational schema, and draw the new dependency diagrams. Identify the normal forms for each table structure you created. 3. Remove all transitive dependencies, write the relational schema, and draw the new dependency diagrams. Also identify the normal forms for each table structure you created. 4. Draw the Crow’s Foot ERD.arrow_forwardWhat exactly is a Ternary Relationship, and how does it function?arrow_forward
- What is the connection between a relation's primary key and the functional relationships between all of its attributes?arrow_forwardUsing the INVOICE table structure shown in table P6.3, do the following a. Write the relational schema, draw its dependency diagram, and identify all dependencies, including all partial and transitive dependencies. You can assume that the table does not contain repeating groups and that an invoice number references more than one product. (Hint: This table uses a composite primary key.) b.Remove all partial dependencies, write the relational schema, and draw the new dependency diagrams. Identify the normal forms for each table structure you created. Note You can assume that any given product is supplied by a single vendor, but a vendor can supply many products. Therefore, it is proper to conclude that the following dependency exists: PROD_NUM -+ PROD_LABEL, PROD_PRICE,VEND_CODE, VEND_NAME ( Hint Your actions should produce three dependency diagrams.) c. Remove all transitive dependencies, write the relational schema, and draw the new dependency diagrams. Also, identify the normal…arrow_forwardIndicate all the functional dependencies and the normal form for each relation. Decomposeyour relations into 3rd normal form relations using the decomposition algorithm you will learnin the class. Make the necessary changes in the relations you already created and populatedarrow_forward
- In what normal form is the LOTS relation schema in the Figure with respect to the restrictive interpretations of normal form that take only the primary key into account? Candidate Key (a) LOTS County_name Lot# Area Price Tax_rate Property_id# FD1 FD2 FD3 FD4 2NF Both 2NF and 3NF 3NF 4NFarrow_forwardPLz help with the following: Translate your ER diagram into a relational schema in the form of SQL DDLs. Choose appropriate data types for each attribute and include primary key and foreign key constraints, Check and Not Null constraints.arrow_forwardName: exis Johnsin Using this unnormalized table and the five functional dependencies below, determine the first, second, and third normal forms. In other words, normalize Relation1 up to third normal form. Unnormalized Table: Relation1 A B CD Primary key: A, B Functional dependencies fd1: A, B C, D, E, F, G fd2: B C fd3: AD E-F fd4: fd5: G, BH First Normal Form Second Normal Form Third Normal Form G E F Harrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning