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