1. Hiroshi Yoshimura is chair of the Panda Preservation Project, which maintains a database of all panda bears across the globe. The database design includes a relational database comprising two tables. The first table stores the name, birth date, and other characteristics of panda bear parents that have been registered. In this table, each panda bear parent is uniquely identified by a registration number.

The second table stores the name, birth date, and other characteristics of panda bear kids that have been registered. In this table, each panda bear kid is uniquely identified by a registration number. This second table also includes the registration numbers of each panda bear kids parents. The panda bear kids in the second table are linked to their parents in the first table by means of the registration numbers of both parents.

How many primary keys are in the relational database?

Zero (0)

One (1)

Two (2)

Three (3)

2. Which of the following statements about databases and the data hierarchy is not true?

The database management system is a software package that can handle relational databases better than non-relational databases

The data stored in an inventory file that lists and describes every item of inventory that a company carries would make sense to be stored in a master file

A table and a file are essentially the same

A record stores the information about one file entity (e.g., one employee in a payroll file, one sales transaction in a sales file, etc.)