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
Expert Solution & Answer
Chapter 5, Problem 5.12RQ
Explanation of Solution
The method for obtaining data:
After showing the two way of representing the 1:1 relationship in question 5.11 then creates a method for obtaining data about one of the entities given the key of the other.
To go from “HOD” table to “Department” table:
- The first way representing the 1:1 relationship is placing “HOD_ID” into the “Department” table as a foreign key. So, look up the “HOD_ID” in “Department” table.
- The second way is placing “Dep_ID” into the “HOD” table as a foreign key and uses the “HOD_ID” to get the row of “HOD”, then obtain “Dep_ID” from “HOD” and look up the row in “Department” using “Dep_ID” obtained...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Use the following ERD (showing only entities, not their attributes) to answer the following:
a. How many instances of B can each instance of A be associated with? (give min and max)
b. Is B's foreign key to A a required (not null) attribute, or can it be null (blank)?|
A
C
В
Create an E-R model for the following scenario.
Show entity names, primary keys, attributes for each entity, relationships between the entities and
cardinality.
Lonestar Car Dealer is a leading car dealership in US. The dealership sells both new and used cars,
and it has a service facility as well. There are a couple of requirements that the database must meet.
Those are as follows.
Each car is sold by a salesperson. One car sale has only one salesperson. But one salesperson may
sell many cars.
Customers buy one or many cars. But single sale can have only one customer (No multiple
customers for a given car sale).
The salesperson writes one invoice for each car he/she sells. Customer is issued this invoice.
A customer may be just a service center customer and does not need to be a car buyer.
One service ticket per each car is issued when it is reached to the service center.
The car a service history is maintained for each of the cars serviced. Car has a unique serial number.
One or more…
Draw the associations that are described by the following business rules. Include the multiplicities
for each relationship. (4 marks)
A patient must be assigned to only one doctor, and a doctor can have one or many patient:
An employee has one phone extension, and a unique phone extension is assigned to an
employee.
A bookstore sells at least one book, and a book can be sold at up to 10 other bookstores
around town.
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
- please answer with proper explanation and step by step solution. Question: Briefly describe the difference between the domain of an attribute and the data type of an attribute. Why do we need to distinguish between them?arrow_forwardNote: solve only if you can answer it correctly . Otherwise I will dislike the answer. Thank you!! Q. Indicate the changes you need to make to the design of the BITS database to support the following situation. There is no relationship between clients and consultants. When a client places an order (service request), it may be performed by any consultant. On the order, identify both the client placing the order and the consultant responsible for the order.arrow_forwardThe model above needs some improvement. Where you can apply all the normalization rules to attributes. Furthermore, you also need to explain entities and relations between them, and the purpose of attributes by showing why and how they exist ?.arrow_forward
- Question 3 Consider 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. For time and speed on the Exam 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. You can do this at the end of this Word Doc. if you need more space, or use a different tool and upload and extra file, or upload two Word Doc. files (this one and the ERD). You can also NEATLY hand draw it and upload a picture of it. 3.2) Identify all relationships in the ERD that you created in part 3.1. For each relationship, identify the…arrow_forwardDraw an ERD that shows the entities, attributes, primary key(s), foreign key(s), and relationships. Each relationship must be labeled. List all identifying relationships (if any). List all non-identifying relationships (if any). List all independent entities (if any). List all dependent entities (if any). Whenever patients are seen for the first time, they complete a patient information form that asks their name, address, phone number, and insurance carrier, all of which are stored in the patient information file. Patients signed up to be seen by doctor must be a member of at least one insurance carrier. Each time a patient visits the doctor, an insurance claim is generated and will later be sent to the carrier for payment. The claim must contain information about the visit, such as date, purpose, and cost. It would be possible for a patient to submit two claims on the same day. The relational notation for the database is: Patient (Patient ID, Name, Address, Phone, Primary Carrier,…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_forward
- Answer the following questions : In real-world data, tuples with missing values for some attributes are a common occurrence. Describe various methods for handling this problem. The following data (in increasing order) represent the attribute age: 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 Use smoothing by bin means to smooth these data, using a bin depth of 3. Illustrate your steps. Comment on the effect of this technique for the given data. How might you determine outliers in the data? What other methods are there for data smoothing?arrow_forwardIn your initial post to the discussion, respond to the following in 2-3 paragraphs: Discuss the difference between a composite key and a composite attribute. How would each be indicated in an ERD? Finally, be sure to respond to at least two of yourarrow_forwardGiven the basic ER and relational models, which of the following is INCORRECT? A An attribute of an entity can have more than one value B An attribute of an entity can be composite C In a row of a relational table, an attribute can have more than one value D In a row of a relational table, an attribute can have exactly one value or a NULL valuearrow_forward
- Question 18 Which of the following is true about weak entities? Group of answer choices The parent row of a weak entity must be removed from the parent table before the row (or rows) representing the weak entity are removed. The parent row is added to the database before the related weak entity row. A weak entity may have one or more "parents". That is, it may have a maximum cardinality of many. Weak entities may be added before or after the parent entity.arrow_forwardWhat exactly is meant by the term "partial dependence," and how does it function? What is the typical shape that it takes, and how is it related with it?arrow_forwardAnswer the given question with a proper explanation and step-by-step solution. 4.techniques can be used to reduce the number of values for a given continuous attribute, by dividing the range of the attribute into intervals.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