An agency called Resourcecover supplies part-time/temporary staff to hotels throughout Mauritius. The table shown in Figure 1 lists the time spent by agency staff working at two hotels. The National Insurance Number (NIN) is unique for each employee. NIN contractNo HrsPerWeek empName HotelNo HotelLocation 125WD C1024 16 Samuel Н25 Grandbay Fody 142XA C1024 24 Dev Samy Н25 Grandbay 169YD C1025 28 Sara Ally H4 Tamarin 125WD C1025 16 Samuel H4 Tamarin Fody Figure 1: Resourcecover i. The table shown in Figure 1 is susceptible to update anomalies. Provide examples of insertion, deletion, and update anomalies. ii. Describe and illustrate the process of normalising the table shown in Figure 1 to 3NF. State any assumptions you make about the data shown in this table.

An agency called Resourcecover supplies part-time/temporary staff to hotels throughout Mauritius. The table shown in Figure 1 lists the time spent by agency staff working at two hotels. The National Insurance Number (NIN) is unique for each employee. NIN contractNo HrsPerWeek empName HotelNo HotelLocation 125WD C1024 16 Samuel Н25 Grandbay Fody 142XA C1024 24 Dev Samy Н25 Grandbay 169YD C1025 28 Sara Ally H4 Tamarin 125WD C1025 16 Samuel H4 Tamarin Fody Figure 1: Resourcecover i. The table shown in Figure 1 is susceptible to update anomalies. Provide examples of insertion, deletion, and update anomalies. ii. Describe and illustrate the process of normalising the table shown in Figure 1 to 3NF. State any assumptions you make about the data shown in this table.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Identify for each table, the followings: Foreign keys Candidate keys Primary key Alternate keys
Convert to normilation (1-NF or 2-NF or 3-NF
Use excel XVOOKUP FIND THE INFO ABOUT SALE MADE BY LAURA
DEPENDENT FNAME DOB Relationship ЕMPID 111 MAI 29/1/2001 Mother 012 222 SALEH 7/4/2001 Single 033 333 AHMED 23/2/1980 Father 087 NORMALIZE THIS TABLE THIS 3NF
Appendix EMPLOYEE Fnamo Minit Lname Ssn Bdato Addross Ser Salary Super ssn Dno 123456789 1965-01-00 731 Fondron, Houston, TX M 30000 333445555 333445555 1955-12-08 638 Voss, Houston, TX John B Smith Franklin Wong 40000 888665555 25000 987654321 999887777 1968-01-10 3321 Castlo, Spring, TX Wallaco 987654321 1941-06-20 201 Borry, Bollaire, TX Alicia Zolaya 4. Jonnifor 43000 888665555 4. Narayan 666884444 1962-09-15 975 Fire Oak, Humblo, TX M 38000 333445555 English 453453453 1972-07-31 5631 Rice, Houston, TX Ramosh K Joyce 25000 333445555 Ahmad V Jabbar 987987987 1969-03-20 980 Dalas, Houston, TX M 25000 087654321 4. James Borg 888665555 1937-11-10 450 Stono, Houston, TX M 55000 NULL DEPARTMENT DEPT LOCATIONS Dnamo Dnumber Mgr ssn Mgr start date Dnumbor Dlocation Rosearch 333445555 1988-05-22 Houston Administration 4. 987654321 1995-01-01 Stafford Headquarters 1. 888665555 1981-06-19 5. Bellaire 5. Sugarland Houston WORKS ON PROJECT Essn Pno Hours Pname Prumber Plocation Dnum 123456789…
ERD:- PK CHECKOUT Check Num FK1 Book_Num FK2 Pat_ID Check Out Date Check_Due Date Check_In_Date PK BOOK Book Num Book Title Book_Year Book_Cost Book_Subject FK1 Pat_ID -H- PATRON PK Pat ID Pat_FName Pat_LName Pat_Type WRITES PK,FK1 Book Num PK,FK2 Au ID AUTHOR PK AU ID Au_FName Au_LName Au_BirthYear
SUPPLIER PRODUCT ProductCode ProductnName unitPrice SupCode supCode (Number, 3) SupName (text, 20) АВC LLC (Number, 10) [Char(10)] (>0) 1111111 Calculator 10 111 111 2222222 Notebook 2.5 777 222 ХҮX LLC 3333333 Book-AI 20 222 3333 PQR LLC 4444444 Pen -2.0 222 222 AXL LLC 5555555 Pencil .500 111 Eraser .500 222
So if I have this table: staffNo dentistName patientNo patientName appointment_date appointment_time surgery_no S1011 Tony Smith P100 Gillian White 12-Aug-03 10:00 S10 S1011 Tony Smith P105 Jill Bell 13-Aug-03 12:00 S15 S1024 Helen Pearson P108 Ian MacKay 12-Sep-03 10:00 S10 S1024 Helen Pearson P108 Ian MacKay 14-Sep-03 10:00 S10 S1032 Robin Plevin P105 Jill Bell 14-Oct-03 16:30 S15 S1032 Robin Plevin P110 John Walker 15-Oct-03 18:00 S13 Here the non-trivial functional relations include at least the following: staffNo --> dentistName patientNo -->patientName partientNo, appointment_date, appointment_time --> surgery_no Do you believe there are other functional dependencies? If so, what are they? If not, why not? Do you believe it would help to create additional attributes during normalization? If so, what are they? If not, justify why it's not needed.How do I draw this out?
PK Cus CODE PK INV NUMBER PK,FK1 INV NUMBER LINE NUMBER HEDenerates contains PK CUS LNAME CUs FNAME CUs INITIAL CUS AREACODE CUS PHONE CUS BALANCE FK1 CUS CODE INV DATE P CODE LINE UNITS LINE PRICE FK2 is found in VENDOR PRODUCT PK V CODE PK P CODE V NAME v CONTACT V AREACODE V PHONE V_STATE V ORDER P DESCRIPT P INDATE P_QOH P MIN P PRICE DISCOUNT FK1 V CODE upplies Write a SQL query to list the product code, vendor code, and vendor name for all products and includes those vendors with no matching products. Y CODE- PRODUCTY CODE
move data to 1st 2nd and 3rd normal form
Use the table below to find the output PRODUCT_ID PRODUCT_NAME BRAND UNIT PRICE SUPPLIER_ID CATEGORY_ID 113 Note Book Atlas Pieces 5 S1 C1 114 Sticky Note Fanta Воx 4.3 S3 C1 117 Paper Clips Nizwa Packet .5 S4 C1 111 A4 Paper Double A Ream 2 S1 C2 112 Plastic envelope Atlas Packet 1.7 S2 C1 115 White Board Marker Pentel Вох 2.2 S3 C2 116 Stapler Small Nizwa Pieces S4 C1 Write the OUTPUT of the following SQL Statement: 1- SELECT brand FROM products WHERE price = 2.2; 2 - SELECT product_name FROM products WHERE product_name like "%Ma%' 3 - SELECT price * 2 FROM products WHERE product_id = 111 4 - SELECT unit FROM products WHERE supplier_id = 'S3' and Category_id ='C1'
The system to be developed for Williams and Son needs to produce the following slip for a customer once the sale has been concluded. Williams & Son VATnr: 0123456 Product Price Screwdriver R 100 Super glue R 20 Total: R120 Please note: For the purpose of this assignment, assume that a customerwill only purchase one unit of each item.