Spreadsheet Charts/Database Concepts Test

1. In the school's student database, which is an example of the MOST APPOIATE primary key?

Student Number

Last name

First name

Birthdate

The most appropriate primary key in the school's student database would be the Student Number. A primary key is a unique identifier for each record in a database table, and the Student Number is likely assigned to each student and would not be duplicated. This ensures that each student record can be uniquely identified and accessed efficiently. The other options, such as Last name, First name, and Birthdate, may not be unique and could lead to data duplication or inefficiencies in retrieving specific student records.

Explanation

The most appropriate primary key in the school's student database would be the Student Number. A primary key is a unique identifier for each record in a database table, and the Student Number is likely assigned to each student and would not be duplicated. This ensures that each student record can be uniquely identified and accessed efficiently. The other options, such as Last name, First name, and Birthdate, may not be unique and could lead to data duplication or inefficiencies in retrieving specific student records.

2. In a large corperate database, which is an example of the MO)ST APPROPRIATE primary key?

Driver Number

Number of laps

Number of races

Total winnings

In a large corporate database, the most appropriate primary key would be the "Driver Number." A primary key is a unique identifier for each record in a database table, and the "Driver Number" would serve this purpose effectively. It is likely that each driver in the database would have a unique driver number assigned to them, making it a suitable choice for a primary key. The other options, such as "Number of laps," "Number of races," or "Total winnings," may not be unique to each driver and could lead to data duplication or inconsistencies.

Explanation

In a large corporate database, the most appropriate primary key would be the "Driver Number." A primary key is a unique identifier for each record in a database table, and the "Driver Number" would serve this purpose effectively. It is likely that each driver in the database would have a unique driver number assigned to them, making it a suitable choice for a primary key. The other options, such as "Number of laps," "Number of races," or "Total winnings," may not be unique to each driver and could lead to data duplication or inconsistencies.

3. Which is an example of a approiate field name?

Patent's fist name and bithdate

Name/Last

Patient's fist name and ID

First name

The correct answer is "First name" because it is a clear and concise field name that accurately describes the information it is intended to capture. It follows a standard naming convention and does not include unnecessary or redundant information.

Explanation

The correct answer is "First name" because it is a clear and concise field name that accurately describes the information it is intended to capture. It follows a standard naming convention and does not include unnecessary or redundant information.

4. Which is an example of a field that can be formatted with an input mask?

Zipcode

Yes/No

Male/Female

Adult/Child

A field that can be formatted with an input mask is a Zipcode. An input mask is a way to enforce a specific format for data entry. In the case of a Zipcode, an input mask can be used to ensure that the user enters the correct number of digits and follows the specific format for Zipcodes in a particular country. This can help to prevent data entry errors and ensure consistency in the data collected.

Explanation

A field that can be formatted with an input mask is a Zipcode. An input mask is a way to enforce a specific format for data entry. In the case of a Zipcode, an input mask can be used to ensure that the user enters the correct number of digits and follows the specific format for Zipcodes in a particular country. This can help to prevent data entry errors and ensure consistency in the data collected.

5. Max wants to create a list of graduate degreesin a database that will allow the selection of early three choices:BSBA, MBA, and MBE. What field property should he use?

Yes/No

AutoNumber

Lookup

Number

Max should use the Lookup field property to create a list of graduate degrees in the database. This field property allows for the selection of multiple choices from a predefined list, which is suitable for Max's requirement of selecting three choices from the options of BSBA, MBA, and MBE.

Explanation

Max should use the Lookup field property to create a list of graduate degrees in the database. This field property allows for the selection of multiple choices from a predefined list, which is suitable for Max's requirement of selecting three choices from the options of BSBA, MBA, and MBE.