Q Normalize the following table up to 3 NFOnoOdateCustCNCustNameCityPhonePCodePnameCatIdCatNameQtyUPrice1/12/20176893692AmaniRuwiMarkerStationaryHardwareStationarySportsStationaryStationarySports19695251456M11501.2R1Printer1035PencilFootballP317311901/11/20196893692AmaniRuwi95251456P114PencilMarkerFootballP3217312002/12/20201232345AhmedSalalah898989980M12001.2P1154

Q Normalize the following table up to 3 NF Ono Odate CustCN CustName City Phone PCode Pname CatId CatName Qty UPrice 1/12/2017 Amani Ruwi 95251456 Marker Stationary Hardware 196 6893692 M1 150 1.2 35 R1 Printer 5 10 Pencil Football Pencil Marker Football Stationary 2 P3 2 173 1 1/11/2019 6893692 Amani Ruwi 95251456 P1 Sports Stationary Stationary 5 190 1 4 P3 2 173 1 200 2/12/2020 1232345 Ahmed Salalah 898989980 M1 2 200 1.2 P1 Sports 4

Q Normalize the following table up to 3 NF Ono Odate CustCN CustName City Phone PCode Pname CatId CatName Qty UPrice 1/12/2017 Amani Ruwi 95251456 Marker Stationary Hardware 196 6893692 M1 150 1.2 35 R1 Printer 5 10 Pencil Football Pencil Marker Football Stationary 2 P3 2 173 1 1/11/2019 6893692 Amani Ruwi 95251456 P1 Sports Stationary Stationary 5 190 1 4 P3 2 173 1 200 2/12/2020 1232345 Ahmed Salalah 898989980 M1 2 200 1.2 P1 Sports 4

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

