Database Quiz a
Your college has a database with a Students table. Which of the following could be a primary key in the table?
- Student number - Social Security Number - Street address - Last name
What element of a database field specifies the data in a field such as text, numeric, or date/time?
Data Type
Because he wanted to be able to sort gifts according to continent and time zone, in 1984 Santa switched from using long lists to using _____.
Databases
In a database a _____ is a group of related characters in a database table that represents a characteristics of someone or something.
Field
To control how information is entered into a database, programmers and database administrators create ___ to help ensure data integrity.
Forms
Adam was in the fifth grade when he was adopted by the Smith's. Because his school used a centralized database, all of his teachers had his correct name on their grade reports. This is an example of how a centralized database can help improve data ___ .
Integrity
The DBMS engine provides an interface for the end user of the database. This interface is called the ____ view.
Logical
When you receive a utility bill, you're actually getting a report that was generated by a database management system. The DBMS subsystem that provides for data maintenance, analysis, and the generation of reports is called the data ___ subsystem.
Manipulation
In the datasheet view of a relational database (such as Microsoft Access) a row of information is called a ___ .
Record
A link between tables in a relational database that defines how the data is related is called a ______.
Relationship