Exam 2: Data Models

The external model is the representation of the database as "seen" by the DBMS.

Oracle12c, MS SQL Server, and Taminoare examples of _____ data models.

Each row in a relation is called a(n) _____.

VMS/VSAM is an example of the _____.

Students and classes have a _____ relationship.

The term _____ is used to refer to the task of creating a conceptual data model that could be implemented in any DBMS.

Today, most relational database products can be classified as object/relational.

MySQL is an example of the _____.

Even when a good database blueprint is available, an applications programmer's view of the data should match that of the manager and the end user.

An implementation-ready data model should contain a description of the data structure that will store the end-user data.

Each row in the relational table is known as a(n) _____.

The _____ data model is said to be a semantic data model.

In the context of data models, an entity is a person, place, thing, or event about which data will be collected and stored.

The _____ data model uses the concept of inheritance.

A(n) _____ enables a database administrator to describe schema components.

Describe the three basic characteristics of Big Data databases.

A(n) _____ is the equivalent of a field in a file system.

_____ are important because they help to ensure data integrity.

A noun in a business rule translates to a(n) _____ in the data model.

Business rules must be rendered in writing.