Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
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:
- Chapter 2, Problem and Exercise 2-39b
- Chapter 2, Problem and Exercise 2-39g
- Chapter 2, Problem and Exercise 2-39h
- Chapter 2, Problem and Exercise 2-39i
- Chapter 2, Problem and Exercise 2-42
- 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,…
Convert the following Conceptual Model to Relational Model.
The following are the objectives for the design of the logical schema:
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
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
Why is the study of database technology important?
Database Concepts (7th Edition)
A byte is made up of eight a. CPUs b. addresses c. variables d. bits
Starting Out with Java: From Control Structures through Objects (6th Edition)
Computers process data under the control of sets of instructions called
Java How To Program (Early Objects)
Using your text editor, enter (that is, type in) the C++ program shown in Display 1.8. Be certain to type the f...
Problem Solving with C++ (9th Edition)
Convert each of the following binary representations to its equivalent base ten form: a. 101010 b. 100001 c. 10...
Computer Science: An Overview (12th Edition)
While a program is running, a control is said to lose focus when the focus moves from that control to another c...
Introduction To Programming Using Visual Basic (11th Edition)
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 following entity relationship diagram into a relational schema.arrow_forwardLab 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…arrow_forwardConsider the following relational schemas:Formulate the Relational Algebra statements for the following questions: Book (ISBN, Category, BTitle, Quantity)Sales (SalesNo, Month_Year, TotalSales, ISBN)Shop (RegNo, Location, SalesNo)Customer (CID, CName, TelNo, Age) (i) Where is the location of the shop whose sales number ends with "A000"? (ii) What was the title and category of the book that the customer Emeka bought?(iii) Who purchased the book in the Coding category, or the quantity is greater than two?(iv) What is the total sales and location of the shop with the registration number "REG KL100" in the month of April 2021? (v) Display the identification number, name, age together with the total sales of thecustomers who purchased the Computer Fundamentals title book.arrow_forward
- 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_forwardCourse: DataBase Management System Question no 01: Note: Please make sure that all the points/rules must be implemented. Draw the ERD Diagram to create relational model corresponding to the described Scenario. The loan office in a bank receives from various parties, requests to investigate the credit status of a Customers. Each credit request is identified by a Request ID and is described by a Request Date and Requesting party Name. The loan office also received results of credit checks. A credit check is identified By a credit check ID and is described by the credit check Date and the credit rating. The loan office Matches credit requests with credit check results. A credit request may be recorded before its result Arrives; a particular credit result may be used in support of several credit requests. Draw ERD for this Situation. Requirements: ER Diagram of system implemented in tool such as Sqlyog & Draw.io (Available online). Note: DRAW ERD ASAParrow_forwardHow does the "third normal form" improve upon the "second normal form" in relational data modeling?arrow_forward
- Consider the relational schema for a library system as given below: Member (mem_no, name, dob) Books (isbn, title, authors, publisher) Borrowed (mem_no, isbn, date) Write the following queries in relational algebra. i. List the members who have not borrowed any books from the library. ii. Name all the books borrowed by a member named 'Ram'. ii. List the book that has been borrowed the most.arrow_forwardNormalization Show all the steps as you perform normalization for each problem up to 3NF. State your final relation to schemas in 3NF.arrow_forwardInstructions: Create a complete ERD in Crow's Foot notation that can be implemented in the relational model using the descriptions below. The attributes required: Activity's ID, Activity's Title, Activity's description, Child's ID, Child's firstname and lastname, Child's Birthday, Parent's ID, Parent's number, Parent's address. The business rules are: An activity may or may not have a child signed up An activity may have many children signed up A child must have an activity A child may have many activities A child must have a parent A parent must have a child A child may have many parents A parent may have many children To submit: Write your answer in a clean sheet of paper and upload a picture of it to dropboxarrow_forward
- A data model is a collection of data description constructs. The main purpose of a data modeling is to assist in the understanding of the meaning (semantics) of the data and facilitate communication about the information requirements. Discuss FIVE (5) evaluation criteria for a good data model. [Hint: As a database designer, you have to interview customers, you are required to include questions you may ask to customers in your answers]arrow_forwarda) Complete the object conceptual data model for the following relational schema. Branch BranchID Location B001 Shatin ВО02 Homantin Order OrderID SalesTotal BranchID 0001 100 BO01 0002 200 BO02 0003 300 BO01 BranchID is the primary key of Branch table. OrderID is the primary key of Order table. BranchID in Order table is the foreign key references Branch table. Now, assume the OIDS are given below: Branch BranchID Location OID B001 Shatin OID1 B002 Homantin OID2 Order OrderID SalesTotal BranchID OID 0001 100 ВО01 OID3 0002 200 ВО02 OID4 0003 300 ВО01 OID5arrow_forwardConversion of E-R diagram to relational schemaSchema is a correct translation of the E-R diagram submitted with appropriate tables, columns, primary keys, and foreign keys.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