Read the scenarios below, then use the drop-down menus to decide if you should use a database.
You created a spreadsheet to track your monthly expenses. Use a database.✔ Do not use a database.
A human resources employee created a spreadsheet to track each employee’s name, address, e-mail, phone number, salary, benefits, time, and expenses. The information is analyzed and presented to the company’s managers to assess employee productivity and to make hiring decisions. ✔ Use a database.Do not use a database.
You created a spreadsheet to keep track of your favorite books. Use a database.✔ Do not use a database.
Which of the following differentiates records in the Employees table? NameStore ID✔ Employee IDAddress
Read the scenarios below, then use the drop-down menus to decide if you should use a database.
Read the scenarios below, then use the drop-down menus to decide if you should use a database.
Why is a database the best tool for managing the social media website’s data? Choose all that apply.
Which of the following describes the first step to creating a database?
How should you set up the database?
Which of the following describes a category of information that links one table to another table?
What is the primary key in the Products table? ✔ Product IDStore IDName
Which of the following is the most compelling reason to use a database?
A company created a website where people can buy books, movies, electronics, and household items. ✔ Use a database.Do not use a database.
In which of the following steps do you assign a primary key to each table?
Which of the following should you choose for the tables?
What is the foreign key in the Employees table that creates a link to the Stores table? Employee IDAddressPhone Number✔ Store ID
Suppose you switched from using a single spreadsheet to multiple data tables in a database. Which of the following advantages are you most likely going to experience by making the switch?
A national restaurant chain with over two hundred locations needs to keep track of a large volume of information, including food suppliers, employees, and customer orders. ✔ Use a database.Do not use a database.
What is the foreign key in the Employees table that creates a link to the Products table? NameEmployee ID✔ Store IDProduct ID
Did you find these answers helpful?