MKTG 3502 Quiz 1

Domain/Key Normal Form

A bad choice for a primary key for the university's student database is the student phone number. (t/f)

true

A bad choice for a primary key for the university's student database is the student phone number. (t/f)

Small closed diamond at the end of a line connecting two tables

A composition association is drawn using which symbol _______________.

Autonumber

A data type that creates unique numbers for key columns in Microsoft Access is ___________.

False

A good choice for a primary key for the university's student database is the student phone number. (T/F)

True

A primary goal of a database system is to share data with multiple users.

inefficient use of space

A problem created with repeating groups is ___________________.

false

Aggregation associations are used to convert Many to Many relationships to multiple 1 to Many relationships.

orders by that customer will be deleted

Assume that you have a Customer table and an Order table, where Referential Integrity constraints require that a customer record be entered before an order can be entered. Also Cascade on delete is enforced. If you delete a Customer record, ______________.

Composition Association

Assume you are creating a database to handle the data associated with instruction at a university. What is the most appropriate special association to model the different elements contained in each classroom (i.e., projection equipment, blackboard type, computer support, etc)?

an insertion anomaly

Assume you are dealing with a purchasing database involving a single table. This table contains information on the customer, sale, and items purchased, where the sales order number is the primary key.Using this database design, the system will prevent you from entering any information on new products unless they are involved in a sale. This is an example of ______________.

false

Most databases allow multiple records that are identical (i.e., records that have the same values for all properties).

true

N-ary associations are used to convert Many to Many relationships to multiple 1 to Many relationships.

Feasibility study

One of the first phases of a new database project that involves critical areas, expensive hardware or software within the organization is called ___________.

true

Properties of an object are stored as columns in a table.

ensure that foreign keys can be entered only if the corresponding value exists in the originating table

Referential Integrity Constraints are used to ________________.

database management system (DBMS)

Software that defines a database, stores the data, supports a query language, produces reports and creates data entry screens is

true

Specifying a one (1) for the lower bound for the association multiplicity on a class diagram indicates that the item is required.

True

Specifying a zero (0) for the lower bound for the association multiplicity on a class diagram indicates that the item is optional.

true

Specifying an asterisk (*) for the association multiplicity on a class diagram indicates that the quantity of the item is unknown, and can have many items associated with it.

properties

Two different terms are used to describe the characteristics of interest for an entity. They are attributes and _____________.

Class

When building a database, the data dealing with an entity is modeled as a _____ .

Database Engine

Which component of the database management system (DBMS) most affects the performance (speed)?

associations (or relationships)

Business rules can be represented in the database through ________________.

Domain Key Normal Form

The ultimate goal in designing a database is to get all the tables into what normal form?

True

DBMS stores data efficiently with little wasted space.

incorporating business rules when defining the data

Data integrity can be improved by which of the following means ____________.

improve the quality of data entered for a specific property (i.e., table column)

Data integrity constraints are used to _____________________.

true

Data normalization minimizes data redundancy.

Class Diagram

Database system modelers use this type of diagram to graphically represent both the data structure and how the different objects are interrelated.

A foreign key may reference a value in the originating table that no longer exists

Failure to specify cascading delete when enforcing referential integrity can cause what problem?

False

If a table is in 3NF, it is also in 1NF. (t/f)

True

If a table is in DKNF, then it is also in 3NF. (T/F)

True

In a university database, the normal multiplicity for a relationship between courses and students would be many to many. (t/f)

False

In a university database, the normal multiplicity for a relationship between courses and students would be one to many. (t/f)

0:*

In a university environment, what is the appropriate multiplicity for an association linking courses with their list of pre-requisite courses? Focus on the numbers placed next to the 'Pre-requisite courses' side of the association.

true

Individual objects are stored as rows in a table.

no hidden dependencies exist between non-key fields and key fields

Tables in Boyce-Codd Normal Form (BCNF) if the table is in 3NF and ________.

do not have any repeating groups

Tables in first normal form (1NF) __________________.

there are no hidden dependencies

Tables in fourth normal form (4NF) if the table is in 3NF and ____________.

have all non-key fields depend on the whole primary key

Tables in second normal form (2NF) ___________________.

have all non-key fields depend on nothing but the primary key

Tables in third normal form (3NF) _______________.

True

Tables with non-compound primary keys (i.e., primary keys that are based on a single column) are always in second normal form. (t/f)

polumorphism

The ability to define common properties or functions in the higher class and then modify them in the lower classes is called _______________________.

how tables are related in the database

The association role defines ____________________.

Relational database

The database design that consists of multiple tables that are linked together through matching data stored in each table is called a ___________________.

Network Database

The database design that uses a hierarchical data structure, but incorporates multiple data entry points is called a ________________.

Relational Database

The database model that utilizes multiple tables interconnected through common attributes to store and manage information is called a ______________.

true

The developer can follow a specific set of procedures and rules to ensure that a table is in 1NF, 2NF and 3NF.

True

The employee - manager association is an example of a reflexive relationship (T/F)

foreign key

The fields in one table that link to the primary key in another table are called _________.

OODB incorporates methods in with the definition of the data structure, while RDB does not

The primary difference between the Relational database (RDB) and Object Oriented database (OODB) models is ____________________.

False

The primary key need not be unique for a given table. (t/f)

encapsulation

The process of defining and bundling all of the properties and functions into a class is called __________________________.

Data Normalization

The process to properly define the database tables to provide flexibility, minimize redundancy, and ensure data integrity is called ___________________.

primary key

The property (or set of properties) that uniquely defines each row in a table is called the ___________________.

true

The purpose of class diagrams is to model the interrelationships between the different classes in the database. (t/f)

retrieve and manipulate data

The role of the query system is to __________________.

entity

The term referring to a physical item existing in the real world that you want to track is called

Methods

The term used for the functions and procedures that work on class data is ______.

forms generator

The tool which assists in generating input screens is referred to as

Hierarchical

The traditional storage of data that is organized by customer, stored in separate folders in filing cabinets is an example of what type of 'database' system?