Database Fundamentals

Which of the following is an easy way to enter and browse data in a large database?

• “Records”

• “Spreadsheets”

• “Forms”

• “Tables”

In relational database design one thing to consider it the unique value that will be used for the primary key. Which of the following would be considered a proper field to consider using as a primary key? Select the best answers.

• Phone Number

• Customer ID Number

• Null Value

• Primary Value

An attribute in one table whose values matches the primary key in another table is called a ____ key.

• primary

• foreign

• car

• dbms

A store needs to keep track of suppliers and inventory. What software can be used to create the database, tables, fields and records?

• “Forms”

• Database”

• “Database Management Software”

• “Data Integrity”

Which of the following rows shows the correct way to design table fields destined to contain an individual’s full name?

• A

• B

• C

• D

You discover many errors in a database table. What has been lost?

• “Database Management System”

• “Fields and Records”

• “Primary Key”

• “Data Integrity”

What would you call the data that is displayed on your monitor?

• Input

• Output

• Data

• Pixels

The ____________________ key is an attribute that uniquely identifies any given entity.

• foreign

• primary

Within the network model, the ____ is the conceptual organization of the entire database as viewed by the database administrator.

• DBTG

• subschema

• schema

• data management language

A relational database is a collection of ____.

• tables

• columns

• values

• records