Database Concepts Quiz

_____ is used to store a logically related data.

• file

• database

• data model

• DBMS

The element of ERD that represents real-world things such as people, places, or events about which we want to store data is called:

• attributes

• database

• relationship

• entities

The properties of entities that are used to differentiate one entity from the other entity is called:

• attributes

• database

• relationship

• entity

_____________ is considered as a blueprint of a database.

• attributes

• database

• data model

• entities

In a relational data model, entities are represented as:

• attributes

• relations

• data models

• databases

____ is a container of database objects in Microsoft Access.

• field

• database

• table

• form

A field which has a unique value for each record of a table is called:

• foreign key

• attribute

• data type

• primary key

One of the following is not a valid data type name for a field ___.

• text or string

• number

• entity

• date

A Query in Microsoft Access is used to:

• store data for future use

• select records from the underlying table that meet some search criteria

• create a form to facilitate data entry

• None

In order to retrieve data from two or more tables through query, we must establish a _____ between tables.

• field

• primary key

• relationship

• criteri