Question

Exercise 1 Questions

Answer Exercise 1 questions on a separate word document.

1. Terminology: For each description below, give the appropriate term to match the description (Hint: Remember terms are bolded in the text).
   1. There is a table that lists the different stores a retail location operations and different attributes about each store is contained in a column of the table. One of these attributes is location and another lists the date the store was first opened.
   2. Employees are listed in a payroll database. There is a field that contains numbers that the employees are given upon hire, and no two employees have the same number.
   3. Someone writes code that will search the database to tell their boss how many deliveries they have made to Hawaii in the past month.
   4. In a hospital database, there is a patient table, and every line in the table contains information from a patient.
   5. A firm has a policy that only gives permission to alter or change data already stored in the database.
   6. A field in a table listing delivery addresses has numbers that uniquely identify which customer is attached to the delivery.

Answer 1

Hello,

I have MySQL queries for your points you can run that query by understanding them. You can try it in SqlFiddle. Please find the attachment down below-:

IF YOU FIND THIS ANSWER USEFUL, PLEASE UPVOTE