ACCT 4600 Chapter 14 Homework
Use the following ERD to answer the accompanying questions. (14.22) 1. What is the relationship between the two tables in the ERD? type exactly either one-to-one, one-to-many, or many-to-many: 2. What is the cardinality of the relationships? On the Supplier side the maximum is and the minimum is On the Purchase Order side the maximum is and the minimum is
Answer 1: One-to-many Answer 2: One Answer 3: One Answer 4: Many Answer 5: Zero
Figure 14.13: Using the ERD shown in Figure 14.13, identify the following: 1. SALES ORDER table mininum cardinality - (from the CUSTOMER and ITEM) 2. SALES ORDER table maximum cardinality - (from the CUSTOMER and ITEM) 3. ITEM table minimum cardinality - 4. ITEM table maximum cardinality -
Answer 1: Zero Answer 2: Many Answer 3: One Answer 4: Many
One of the entity identifiers the uniquely identifies and entity occurrence
Candidate key
3. In a one-to-many relationship, the entity on the many side
Child entity
Data is accurate and complete
Data integrity
1. Collection of related tables
Database
The database contains accurate and complete data
Database integrity
A technique used to develop an anomaly-free database with database integrity
Database model
2. The output of a SELECT statement in a table with the selected records and fields
Database view
This entity is also known as a child entity
Dependent entity
Can refer to an object or event
Entity
A property of an entity
Entity attribute
An attribute that uniquely identifies an entity occurrence
Entity identifier
A specific object or event
Entity occurrence
A database modeling tool that depicts the relationship among entities in the database
Entity relationship
Transactions
Events
Pieces of information about events and objects
Fields
A set of steps to remove anomalies from a database
Normalization
People and things
Objects
In a one-to-many relationship, the entity the one side
Parent entity
Collection of related fields
Records
A database modeling tool that uses economic duality sometimes used to teach accounting databases
Resources, events, and agents (REA)
Collection of related records
Tables
