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. Sheet1+ACEF1 IDNAMEEMP IDPOSITIONRATE1 Blanche Dishner438927Manager$25.0032 NULL372991Night crew$17.0043 Luciano Sloney300126Night crew$17.0054 Dorris GoodsellNULLCashier$15.005 Sybil Fain6 Shaun McNeil7 Olen Wigley119325Clerk$11.007200743Cashier$13.008222345Cashier$14.0098 Dovie Seawood109321Clerk$12.009 Magdalen Mullaney256921Cashier$-101110 Salena Souza185549Clerk$12.001211 Paige Alvarez132943Clerk$11.001312 Cassy Lundin391285Night crew$-1413 Tajuana Stoval491621Manager$23.001514 Joaquina Piasecki185392Clerk$13.001615 Janiece Abelson244332Cashier$13.0016 Rogelio Peppler17 Fatima Haymaker17128872Clerk$11.0018100321NULL$13.001918 Rico Fairbank318821Night crew$16.002019 Trey Peloquin488326Manager$24.002120 Paulene Thibeau193931Clerk$12.0022

INSERT INTO Account: VALUES (188820, ‘Wendall Glass’, $12) UPDATE Account: Set salary = $12 WHERE ID…

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 = 128872 DELETE FROM Account WHERE ID = 244332 Calculate the grocery store’s SUM salary and the AVG salary per position.

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 = 128872 DELETE FROM Account WHERE ID = 244332 Calculate the grocery store’s SUM salary and the AVG salary per position.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter7: Developing An Excel Application

Section: Chapter Questions

Problem 3RA

See similar textbooks

Similar questions

Member ID 1582 2587 3549 9536 2567 2154 3265 8765 3259 6540 First Name Mara Philip Kathleen Sau Shanice Chase Tommie Dorcas Angel Weston BookingID 1 2 3 4 5 6 7 8 Table 1: Member Last Name Gender Age Female 25 Male 36 Female 25 United States Female 25 United States Hashimoto Gent Hanner Pfau Mccrystal Karner Jia Darity Sanor Martina Room Room 15 Room 25 Room 1 Room 15 Room 5 Room 21 Room 3 Room 8 Date 29-Dec-2020 9-Dec-2021 3-Mar-2019 4-Sep-2021 13-Feb-2021 6-May-2021 10-Nov-2020 4-Apr-2022 Table 2: Booking Days 2 4 6 5 10 6 5 Female 36 Male 37 Male 26 Female 37 Male 24 Male 23 4 Table 3: Make MemberID 3549 9536 6540 2154 2567 2154 3265 1582 $150.00 $80.00 $120.00 $300.00 Country Uganda France 3 4 China Australia United States United States Cost per day $200.00 $80.00 $80.00 $150.00 5 6 7 8 France China BookingID 1 2 Joined Date 16-Aug-2020 21-May-2015 12-Dec-2017 16-Aug-2019 16-Aug-2020 1-Jan-2021 29-Dec-2018 21-May-2019 4-Mar-2019 1-Feb-2022 Status Paid Paid Pending Paid Pending Paid…
Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME ELC D102 D101 IT D103 BSD D104 ENG Table name: STUDENTS STUDENTID STUDENTNAME DOB GENDER ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE 6/1/1999 Male 12/30/1994 Female 6/1/1999 Male 5/6/1995 Male 10/15/1992 Male S103 Hisham 90 D102 A102 Level 1 22 S102 Sara 45 D103 A104 Diploma 27 S101 Salim 45 D103 A104 Diploma 22 S107 Khalil 45 D101 A101 BTech 26 S109 Said 45 D104 A101 Advanced Diploma 29 s100 Ahmad 5/1/1995 Male 45 D101 A103 BTech 26 S104 Faisal 4/5/1998 Male 90 D104 A101 Advanced Diploma 23 S105 Fatima 2/23/1992 Female 90 D102 A102 Level 2 29 9/12/1999 Female 8/13/1991 Female S106 Arwa 45 D102 A102 Level 3 22 S108 Ibtisam 90 D103 A104 Diploma 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech level
Table name: ADVISORS ADVISORID ADVISORNAME A102 Sami A103 Alice A104 Suad A105 Tamil A101 Arun Table name: DEPARTMENTS DEPTID DEPTNAME D102 ELC D101 IT D103 BSD D104 ENG Table name: STUDENTS STUDENTID STUDENTNAME DOB GENDER ALLOWANCE DEPTID ADVISORID STUDENTLEVEL AGE Hisham 6/1/1999 Male 90 D102 S103 A102 Level 1 22 12/30/1994 Female 45 D103 S102 Sara A104 Diploma 27 S101 Salim 6/1/1999 Male 45 | D103 A104 Diploma 22 5107 Khalil 5/6/1995 Male 45 D101 A101 Blech 26 45 | D104 Advanced Diploma S109 Said 10/15/1992 Male A101 29 5/1/1995 Male 45 D101 90 D104 5100 Ahmad BTech Advanced Diploma A103 26 4/5/1998 Male 2/23/1992 Female 9/12/1999 Female S104 Faisal A101 23 0 D102 45 D102 S105 Fatima 90 A102 Level 2 29 S106 Arwa A102 Level 3 22 S108 Ibtisam 8/13/1991 Female 90 D103 A104 Diploma 30 Write the SQL statement for the following: 1. Using the ON clause, display the advisor name and student name for all students in the BTech level 2. Display the student name, gender and department name of…
estion Completion Status: AIRPORT FLIGHT AIRPORTCODE FLIGHTNUM FK AIRPORT1 CUSTOMER AIRPOR NAME DTIME CUSTOMERNUM CITY DDATE FIRSTNAME ATIME ADATE DESTINATIONAIRPORT PRICE AIRPLANENUM(FK) AIRPORTCODE(FK) STATE MIDDLENAME LASTNAME 3. STREETNUMBER STREETNAME CITY FK AIRPORT I STATE PHONE 1. FK AIRPLANE FK_FLIGHT FK CUSTOMER AIRPLANE AIRPLANENUM PAYMENT FLIGHTNUM(FK AIRPLANENAME CUSTOMERNUM(FK) CAPACITY CREDITCARDTYPE AIRPORTCODE(FK) CREDITCARDNUM BOOKDATE HOLDDATE EXPIREDHOLDDATE A. 1 How many primary key in the Flight entity? B.5 How many tables in the system can Customer table retrieve data from? C. 4 How many attributes in the Airport Table? D.5 How many tables in the system? E. 5 How many relationships shown in the system? Click Save and Submit to save and submit. Click Save All Answers to save all ansuwers.
Kennedy Rogers: Module 7 Computer Concepts Exam - Work - Microsoft Edge https://samcp.cengage.com/Assignment Take/Exam?assignmentld-93029900&resultid=67239973&instld-f1dabeb4-2a2d-4f89-bf90-8b470938d375... y T ss Tips ess Tips R YOU Tools For Microso s and Compu e Feedback Task 42 of 57 65°F Partly sunny 3 OA. MP4 OC. E D H ME C $ C. WAV > Q Search 4 R F V %6 Assignment: Module 7 Computer Co... 5 Which of the following audio formats does not use any compression technique? T G 6 L Y H & 7 B N U * J 8 Attempts Remaining 1 M Save Answer ( K Task: MC516313 Which of the following audio formats does not use an... CLU 9 O OB.MP3 OD. WMA O L alt > kulu A P - ctri ( ? + [ = F se brt sc || < 4 ] pause delete Submit O backspace home 0 enter 3 4 num lock T shift 7 X A and urse A E X 2:32 PM 4/26/2023 O 1 M and A-Z 8 sam A L 13 G 5
questionnn
INVOICES INVOICE LINE INVOICE NUM INVOICE DATE CUST ID 11/15/2021 INVOICE NUM ITEM ID QUANTITY 14216 QUOTED PRICE 14216 125 CA75 $37.99 14219 11/15/2021 227 14219 AD72 $79.99 14222 11/16/2021 294 14219 DT12 4. $39.99 14224 11/16/2021 182 14222 LD14 $47.99 14228 11/18/2021 435 14224 KH81 4. $18.99 14231 14233 14237 11/18/2021 11/18/2021 125 14228 FS42 $124.99 435 14228 PF19 1. $74.99 11/19/2021 616 14231 UF39 2. S189.99 14233 KH81 $19.99 QB92 WB49 LP73 14233 $109.95 14233 $74.95 14237 $54.95 ТЕМ ITEM ID DESCRIPTION ON HAND CATEGORY LOCATION PRICE Dog Feeding Station Fenthers Bird Cage (12x24x18) AD72 12 DOG B. $79.99 10 BRD B $79.99 CA75 Enclosed Cat Litter Station 15 CAT $39.99 Dog Toy Gift Set Fly Mask with FRars Folding Saddle Stand Aquarium (55 Gallon) DT12 27 DOG B $39.99 FM23 41 HOR $24.95 FS39 12 HOR $39.99 FS42 FSH A. $124.99 KHS1 LD14 Wild Bird Food (25 Ib) 24 BRD $19.99 Locking Small Dog Door 14 DOG $49.99 LP73 Lange Pot Carrier 23 DOG $59.99 Pump & Filter Kit Quilted Stable…
TABLE 4-6 Parking Tickets at Millennium College Parking Ticket Table St ID L Name F Name Phone No St Lic Lic No Ticket # Date Code Fine 38249 Brown Thomas 111-7804 FL BRY 123 15634 10/17/12 2 $25 16017 11/13/12 1 $15 82453 Green Sally 391-1689 AL TRE 141 14987 10/05/12 $100 16293 11/18/12 1 $15 17892 12/13/12 2 $25 1. Convert to INF Relation 2. Draw dependency diagram showing all functional dependencies 3. Identify anomalies 4. Convert to 3NF Relations 5. Develop EER Diagram with appropriate cardinalities
List the department IDs for those departments that have less than 5 employees: Employee Did Salarycode Ename Eid Ephone Samer 15 23 2345 70092485 Sarah 13 12 5088 71092246 Ahmad 4 26 7712 03099348 Jalal 15 22 9664 76093148 Elie 8 23 3054 70092729 Fadi 24 2976 03091945 Layal 9 21 4490 71099380 Select one: a. SELECT Did FROM Employee GROUP BY Did HAVING SUM(Eid) < 5; O b. SELECT Did, COUNT(Eid) FROM Employee GROUP BY Did; O c. None of these d. SELECT Did FROM Employee GROUP BY Did HAVING COUNT(Eid) < 5;
Q9. Write an SQL statement to answer the question: 'Are there any bookings not driven by qualified drivers, i.e. driver tvpe not matching vehicle type?’ The resulting table is as follows. BOOK ID VEH_DESC YEH_TYPE 1 8728 Volvo FM12 Medium Truck Vincent Ma LGV DRIVER_MAME DRIVER_TYPE BOOK_DATE BOOK_TIME BOOK_HRS |2022/3/4 14:30 2 Q10. In view of the possible problem as per Q9, suggest a way to prevent such booking. You may consider running query to highlight this or changing the data model to prevent so. Explain your suggestion.
The table below is how Magical Medical Place (MMP) keep track of the medication it givens to patients and the doctors that prescribed the medication. Doc ID Doc Name Pat Name Pat contact 321456 John 321457 Sarah Medication Price Quantity Reggy Samual 0861236548 Penicillin R200 10 0796549872 Antibiatics R400 20 Robafen Cough Doxycycline Penicillin Antibiotics Robafen Cough R10 40 321459 Mary 321460 Linda 321461 John 321462 Robert Susan 0116549875 R250 20 Reggy 0861236548 R200 10 0321789654 0987349165 R400 20 Queen Junior R10 25 3.1 In which normal form is the above table? Motivate your answer. 3.2 Identify a Primary Key and motivate why the identified attributes were chosen. 3.3 Provide all the dependencies of the given table. 3.4 Convert the table into the second normal form. 3.5 Convert the table into the third normal form. 3.6 Must is the purpose of Normalization? 3.7 Provide two(2) suggestions on how to improve the design of the table after they have been restructured into third…
Mailings Review View Help m、m、和三E AaBbCcI AaBbCcI AAB6C AaBbCc AaBbC AaBbo 目三==這、田。 1 Normal I No Spac. Heading 1 Heading 2 Title Subt Styles Paragraph 2. What is a syntax tree? Draw the syntax tree for the expression a*(b+c)*d.