Table name: EMPLOYEE EMP_NUM EMP_LNAME 215 Smith 216 Romero 217 Randall 218 Aarden Table name: EMP_EDUC EMP_NUM EDU_CODE EE_YEAR 215 84 2002 215 HS 1991 215 JC 1994 216 B4 1989 216 CDP 2004 216 CNP 2002 216 HS 1985 217 HS 1992 217 JC 2000 218 B4 1990 218 CDP 2000 218 CNP 2005 218 HS 1984 218 M2 1995 TABLE EMPLOYEE EDUCATION Table name: EDUCATION EDU_CODE EDU_DESCRIPTION a) For each table in the database, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided. EMP_EDUC 34 CDP CNP CPA DR HS JC M2 Bachelor's degree Certified data Processing Certified Network Professional Certified Public Accountant Earned Doctorate degree Highschool diploma PRIMARY KEY(s) Junior College degree Master's degree FOREIGN KEY(s)
Please solve!
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…
Consider the following two tables: Table1: Products productID productName unitPrice entryDate expiryDate P1 Dell Laptop 350 16-10-2016 30-10-2016 P2 Apple mobile 420 17-02-2018 02-03-2018 P3 Samsung Mobile 330 20-08-2020 30-08-2020 P4 HP Printer 80 21-09-2019 05-10-2019 P5 Canon Printer 150 15-05-2020 20-06-2020 Table2: Orders orderID Quantity Price productID 1 10 3300 P3 2 5 1800 P1 3 20 1600 P4 4 20 3000 P5 5 9 1100 P7 6 8 2250 P10 Draw three tables that can result by executing each of the following SQL statements. (Put your answer in a document word then upload it). 1. SELECT p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. price FROM Products AS p INNER JOIN Orders AS o ON p. productID = o. productID; 2. SELECT p. productName, p. unitPrice, p.…
Answer the following questions according to the ERD of the Airport system: AIRPORT FLIGHT AIRPORTCODE FLIGHTNUM FK ARPORTI CUSTOMER CUSTOMERNUM DTIME AIRPOR NAME CITY STATE DDATE ATIME ADATE DESTINATIONARPORT PRICE ARPLANENUMFKO AIRPORTCODEFK) FIRSTNAME MDOLENAME LASTNAME STREETNUMBER STREETNAME CITY STATE PHONE FKAIRPORT I FK AIRPLANE FK FLIOHT FK CUSTOMER AIRPLANE PAYMENT FLIOHTNUMEKO CUSTOMERNUMEK) AIRPLANENUM AIRPLANENAME CREDITCARDTYPE CREDITCARDNUM CAPACITY AIRPORTCODE(FIO BOOKDATE HOLDDATE EXPIREDHOLDDATE A. 4 How many primary key in the Flight entity? B.5 How many tables in the system can Customer table retrieve data from? C.1 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 Al Answers to save all answers. > > > >
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?
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'
Given the following relation that stores details of orders Orderld Itemld ItemQty Description price Custld CustName city Orderdate 125 563 48 Keyboard 15.00 56 John Texas 19/2/2009 125 851 30 Mouse 5.00 56 John Texas 19/2/2009 125 652 Hard disk Texas 19/2/2009 26 100.00 56 John 125 325 42 Modem 50.00 56 John Texas 19/2/2009 126 563 21 Keyboard 15.00 62 Мах New 20/2/2009 York 126 325 32 Modem 50.00 62 Мах New York 20/2/2009 126 652 18 Hard disk 120.00 62 New 20/22009 York Мах 126 851 18 Mouse 5.00 62 Мах New York 20/2/2009 If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE. Orderld > Orderdate ItemId → ItemQty Orderld, Itemid ItemQty Itemid > Description, price Custid → CustName, city Itemld > Orderdate
Identify the relational keys in the following two tables. Branch branchNo street city postcode SWI 4EH 16 Argyll St Aberdeen AB2 3SU 163 Main St Glasgow GI1 9QX BS99 INZ NW10 6EU BO05 22 Deer Rd London BO07 B003 BO04 32 Manse Rd Bristol BO02 56 Clover Dr London Staff staffNo fName IName position sex DOB salary branchNo SL21 John White Manager M 1-Oct-45 30000 BO05 SG37 Ann Beech Assistant F 10-Nov-60 12000 BO03 SG14 David Ford Supervisor M 24-Mar-58 18000 BO03 SA9 Mary Howe Assistant F 19-Feb-70 9000 BO07 SG5 Susan Brand Manager F 3-Jun-40 24000 BO03 SL41 Julie Lee Assistant F 13-Jun-65 9000 BO05 Tabel Superkey Candidate Primary Key Alternate Foreign Key Key Keys Branch Staff
display SQL query with screenshots
Apply normalization of the following data table showing all required details medicine medicine patient number patient national patient date of patient phone patient patient doctor doctor doctor name number birth address number name department name dose 1 7143 Sara 5698563 14-Jul-2003 Amman 8787878 12 Rami 512 formet 2x2 3421 Ahmad 2946292 22-Aug-1943 Irbid 4545454 32 Jana 402 surrat 3x2 3 7631 Linda 7355028 5-Feb-1976 Karak 1212121 12 Rami 512 rodofen 2x2 22-Aug-1984 2-Sep-2001 4 9629 Karam 1737649 Amman 7676767 45 Sameer 601 rodofen 3x1 5 4215 Muna 8539475 Zarqa 8989898 76 Hana 322 bedocy 2x3 6. 6342 Fadi 9653674 7-Nov-1992 Irbid 1234567 76 Hana 322 rodofen 3x2 7 2359 Samar 3372984 6-May-1998 Irbid 9876543 18 Salam 175 kalrasy 2x1
QUESTION 16 Consider the following two tables: Table1: Products productID productName unitPrice entryDate expiryDate P1 Dell Laptop 350 16-10-2016 30-10-2016 P2 Apple mobile 420 17-02-2018 02-03-2018 P3 Samsung Mobile 330 20-08-2020 30-08-2020 P4 HP Printer 80 21-09-2019 05-10-2019 P5 Canon Printer 150 15-05-2020 20-06-2020 Table2: Orders orderID Quantity Price productID 1 10 3300 P3 2 5 1800 P1 3 20 1600 P4 4 20 3000 P5 5 9 1100 P7 6 8 2250 P10 Draw three tables that can result by executing each of the following SQL statements. (Put your answer in a document word then upload it). 1. SELECT p. productName, p. unitPrice, p. expiryDate, o. Quantity, o. price FROM Products AS p INNER JOIN Orders AS o ON p. productID = o. productID; 2. SELECT p. productName, p.…