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
Question
Chapter 4, Problem 4.37PAE
Program Plan Intro
(a)
To draw:
A relational schema and functional dependencies of the given relation.
Program Plan Intro
(b)
To identify:
The normal form of the relation.
Program Plan Intro
(c)
To decompose: given relation into 3NF relations.
Program Plan Intro
(d)
To draw:
A relational schema for 3NF relations and show referential integrity.
Program Plan Intro
(e)
To draw:
The 3NF relations using Microsoft Visio notation.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Ņ 5. Table 4-5 shows a shipping manifest. Your assignment is as follows: a. Draw a relational schema and diagram the functional dependencies in the relation. b. In what normal form is this relation? + c. Decompose MANIFEST into a set of 3NF relations. d. Draw a relational schema for your 3NF relations and show the referential integrity constraints. TABLE 4-5 Shipping Manifest 00-0001 Boston Brazil 39 Shipment ID: Origin: Destination: Ship Number: Item Number 3223 3297 Type BM BM Description Concrete Form Steel Beam Shipment Date: Expected Arrival: Captain: Weight 500 87 Quantity 100 2,000 Shipment Total: 01/10/2010 01/14/2010 002-15 Henry Moore TOTALWEIGHT 50,000 174,000 224,000
Map the ER diagram below to a set of relations (i.e., relational schema). Underline the primary key attributes of each relation. Indicate referential integrity constraints using arrows. An arrow from an attribute A to an attribute B represents that A references
For each of the following relations, indicate the normal form for that relation. If the
relation is not in third normal form, decompose it into 3NF relations. Functional
dependencies are shown where appropriate.
a) CLASS(CourseNo, SectionNo)
b) CLASS(CourseNo, SectionNo, Room)
c) CLASS(CourseNo, SectionNo, Room, Capacity)
d) CLASS(CourseNo, SectionNo, CourseName, Room, Capacity)
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
- Transform the diagram to a relational schema that shows referential integrity constraints (see the following figure for an example of such a schema – underlined items are primary keys, dotted underlines refer to foreign keys, while the arrows indicate direction from foreign to primary)arrow_forwardBased on the following functional dependencies, for the relation SCHEDULE bring it into a set of 3NF relations. Dependencies: Section#, CourseID, Semester ID → RoomNo Section#, CourseID, Semester ID → Inst_ID Section#, CourseID, Semester ID → Week_day Section#, CourseID, Semester ID → Start_time Section#, CourseID, Semester ID → End_time Course_ID → Course Name RoomNo → Occupancy Instr_ID → Instr_name SCHEDULE CourseID, Section#, Semester ID, Course Name ,RoomNo, Occupancy, Inst_ID, Instr_Name, Week_day, Start_time, End_time)arrow_forwardWhat is the most common method of specifying a primary key in a relational schema description? Group of choice: A. by enclosing the key attributes in parentheses B. by stating the key attributes first in the relation definition C. by writing key attributes in all capital letters D. by italicizing the key attributes E. by underlining the attributes that comprise the primary keyarrow_forward
- Consider two relations Order and Product with the schema Order (Oid, Odate, Pid, qty) and Product (Pid, manufacturer_id, unit_price). i) Can the Oid attribute in the relation Order be a candidate key of the relation? Justify your answer. ii) Can the Pid attribute in the relation Product be a candidate key of the relation? Justify your answer. iii) Find the candidate key for the relation Product. iv) Using the primary keys identified for the above relations write a SQL query that retrieves all tuples of the form (Oid, Odate, Pid, unit_price).arrow_forwardWhat are three indications that a surrogate key should be constructed for the primary key of a relation?arrow_forwardCreate ERD of a hospital with these requirements "and then" write relation schema (underline primary key and connect foreign key with arrow): (use Chen Notation) 1. Hospital have many department, each department have it's own ID, name, and head of department. 2. Hospital need to collect Patient data included : ID, Name, Sexuality, Age, Address, Health Insurance, Telnum 3, Patient may have data stored about people they can contact, should be more than 1 people they can contact 4. Doctor should have : DocID, Name, Sex, TelNum, Specialty, Years of service, Salary, Qualification 5. 1 doctor can be assigned to only 1 department 6. some doctor may not have their assigned patient 7. patient can be assigned to more than 1 doctor for treatment 8. each treatment shall be stored (date, detail, next appointment) Specification for the diagram: - describe what should be describe and what can be describe inside the diagram - also explain others that can be describe inside the diagram briefly (don't…arrow_forward
arrow_back_ios
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 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