Database Concepts (7th Edition)
7th Edition
ISBN: 9780133544626
Author: David M. Kroenke, David J. Auer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 5, Problem 5.23RQ
For your answers to questions 5.20, 5.21, and 5.22, describe a method for obtaining the children for one of the entities in the original data model, given the primary key of the table based on the second entity, Also, describe a method for obtaining the children for the second entity, given the primary key of the table based on the first entity.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Convert the Entity Relationship Diagram in to
relational database by using MS Access (Note: Students has
to create tables in the MS Access by giving appropriate
Primary key and Foreign key
relationships)
QI.
Customer
Order
OrderDetail
CustomeriD
OrderiD
OrderiD
(FK)
OrderDetaillD
Name
Mail
ZipCode
Address
Telephone
CustomeriD (FK)
OrderDate
TotalPrice
ProductiD (FK)
Amount
Price
Product
ProductiD
Name
Kind
Price
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 aCustomers. Each credit request is identified by a Request ID and is described by a Request Date andRequesting party Name. The loan office also received results of credit checks. A credit check is identifiedBy a credit check ID and is described by the credit check Date and the credit rating. The loan officeMatches credit requests with credit check results. A credit request may be recorded before its resultArrives; a particular credit result may be used in support of several credit requests. Draw ERD for thisSituation.
Requirements:ER Diagram of system implemented in tool such as Sqlyog & Draw.io (Available online).
The purpose of the assignment is to facilitate the learning of data modeling concepts through models developed by individuals. Things to be considered in the applications to be developed:
Creating a model with at least 15 tables for vaccination tracking system.
The characteristics and relationships of the tables are in the model.
Step by step analysis of the normalization steps for a table with multiple relationships in the model.
It will briefly be stated which entity-tables will be used for what purpose.
Only special rules will be added in the relational data model that cannot be directly specified.
Chapter 5 Solutions
Database Concepts (7th Edition)
Ch. 5 - Explain how entities are transformed into tables.Ch. 5 - Prob. 5.2RQCh. 5 - Prob. 5.3RQCh. 5 - What is denormalization?Ch. 5 - Prob. 5.5RQCh. 5 - Explain the problems that denormalized tables may...Ch. 5 - Explain how the representation of weak entities...Ch. 5 - Explain how supertype and subtype entities are...Ch. 5 - Prob. 5.9RQCh. 5 - Prob. 5.10RQ
Ch. 5 - Show two different ways to represent the 1:1...Ch. 5 - Prob. 5.12RQCh. 5 - Prob. 5.13RQCh. 5 - Prob. 5.14RQCh. 5 - Prob. 5.15RQCh. 5 - Prob. 5.16RQCh. 5 - For your answer to question 5.15, code an SQL...Ch. 5 - Prob. 5.18RQCh. 5 - Prob. 5.20RQCh. 5 - Prob. 5.21RQCh. 5 - Explain how the terms parent table and child table...Ch. 5 - For your answers to questions 5.20, 5.21, and...Ch. 5 - Prob. 5.24RQCh. 5 - Prob. 5.25RQCh. 5 - Prob. 5.26RQCh. 5 - Prob. 5.27RQCh. 5 - Prob. 5.28RQCh. 5 - Define the three types of recursive binary...Ch. 5 - Prob. 5.30RQCh. 5 - Prob. 5.31RQCh. 5 - Prob. 5.32RQCh. 5 - Prob. 5.33RQCh. 5 - Prob. 5.34RQCh. 5 - Code an SQL statement that creates a table with...
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
- Convert the ER diagram in the above question into relational model.arrow_forwardwhat is relational model representation of ER/EER model? A)student(studentno,name,firstname,midinitials,lastname,phone) Primary key: studentno B)student(studentno,name,phone) Primary key: studentno C)student(studentno,name,firstname,lastname,phone) Primary key: studentno D)student(studentno,fistname,lastname,phone) Primary key: studentnoarrow_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
- Convert the following Conceptual Model to Relational Model.arrow_forwardCreate an Entity-Relationship Model for the Queen Anne Curiosity Shop The first assignment for the class project is to create an entity-relationship model of the Queen Anne Curiosity Shop database. This assignment requires you to apply the knowledge gained from study of chapter 4 of the textbook. You will create the entity-relationship model using the ERDPlus database modeling tool. The Queen Anne Curiosity Shop database contains the following tables: CUSTOMER (CustomerID, LastName, FirstName, Address, City, State, ZIP, Phone, EmailAddress) EMPLOYEE (EmployeeID, LastName, FirstName, Phone, EmailAddress) VENDOR (VendorID, CompanyName, ContactLastName, ContactFirstName, Address, City, State, ZIP, Phone, Fax, EmailAddress) ITEM (ItemID, ItemDescription, PurchaseDate, ItemCost, ItemPrice, VendorID) SALE (SaleID, CustomerID, EmployeeID, SaleDate, SubTotal, Tax, Total) SALE_ITEM (SaleID, SaleItemID, ItemID, ItemPrice) Note that the above table descriptions follow the textbook convention:…arrow_forwardTransform the given ERD into Relational Model.arrow_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_forwardConsider the following relational schema that consists of five tables. Primary keys are (BOLD and Italicized). Attributes with the same names in different tables are foreign keys. The address and name attributes are just one column each. Person (driver_id, LastName, FirstName, EmailAddress, license, dateOfBirth) Car (license, model_id, color, report_num, trim) Accident (report_num, date, location) Model(model_id, description, year) PersonInsuranceCompany(driver_id, insurance_company_id, policy_issue_date) InsuranceCompany(insurance_company_id, name, EmailAddress) 3.1) Draw the corresponding ERD. Draw eligibly!!! Identify all relationships in the ERD that you created in part 3.1. For each relationship, identify the relationship connectivity (cardinality) and write a business rule to describe the relationship.arrow_forwardWhat is the difference between the implementation of 1:M unary relationship and M: N unary relationship in a relational data model.arrow_forward
- How do you represent one-to-many and many-to-many relationships in a data model?arrow_forwardConvert the Entity Relationship Diagram in to Q1. relational database by using MS Access (Note: Students has to create tables in the MS Access by giving appropriate Primary key and Foreign key relationships) Customer Order OrderDetail OrderID OrderDetaillD CustomerID OrderID (FK) Name Mail CustomerID (FK) OrderDate TotalPrice ProductID (FK) ZipCode Address Telephone Amount Price Product ProductID Name Kind Pricearrow_forward1. Suppose that the data for analysis includes the attribute age. The age values for the data tuples are (in increasing order) 13, 15, 16, 16, 19, 20, 20, 21, 22, 22, 25, 25, 25, 25, 30, 33, 33, 35, 35, 35, 35, 36, 40, 45, 46, 52, 70. Using the data above, please answer the following questions: b. Use "Normalization with decimal scaling" to change the age value to 25.arrow_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 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
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY