subject

Imagine you work for an independent grocery store with 20 employees. The business owner has tasked you with creating a relational database that will track employee names, IDs, positions (e. g., cashier, manager, clerk, or night crew), and salaries. Create a relational database table in Microsoft® Excel® for the grocery store using the provided data points. Apply the universal rules (unique primary keys, unique column names, no duplicate rows) to your table. Include all necessary null values. Display in the table the requested database queries:INSERT INTO Account: VALUES (188820, ‘Wendall Glass’, $12/h)UPDATE Account: Set salary = $12/h WHERE ID = 128872DELETE FROM Account WHERE ID = 244332Calculate the grocery store’s SUM salary and the AVG salary per position.

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 21.06.2019 19:30
Can you make money in why are you guys so
Answers: 1
question
Computers and Technology, 23.06.2019 12:00
What type of slide show is a dynamic and eye-catching way to familiarize potential customers with what your company has to offer? a. ole b. photo album c. brochure d. office clipboard
Answers: 2
question
Computers and Technology, 23.06.2019 18:30
How often does colleges update the cost of attendance on their website? . a)every two years b) every four years c) every year d) every semester
Answers: 1
question
Computers and Technology, 24.06.2019 08:20
Evaluate the scenario below and indicate how to handle the matter appropriately. situation: michael received an e-mail from what he thought was his doctor’s office, requesting his social security number. since he had just been in to see his doctor last week, he replied to the e-mail with his social security number.
Answers: 2
You know the right answer?
Imagine you work for an independent grocery store with 20 employees. The business owner has tasked y...
Questions
question
Mathematics, 21.04.2021 21:10
question
Health, 21.04.2021 21:10
question
Mathematics, 21.04.2021 21:10
question
Mathematics, 21.04.2021 21:10
question
Mathematics, 21.04.2021 21:10
question
English, 21.04.2021 21:10
question
Mathematics, 21.04.2021 21:10
question
Biology, 21.04.2021 21:10
Questions on the website: 13722363