INVOICESINVOICE LINEINVOICE NUM INVOICE DATE CUST ID11/15/2021INVOICE NUM ITEM ID QUANTITY14216QUOTED PRICE14216125CA75$37.991421911/15/202122714219AD72$79.991422211/16/202129414219DT124.$39.991422411/16/202118214222LD14$47.991422811/18/202143514224KH814.$18.9914231142331423711/18/202111/18/202112514228FS42$124.9943514228PF191.$74.9911/19/202161614231UF392.S189.9914233KH81$19.99QB92WB49LP7314233$109.9514233$74.9514237$54.95ТЕМITEM ID DESCRIPTIONON HANDCATEGORYLOCATIONPRICEDog Feeding StationFenthers Bird Cage (12x24x18)AD7212DOGB.$79.9910BRDB$79.99CA75Enclosed Cat Litter Station15CAT$39.99Dog Toy Gift SetFly Mask with FRarsFolding Saddle StandAquarium (55 Gallon)DT1227DOGB$39.99FM2341HOR$24.95FS3912HOR$39.99FS42FSHA.$124.99KHS1LD14Wild Bird Food (25 Ib)24BRD$19.99Locking Small Dog Door14DOG$49.99LP73Lange Pot Carrier23DOG$59.99Pump & Filter KitQuilted Stable Blanket$74.99$119.99PF19FSHA.OB9232HORC2SP91Small Pet Carrier18CATB$39.99UF39Underground Fence System7.DOGA.$199.99WB49Insulated Water Bucket34HOR$79.99

INVOICES INVOICE LINE INVOICE NUM ITEM ID QUANTITY QUOTED PRICE 14216 INVOICE NUM INVOICE DATE CUST ID 14216 11/15/2021 125 CA75 $37.99 14219 11/15/2021 227 14219 AD72 2. $79.99 14222 11/16/2021 294 14219 DT12 4. $39.99 14224 11/16/2021 182 14222 LD14 $47.99 14228 14231 11/18/2021 11/18/2021 435 125 14224 KH81 $18.99 14228 FS42 1. $124.99 14233 11/18/2021 435 PF19 UF39 14228 1. $74.99 14237 11/12021 616 14231 2. S189.99 14233 KH81 $19.99 14233 4. QB92 WB49 LP73 $109.95 14233 14237 4. $74.95 $54.95 ITEM ITEM ID DESCRIPTION ON HAND LOCATION PRICE $79.99 CATEGORY AD72 12 Dog Foeding Station Feathers Hird Cage (12x24x18) DOG 10 BRD $79.99 CA75 Enelosed Cat Litter Station 15 CAT C. $39.99 DT12 Dog Toy Gift Set Fly Mask with Ears Folding Saddle Stand Aquarium (55 Gallon) Wild Bird Food (25 Ib) Locking Small Dog Door Large Pot Carrier Pump & Filter Kit Quilted Stable Blanket $.99.99 $24.95 $.39.99 $124.99 27 DOG B FM23 41 HOR C. FS39 12 HOR FS42 5. FSH KHS1 24 BRD C. $19.99 LD14 14 DOG $49.99 LPT3 23 DOG FSH $59.99 PF19 $74.99 QB2 32 HOR $119.99 SP91 Small Pet Carrier 18 CAT B $39.99 UF39 DOG tinderground Fence Systom Insulated Water Bucket 7. $199.99 WH49 34 HOR $79.99

INVOICES INVOICE LINE INVOICE NUM ITEM ID QUANTITY QUOTED PRICE 14216 INVOICE NUM INVOICE DATE CUST ID 14216 11/15/2021 125 CA75 $37.99 14219 11/15/2021 227 14219 AD72 2. $79.99 14222 11/16/2021 294 14219 DT12 4. $39.99 14224 11/16/2021 182 14222 LD14 $47.99 14228 14231 11/18/2021 11/18/2021 435 125 14224 KH81 $18.99 14228 FS42 1. $124.99 14233 11/18/2021 435 PF19 UF39 14228 1. $74.99 14237 11/12021 616 14231 2. S189.99 14233 KH81 $19.99 14233 4. QB92 WB49 LP73 $109.95 14233 14237 4. $74.95 $54.95 ITEM ITEM ID DESCRIPTION ON HAND LOCATION PRICE $79.99 CATEGORY AD72 12 Dog Foeding Station Feathers Hird Cage (12x24x18) DOG 10 BRD $79.99 CA75 Enelosed Cat Litter Station 15 CAT C. $39.99 DT12 Dog Toy Gift Set Fly Mask with Ears Folding Saddle Stand Aquarium (55 Gallon) Wild Bird Food (25 Ib) Locking Small Dog Door Large Pot Carrier Pump & Filter Kit Quilted Stable Blanket $.99.99 $24.95 $.39.99 $124.99 27 DOG B FM23 41 HOR C. FS39 12 HOR FS42 5. FSH KHS1 24 BRD C. $19.99 LD14 14 DOG $49.99 LPT3 23 DOG FSH $59.99 PF19 $74.99 QB2 32 HOR $119.99 SP91 Small Pet Carrier 18 CAT B $39.99 UF39 DOG tinderground Fence Systom Insulated Water Bucket 7. $199.99 WH49 34 HOR $79.99

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter8: Advanced Sql

Section: Chapter Questions

