Table name: EMPLOYEE Database name: Ch03 StoreCo EMP CODE EMP TITLE EMP LNAME EVP FNAME EMP INITIAL EMP DOE STORE CODE 1 Mr. ilianson Jonn 21-May-84 2 Me. Ratula Noncy 00-Fob-80 3 Ms. Groenboro Lctte R 02-Oct-01 4 Mrs in 01-Jun-91 Rmperstro Smith Jennie 5 Mr. 6 Mr. 7 Mr. 8 Ms. 9 Mr. Rokert L 23-Nov-73 Renselaer Cary A 25-Dec-05 Opalo Roberto 31-Ju-82 3 10-Sep-88 19-Apr-75 Johnescn Elizabeth Crdsrar Jack 10 Mrs Jones Rose 06-Mar-85 4 11 Mr. Broderick Tom 21-Oct 92 12 Mr. Washington Alan C8-Sep-94 2 13 Mr Smth Peter 25-Aug-84 25 May 85 3 14 Ms. Smith Sherry H. 15 Mr. Clenko Howard 24-May-04 16 Mr. Archialo Barry 03-Sep-80 17 Ms. Grmsido Jeanine K 12 Nov.90 18 Mr. Rosonberg Androw D. 24-Jan-91 19 Mr. Rosten Peter 03-Oct-83 20 Mr Mckee Robert 06-Mar-90 21 Me. Baumann Jennifor 11-Doc-04 3 Table name: STORE STORE CODE STORE NAME STORE YTD SALES REGION CODE EMP CODE 8 1 Bccess Junction 1003455.76 2 2 Datebase Corner 1421 987.39 2 12 3 Tuplo Chargo O86783.22 4 Attribute Aley 944560.56 2 5 Primary Koy Point 2030098.45 1 15 Table name: REGION REGION CODE REGION DESCRIPT 1 East 2 Weat

Table name: EMPLOYEE Database name: Ch03 StoreCo EMP CODE EMP TITLE EMP LNAME EVP FNAME EMP INITIAL EMP DOE STORE CODE 1 Mr. ilianson Jonn 21-May-84 2 Me. Ratula Noncy 00-Fob-80 3 Ms. Groenboro Lctte R 02-Oct-01 4 Mrs in 01-Jun-91 Rmperstro Smith Jennie 5 Mr. 6 Mr. 7 Mr. 8 Ms. 9 Mr. Rokert L 23-Nov-73 Renselaer Cary A 25-Dec-05 Opalo Roberto 31-Ju-82 3 10-Sep-88 19-Apr-75 Johnescn Elizabeth Crdsrar Jack 10 Mrs Jones Rose 06-Mar-85 4 11 Mr. Broderick Tom 21-Oct 92 12 Mr. Washington Alan C8-Sep-94 2 13 Mr Smth Peter 25-Aug-84 25 May 85 3 14 Ms. Smith Sherry H. 15 Mr. Clenko Howard 24-May-04 16 Mr. Archialo Barry 03-Sep-80 17 Ms. Grmsido Jeanine K 12 Nov.90 18 Mr. Rosonberg Androw D. 24-Jan-91 19 Mr. Rosten Peter 03-Oct-83 20 Mr Mckee Robert 06-Mar-90 21 Me. Baumann Jennifor 11-Doc-04 3 Table name: STORE STORE CODE STORE NAME STORE YTD SALES REGION CODE EMP CODE 8 1 Bccess Junction 1003455.76 2 2 Datebase Corner 1421 987.39 2 12 3 Tuplo Chargo O86783.22 4 Attribute Aley 944560.56 2 5 Primary Koy Point 2030098.45 1 15 Table name: REGION REGION CODE REGION DESCRIPT 1 East 2 Weat

Programming Logic & Design Comprehensive

9th Edition

ISBN:9781337669405

Author:FARRELL

Publisher:FARRELL

Chapter8: Advanced Data Handling Concepts

Section: Chapter Questions

Problem 17RQ

See similar textbooks

Similar questions

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…
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: EMPLOYEE EMP_NUM EMP_LNAME 215 Smith 216 Romero 217 Randall 218 Aarden Table name: EMP_EDUC EMP_NUM EDU_CODE EE_YEAR 2002 1991 1994 1989 2004 2002 1985 1992 2000 1990 2000 2005 1984 1995 215 84 215 HS 215 JC 216 B4 216 CDP 216 CNP 216 HS 217 HS 217 JC 218 B4 218 CDP 218 CNP 218 HS 218 M2 Table name: EDUCATION EDU_CODE EDU_DESCRIPTION 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 Junior College degree Master's degree
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 2002 1991 1994 1989 2004 2002 1985 1992 2000 1990 2000 2005 1984 1995 215 84 215 HS 215 JC 216 B4 216 CDP 216 CNP 216 HS 217 HS 217 JC 218 B4 218 CDP 218 CNP 218 HS 218 M2 Table name: EDUCATION EDU_CODE EDU_DESCRIPTION 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 Junior College degree Master's degree
1. Write a database description for each of the relations shown, using SQL DDL (shorten, abbreviate, or change any data names, as needed for your SQL version). Assume the following attribute data types: StudentID (integer, primary key) StudentName (25 characters) FacultylD (integer, primary key) FacultyName (25 characters) CourselD (8 characters, primary key)
PET ID PET NAME PET TYPE PET AGE OWNER VISIT DATE PROCEDURE 246 ROVER DOG 12 SAM COOK JAN 13/2002MAR 27/2002APR 02/2002 01 - RABIES VACCINATION10 - EXAMINE and TREAT WOUND05 - HEART WORM TEST 298 SPOT DOG 2 TERRY KIM JAN 21/2002MAR 10/2002 08 - TETANUS VACCINATION05 - HEART WORM TEST 341 MORRIS CAT 4 SAM COOK JAN 23/2001JAN 13/2002 01 - RABIES VACCINATION01 - RABIES VACCINATION 519 TWEEDY BIRD 2 TERRY KIM APR 30/2002APR 30/2002 20 - ANNUALCHECK UP12 - EYE WASH The functional dependencies that I note are as follows: Pet ID --> Pet Name, Pet Type, Pet Age, Owner Pet ID, Visit Date --> {Visit Procedure} (the set of visit procedures), note the use of procedure codes that repeat, but are listed in their own column So, Is 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. Please help me understand this.
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…
Customers customer_id address_id first_name PK Addresses FK address_id city PK last_name phone state country note note Factors Рayment Factor_id customer_id PK FK peyment_method_id PK payment_method_id FK payment_name date note note Factor_items goods Good_groups good_id good_code good_name PK factor_id good_id quantity FK good_group_id PK FK name taxrate good_group_id good_cost FK Price note note ***Use Oracle SQL* • Write a trigger to save all modification on table Goods. (Update and Delete).
DB - Normalization Question # 1 Patient Medication Form Patient Number: P10034 Full name: Elbert McDonald Ward Number: Ward 11 Bed Number: B4 Ward Name: Orthopaedic Drug Number Name Description Dosage Method of Admin Unit per Day Start Date Finish Date 10223 10334 10223 Morphine Tetracyclene Morphine Pain Killer Antibiotic Pain Killer 10mg/ml 0.5mg/ml 10mg/ml Oral IV Oral 50 10 10 24/03/04 24/03/04 25/04/05 24/04/05 17/04/04 02/05/06 Examine the Patient Medication Form above: Put the above form into a relation schema Identify the functional dependencies. Describe and illustrate the process of normalization to produce 3NF relations. Question#2: Given the following Theatre Database form: No.of seats:500 Owner: J.Martin Year Founded: 1890 Owner’s Phone: 2347756 - - - - - Play Name Play Type No. of performances…
threaths of ELO values
46 Refer to the given table. Salesperson Number 137 137 137 106 106 106 106 204 204 361 361 361 Product Salesperson Number Name 19440 Baker 24013 Baker 26722 Baker 16386 Adams 19440 Adams 21765 Adams 24013 Adams 21765 Dickens 26722 Dickens 16386 Caryle 21765 Caryle 26722 Caryle SALESPERSON/PRODUCT table Commission Year of Department Manager Product Unit Percentage Hire Number Name Name Price 10 1995 73 Scott Hammer 17.50 10 1995 73 Scott Saw 26.25 10 1995 73 Scott Pliers 11.50 15 2001 59 Lopez Wrench 12.95 15 2001 59 Lopez Hammer 17.50 15 2001 59 Lopez 32.99 15 2001 59 Lopez 26.25 10 1998 73 Scott 32.99 10 1998 73 Scott 11.50 20 2001 73 Scott 12.95 20 2001 73 Scott 32.99 20 2001 73 Scott 11.50 4 Which quality of the table demonstrates why it is not in first normal form? O There are only non-key attributes visible. O There is data redundancy. There is no primary key. Each attribute has multiple values. Drill Saw Drill Pliers Wrench Drill Pliers Quantity 473 170 688 1475 2529 1962 3031…
Use the given data to classify the record below using the k-NN algorithm for k = 1 to 5. Loan Purpose Checking Repairs Savings Months Customer Employed Months 0 900 25 4 Click the icon to view the table of classified records. D Complete the table below for the nearest neighbors and for the classification of the new record for each value of k. k Distance Classification 1 2 3 4 5 (Round to four decimal places as needed.)