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, 22.06.2019 07:30
What type of computer network ensures high security ?
Answers: 1
question
Computers and Technology, 22.06.2019 23:00
Which type of tab stop is most for weights and measurements?
Answers: 1
question
Computers and Technology, 23.06.2019 12:20
When guido van rossum created python, he wanted to make a language that was more than other programming languages. a. code-based b. human-readable c. complex d. functional
Answers: 1
question
Computers and Technology, 23.06.2019 14:00
Select the correct answer. andre was recently hired by an organization to check for system vulnerabilities. he is supposed to exploit these vulnerabilities and create a report on the extent of damage to which the system was susceptible. what position does andre hold in this organization? a. information security analyst b. information assurance manager c. penetration tester d. network security engineer e. chief information security officer
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 20:00
question
Mathematics, 21.04.2021 20:00
question
Mathematics, 21.04.2021 20:00
Questions on the website: 13722367