Problem 69C: Update the DETAILRENTAL table to set the values in DETAIL_RETURNDATE to include a time component....

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…
Indicate the changes you need to make to the KimTay Pet Supplies database to support the following additional requirement. Each location has a manager who is identified by a manager ID, a manager first name, and a manager last name.
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
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 EMP Column name Column type Integer Up to 10 characters Example entry EMPNO ENAME Description Employee ID number Employee surname 7369 SMITH Integer Integer Employee's job title No ID no. of employee's JOBNO 10 MGR 7566 manager HIREDATE Date 17/12/1980 Date employment started Monthly salary SAL Integer 1600 Table JOB Column name Column type Integer Up to 15 characters Example entry Description job title No Employee's job title JOBNO 10 JOB TITLE SALESMAN a) Write SQL statements to create EMP and JOB tables. Define appropriate data types and check constraints for the tables' fields. Write SQL statements to populate these tables with 3 rows of sample data.
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
student takes ID ID course_id sec_id semester year grade пате dept_name tot_cred section course department course_id sec_id semester year building room_no time_slot_id course_id title dept_name credits advisor dept_name building budget s_id i id time_slot time_slot_id day start_time end_time prereq instructor classroom COurse_id prereg_id ID building пате dept_name salary room_no сараcity teaches ID course_id sec_id semester year Consider the relation that results from the expression: course natural join department Which of the following functional dependencies hold for this relation? (Mark all that apply) O {title, credits} -> building O dept_name -> budget O course_id -> {budget} O {building, budget} -> dept_name O title -> credits O {course_id, title} -> credits
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
DESPATCH_LIST Order no Order Cus_name Dave E GONES 6023 6023 6028 6152 6152 date 28 Feb 28 Feb 02 Mar 04 Mar Dave E GONES Nick F JENS CHENG Chui 04 Mar CHENG Chui Order amount $1,248 $1,248 $1,290 $999 $999 Prod no EH06 DL21 EH06 SM17 SP38 Description Electric heater Desk lamp Electric heater Quantity Depot no Location 3 • Depot no determines Location (Order_no, Prod_no) determines Quantity, Depot_no 3 6 Sewing machine 1 Sewing pack 10 where, (Order_no, Prod_no) is the Primary Key • Order_no determines Order_date, Cus_name, Order_amount • Prod_no determines Description N24 K10 НОЗ N24 K10 Shatin Hunghom Aberdeen Shatin Hunghom Q4.Draw the dependency diagram for the DESPATCH_LIST table above. Identify all dependencies including functional, partial and transitive dependencies.
Given the Employee, Class, and Training tables. Employee Emp_id (PK) EM8765 Address USA Name Phone Email Ali ali@yahoo.com nazire@gmail.com katrina@gmail.com lemi@hotmail.com alican@yahoo.com mustafa@hotmail.com hasan@gmail.com 98733211 ЕМ3456 Nazire Dubai 98764533 90857464 EM7658 Katrina USA EM1987 Lemi USA 99663425 EM8009 Alican UK 95583372 |EM7698 Mustafa Dubai Jordan 92234452 EM6666 Hasan 92123366 Class Class_id (PK) Class_name Multimedia Credit СOM106 COM206 Database сомз06 Public Speaking 9. Training Table Emp_id (FK) EM8765 Date Class_id (FK) Result 05-May-2010 08-May-2011 08-Feb-2010 08-Feb-2010 соM106 Pass EM3456 COM206 Pass EM7658 сомз06 Fail EM1987 сомзо6 Fail 28-Jan-2011 10-March-2012 EM8009 сомз06 Pass EM7698 сом106 Fail EM8765 08-May-2011 сOM206 Pass Write the appropriate SQL queries a) Get the address of employee whose name is Alican b) Get the name and email of employees located in Dubai. Sort the results in alphabetical order of name. c) Show the count of employees…
The data in flat files has been provided: INVOICE TABLE INVOICE_NUM CUSTOMER_ID INVOICE_DATE EMPLOYEE_ID COIN_ID DELIVERY_ID 8111 11011 15 May 2021 emp103 7111 511 8112 11013 15 May 2021 emp101 7116 512 8113 11012 17 May 2021 emp101 7112 513 8114 11015 17 May 2021 emp102 7111 514 8115 11011 17 May 2021 emp102 7115 515 8116 11015 18 May 2021 emp103 7115 516 8117 11012 19 May 2021 emp105 7112 517 8118 11013 19 May 2021 emp105 7112 517 COIN_RETURNS TABLE RETURN_ID RETURN_DATE REASON CUSTOMER_ID COIN_ID EMPLOYEE_ID ret001 25 May 2021 Customer not satisfied with product 11011 7116 emp101 ret002 25 May 2021 Product missing part 11013 7114 emp103 COIN TABLE COIN_ID PRODUCT PRICE QTY 7111 1oz Gold Kruger Rand R 5 999 10 7112 1oz Silver Kruger Rand R 12 999 8 7113 Gold Big 5 Uncirculated R 15 999 8 7114 Silver Big 5 Pack R 7 999 5 7115 1oz Gold Palaeontology R 11 999 15 7116 1oz Silver Palaeontology R 7 999 12 COIN_DELIVERY TABLE…
Create a C++ program that will perform record management of students. The code must involve implementation of control structures / array / struct/user-defined functions/class. INSTRUCTION: 1. Create a User's Menu for your program. An example is given below: Record Management [1] Add Record [2] Display Record Input your Choice: __ 2. If 1 is chosen, the user will be allowed to create 2 unique student records using the ADD_RECORD user-defined function. 3. After creating 2 records, the user may choose 2 to display existing and non-existing records. Use DISPLAY_RECORD user-defined function. 4. Perform the following 4 Test Cases below. 5. Submit the following through our Summative Assessment submission link on our Course Site on or before the deadline: a. C++ Code (.cpp) file b. Screenshot of Outputs using 4 Test Cases