D426 – Data Management Foundations

A record consists of a ___

• Character

• Collection of related characters

• Set of one or more fields

• Group of files

A DBMS performs several important functions that guarantee the integrity and consistency of the data in the database. Which of the following is NOT one of those functions?

• Data integrity management

• Data storage management

• Data reports

• Security management

Which item is unstructured data?

• A record representing one student

• A video

• A table that holds student data

• A relational database that holds course registration data

Data is/are _____

• Information

• Raw facts

• Processed information

• A DBMS

Which classification is correct for the box marked “Registration” in the given E-R Diagram?

• A. Intersection data

• B. Modality data

• C. Cardinality data

• D. Student data

Which type of relationship exists between Student and Course in the Q5 diagram?

• One-to-many binary

• Many-to-many binary

• One-to-many unary

• Many-to-many unary

What is the E-R Diagram about an online pet food vendor showing?

• An Invoice Line can include many Items.

• An item can only be included in one Invoice Line.

• One Invoice Line must include a minimum of one and a maximum of one Item.

• The relationship between Item and Invoice Line is many-to-many.

A pet owner can have many pets; a specific pet is linked to one pet owner. Which kind of binary relationship is described in this example?

• One-to-one

• One-to-many

• Many-to-many

• Associative

A Database Models is ___

• a conceptual framework for database systems

• a leading relational database system sponsored by Oracle

• suitable for non-commercial applications such as education

• is a specification of database objects such as tables

What is the correct way to read the modality on the right side of the association?

• A. A maximum of one activity

• B. A maximum of zero activities

• C. A minimum of zero activities

• D. A maximum of many activities