cis 1A Concepts Databases
Which of the following fields could be used as a primary key for a table? Possible primary key matches: Ordinary field in the table matches:
Possible primary key matches -Voter registration number -Social Security number -Driver's license number Ordinary field in the table matches -Street address -City -Last name -Party affiliation
In a relational database, a common field that links two tables in a relationship but is not a primary key is called a ______ key.
foreign
To create a relationship between two tables, it is necessary to create a ______ key in one table that is the primary key of the other table.
foreign
Where could you click to switch to Design view?
view
In the two tables in the image, which field is a foreign key?
FK OwnerID
To control how information is entered into a database, programmers and database administrators create ___ to help ensure data integrity.
forms
Forms structure data input to help ensure data______ , meaning the information entered is accurate, timely, and useful.
integrity
In the relationship shown in the image, the Owners table is linked to the Pets table by a one-to-many relationship. This means that each entry in the OwnerID field can be linked to many ___.
pets
So that users can find specific information quickly by using filters based on specific criteria, databases allow the creation of ___.
queries
A link between tables in a relational database that defines how the data are related is called a _____.
relationships
Forms allow data to go into a database, ___ display information coming out of a database.
reports
To display or distribute information from a database, programmers or database administrators create ___.
reports
A database provides the capability of conducting searches or asking questions. A question or search for information in a database is called a _________ .
query
