CIS 330 Exam 1

“Each customer can have multiple orders, but each order belongs to only one customer." This statement is an example of a:

Business Rule

The following figure shows an example of:

a composite attribute

A relation is a

table with no multi-valued or composite attribute

For the relationship represented in the figure below, which of the following is true?

a department can have more than one employee

A functional dependency would occur when:

A non-key attribute determines another non-key attribute

Which one is NOT a characteristic of good data names (eg. entity names):

Technical

Which of the following might be an example of multivalued attribute?

Skill

Within a database context, a 'customer’ and a 'product’ are examples of:

None of the provided answers are correct

Normalization:

All of these provided answers are correct

When converting from a data model to a database table, the attributes of the entity become:

The columns of the table

An attribute that must have a value for each instance is a(n) ___ attribute.

Required

Which of the following is NOT considered a basic element of a data model?

Users

The property by which subtype entities possess the attributes of a supertype is called:

Attribute inheritance

Which of the following might be an example of a multivalued attribute?

Phone Number

An attribute in an entity that serves as the primary key of another entity is called a:

Foreign key

Which of the following could be considered a candidate key for an Employee table in a company database?

Both EmployeeID and SSN

The requirements for a table to be a relation include all of the following EXCEPT:

The table must have composite attributes

Which of the following criteria should be considered when selecting a primary key?

All of the provided answers are correct

If a table has multivalued attributes, the table is in __ normal form

None of the provided answers are correct

The process of defining a more general entity type from a set of more specialized entity types is known as:

Generalization

An attribute that can be broken down into separate parts is called a(n) __ attribute:

Composite

When creating an ERD, the primary key of the entity on the one side of a 1M relationship will become a __ in the entity on the many side of the relationship:

Foreign key

Which one is NOT a data anomaly?

Creative anomaly

Which of the following is an example of metadata?

Data type of a column in a database

For the relationship represented in the figure below, which of the following is true?

A customer does not have to have an account

The purpose of a relational database is to:

None of the provided answers are correct

A graphical system used to capture the number the nature of and relationships among data in called (a)

Data model

Within the context of database management, the term “knowledge” is defined as:

Useful facts that help in decision-making

A property or characteristic of an entity that is of interest to the organization is called an

Attribute

A person, place, object, event, or concept about which the organization wishes to maintain data is called an

Entity

All the transaction details of Walmart on February 24, 2025 are a good example of

Data

 From the enhanced ERD below, we can conclude that

Only resident patients are assigned to a bed 

We need to create ____ tables in total to transform below supertype/subtype entities between supertype and each subtype is ____ relationship

One-to-one

In the employee table, we calculate an employees total salary from their base salary and bonus. So, the total salary attribute is a good example of a(n) ____ attribute

Derived

If a relation has a simple primary key, we can tell that its in the second normal form

True

What are the functional dependencies in this table:

Transitive functional dependency

In enhanced ER diagram design, the attributes in… entities can be shared by all… entities, but each … entity will have its own unique attributes

Supertype, subtype, subtype

The process of defining one or more subtypes of a supertype is called:

Specialization

… are established between entities in a database so that the desired information can be retrieved from these entities in a single query

Relationships

… specifies the number of instances of one entity that can be associated with each instance of authority entity

Cardinality

Normal form identification

Choose the alternative that best represents the state of normalization of the table provided. Do not add or delete any column 

Do not assume reality … use only the data provided 

What normal form is the following table in?...

Complaint

2nd normal form

Which normal form is the following table in?

None, not in any normal form

What normal form is the following table in?...

1st normal form

What normal form is the following table in?

3rd normal form

What normal form is the following table in?...

2nd normal form