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
Videos
Textbook Question
Chapter 4, Problem 4.9RQ
Define the term attribute, and give examples for the entity you described in question 4.7.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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?
Define the term attribute and give examples for the entity you described in question 4.7.
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
- Entity, relationship, and attribute names and definitions should all be correct.arrow_forwardFor the following collection of entities, give the assumptions concerning the relationship between entities. EMPLOYEE( EMP _CODE, EMP _LNAME, EMP _FNAME, EMP _INITIAL) BUILDING(BLDG_CODE, BLDG_NAME, EMP _CODE) ITEM(ITEM_ID, ITEM_DESCRIPTION, ITEM_ROOM, BLDG_CODE)arrow_forwardExplain entity sets.arrow_forward
- Explain the use of the terms relation, tuple, and attribute.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_forwardIt is a "Database Design" Subject. Please answer the following question. An arc is a constraint about two or more relationships of an entity. Create a description of an arc using an example. [Hint: you are required to draw an Entity Relationship Diagram and write descriptions based on the example use].arrow_forward
- For 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_forwardHow can we define relation? Identify the characteristics that make up a relation.arrow_forwardQuestion 7 On ERD, you can create attributes with the same name in different Entities. Question 7 options: True Falsearrow_forward
- Question: Draw a diagram showing the relationships for all the tables. The following tables need to be modified as shown (primary key attributes are bold, foreign key attributes are in italics): CID in Retail and Wholesale are defined as a primary key and a foreign key. CUSTOMER (CID, Name, Address) PHONE (PhoneNumber, Description, CID) RETAIL (CID, Type) WHOLESALE (CID, ContractID) CONTRACT (ContractID, Description) OLDCONTRACT (ContractID, Description) ORDER (OID, OrderDate, CID) PRODUCT (PID, Name, Price) DIVISION (DID, Name, Address) LINEITEM (OID, PID, Quantity, AmountCharged) PRODUCTION (DID, PID, Quantity, Rating) One-to-one Relationship If the foreign key will be the primary key or part of the primary key, choose the Identifying Relationship 1:1 icon. Otherwise, choose the Non-Identifying Relationship 1:1 icon.arrow_forwardA rental car agency classifies the vehicles it rents into four categories: compact, mid-size, full-size and sport utility. The agency wants to record the following data for all vehicles: Vehicle, Make, Model, Year and Color. There are no unique attributes for any of the four classes of vehicles. The entity type vehicle has a relationship named Rents with customer entity type. None of the four vehicle classes has a unique relationship with any entity type. Would you consider creating a supertype/subtype relationship for this problem? Why or why not?arrow_forwardWhich statement is associated with two seperate entities. a) Attribute b) Entity Type c) Reflective Relationship d) Relationshiparrow_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 Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable 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