Database Fundamentals

Why does data inside a database need to be organized?

• “So the data can be found when needed”

• “So the data can be searched from the Internet”

• "So the data is neat and tidy”

• “So data integrity can be maintained”

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

• “Records”

• “Spreadsheets”

• “Forms”

• “Tables”

A store tracks customers and their orders in a database. Which table would NOT be part of this database?

• “Reviews table”

• “Inventory table”

• “Orders table”

• “Customers table”

A database contains a Customer table. What would be stored in a record of the Customer table?

• “Information about all the customers”

• “Information about one order”

• “Information about every order”

• “Information about one customer”

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”

The image represents a database. What does Item A indicate in the database?

• “A record”

• “A database”

• “A field”

• “A table”

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

• “Database Management System”

• “Fields and Records”

• “Primary Key”

• “Data Integrity”

Forms can be used to browse data, but they cannot be used to add, update or delete records.

• “True”

• “False”

You specify data types when adding ______.

• “Data to a database”

• “Data Integrity to a database”

• “Records to a table”

• “Fields to a table”

Data can be entered into the Datasheet view, but it can be easier to use a ______ instead.

• “Form”

• “Record”

• “Primary Key”

• “Field”