Database Concepts (8th Edition)
8th Edition
ISBN: 9780134601533
Author: David M. Kroenke, David J. Auer, Scott L. Vandenberg, Robert C. Yoder
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 4, Problem 4.10RQ
Define the term identifier, and indicate which attribute(s) defined in your answer to question 4.9 identifies the entity.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Explain entity sets.
The entity type STUDENT has the following attributes: Student Name, Address, Phone, Age, Activity, and No of Years. Activity represents some campus-based student activity, and No of Years represents the number of years the student has engaged in this activity. A given student may engage in more than one activity. Draw an ERD for this situation. What attribute or attributes did you designate as the identifier for the STUDENT entity? Why?
Look at the 4 entities below and assume that customer_id is the key common to all tables.
• Customer: An entity that describes a customer. An instance occurs for unique customers only
using name, date of birth, and login name as customer_id primary key.
• Online: An entity that describes a customer purchasing activity online. An instance occurs
when the customer completes the transaction. Customers can purchase more than once.
• Visits: An entity that describes a customer purchase in a physical store. An instance occurs if a
customer makes or purchase or checks-in using an app. Customers can visit more than once
per day.
• Satisfaction: An entity that represents data from a recent customer satisfaction survey. An
instance occurs when a customer takes the survey. A customer is tracked by login name and
can only take the survey one time.
Use the information to match the following relationships. Answers can be reused more than once.
The relationship between Customer and
Online
The…
Chapter 4 Solutions
Database Concepts (8th Edition)
Ch. 4 - Prob. 4.1RQCh. 4 - Prob. 4.2RQCh. 4 - Prob. 4.3RQCh. 4 - What is a use case, and what is its purpose?Ch. 4 - Give an example of a data constraint.Ch. 4 - Prob. 4.6RQCh. 4 - Define the term entity, and give an example other...Ch. 4 - Explain the difference between an entity class and...Ch. 4 - Define the term attribute, and give examples for...Ch. 4 - Define the term identifier, and indicate which...
Ch. 4 - Prob. 4.11RQCh. 4 - Prob. 4.12RQCh. 4 - Prob. 4.13RQCh. 4 - Prob. 4.14RQCh. 4 - List and give an example of the three types of...Ch. 4 - Prob. 4.16RQCh. 4 - Prob. 4.17RQCh. 4 - Prob. 4.18RQCh. 4 - Define the term weak entity, and give an example...Ch. 4 - Explain the ambiguity in the definition of the...Ch. 4 - Define the term associative entity, and give an...Ch. 4 - Define the terms supertype, subtype, and...Ch. 4 - What is an exclusive subtype relationship? Give an...Ch. 4 - What is an inclusive subtype relationship? Give an...Ch. 4 - Prob. 4.25RQCh. 4 - Prob. 4.26RQCh. 4 - Prob. 4.27RQCh. 4 - Prob. 4.28RQ
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
- Define the term identifier and indicate which attribute defined in your answer to question 4.9 identifies the entityarrow_forwardWhen using subtype associations, talk about the database table choices that are accessible.Decide the design you want to employ and talk about the relevant issues.arrow_forwardExplain the use of the terms relation, tuple, and attribute.arrow_forward
- did not answer the question, relationship between the entities(did not show the relationship) and the contraintsarrow_forwardFor each of the following collection of entities, give the assumptions concerning the relationship between entities and attributes. EMPLOYEE(EMP_NUM, EMP_LNAME, EMP_INITIAL, EMP-DOB) DEPENDENT(EMP_NUM, DEP_NUM, DEP_FNAME, DEP_DOB)arrow_forwardQUESTION 4 For the following collection of entities, give the assumptions concerning the relationship between entities. ORDER (order#, ordDate, cust#, cName ) ORDER_PART ( order#, part#, quantity ) PART ( part#, description, price )arrow_forward
- Which statement is associated with two seperate entities. a) Attribute b) Entity Type c) Reflective Relationship d) Relationshiparrow_forwardCreate Relation Schema for ERD in question 1(question 1 was: Create ERD for the given case study using Crows Feet Notation)arrow_forwardIn an ERD, entities do not have columns. Instead which of the following is used to describe the entity's characteristics? Group of answer choices attributes degrees instances relationshipsarrow_forward
- Entity Relationship Diagram of the business, as shown in the case. Completely and correctly specify all Entities, Relationships and Attributes Order: has one or many items; half by member half by anonymous member (no member number)Has: order number, each order item has total cost (with and without gst), number of store, cashier who took the order, member number (if provided), date on which the order was places, and, if the order is not picked up in-person, the date on which the order is shipped. Order-Item (one of the 1600 products):to identify: useorder number as well as a small “item sequence number” (which is unique within each order). product number, quantity ordered and the actial "unit price paid" If a valid member number is on the order, the system should use the product’s special “member price”, otherwise the product’s “regular price” is used. The average order includes 11 distinct order-items. Member (places 5 orders per month on avg):last name, given names, email…arrow_forwardTransform the following entity relationship diagram into a relational schema.arrow_forwardUse the ER Diagram shown on Figure 2 to anewer questions 6 and 7: 6. According to the ER diagram on Figure 2, which of the following is true? A) YearEnrolled is a derived attribute. B) STUDENT entity has multiple unique attributes. C) StudEmail is an optional attribute. D) None of the above. Answer: 7. According to the ER diagram on Figure 2, which of the following is true? A) A student must attend a college but can only attend a single college. B) Each college must have multiple students attending it. C) NumOfStudents is a composite attribute. D) None of the above. Answer: StudiD CollD StudName STUDENT Allends COLLEGE ColName StudEmail *** YearEnrolled (0) NumOIStudentsarrow_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 Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY