Exam 5: Database Processing

SQL is an international standard language for processing a database.

________ is the process of converting a data model into tables, relationships, and data constraints.

The columns in a database are called ________.

Which of the following is a developmental task of database administration?

________ is the process of converting a poorly-structured table into two or more well-structured tables.

Each table in a database must have two or more primary keys.

Each entity in a database has a unique attribute called a(n)________.

The accuracy of a database design is not dependent on the corresponding data model.

Identify an open source DBMS product.

An identifier is an attribute or a group of attributes whose value is associated with one and only one entity instance.

A ________ describes the data and relationships that will be stored in a database.

What is a database application?

Charles and Irene are editors at a content development firm. Both of them, unknowingly, are working on the same copy of the annual report. Irene finishes editing the report and saves her copy; Charles saves his report an hour after Irene. Charles's report overwrites Irene's, and her changes are lost. This scenario is an example of the ________.

Describe entities in the context of data models.

Owen, the database administrator for a shipping company, is responsible for checking the data model, which is to be used in the database management system, for accuracy and completeness. This is an example of Owen's ________ tasks.

Albert creates a relational database to store employee performance statistics. He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee. The "Employee Number" column is referred to as a ________.

In a data model, a(n)________ is something that a user wants to track.

Which of the following statements correctly describes the relationship between drones and videos in Falcon Security's database?

Define the symbols and terms used in entity-relationship (E-R)diagrams.

Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. She should use a ________ to obtain the information that she wants from the database.