Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need SQL-Code to all of the following questions. Lab# 8 EXCERCISE (18 marks) [4] Problem 8.1: Display the all customer's number, name and event
I need SQL-Code to all of the following questions.
Lab# 8 EXCERCISE (18 marks) [4] Problem 8.1: Display the all customer's number, name and event status and its estimated cost. Problem 8.2: Display the list of events and assigned to which employee. [4] [5] Problem 8.3: Display events requested which are planed in year 2018 and has Football stadium facility. Problem 8.4 Display the list Eventplan which has rate greater or equal to 15. [5] List of Tables used for Lab Exercises custno C100 C101 C103 C104 C105 custname Football Men's Basketball Baseball Women's Softball High School Football address Box 352200 Box 352400 Box 352020 Box 351200 123 AnvStreet Customer Internal contact phone city Yes Mary Manager 6857100 Boulder Yes Sally Supervisor 5431700 Boulder Yes Bill Baseball 5431234 Boulder Yes Sue Softball 5434321 Boulder No Coach Bob 4441234 Louisville Employee state zip 80309 80309 80309 80309 80027 phone 3-1111 5-1111 3-2222 3-3333 emono empname department email E100 Chuck Coordinator Administration chuck@colorado.edu E101 Mary Manager Football marv@colorado.edu E102 Sally Supervisor Planning sally@colorado.edu E103 Alan Administrator Administration alan@colorado.edu Facility facno facname F100 Football stadium F101 Basketball arena F102 Baseball field F103 Recreation room Location locno facno locname L100 F100 Locker room L101 F100 Plaza L102 F100 Vehicle gate L103 F101 Locker room L104 F100 Ticket Booth L105 F101 Gate L106 F100 Pedestrian gate Resource Tbi resno resname rate R100 attendant $10.00 R101 police $15.00 R102 usher $10.00 R103 nurse $20.00 R104 janitor $15.00 R105 food service $10.00 EventRequest eventno E100 E101 E102 E103 E104 E105 E106 E107 dateheld datereg facnol custno 25-Oct-2018 06-Jun-2018 F100 C100 26-Oct-2018 28-Jul-2018 F100 C100 14-Sep-2018 28-Jul-2018 F100 C100 21-Sep-2018 28-Jul-2018 F100 C100 03-Dec-2018 28-Jul-2018 F101 0101 05-Dec-2018 28-Jul-2018 F101 0101 12-Dec-2018 28-Jul-2018 F101 0101 23-Nov-2018 28-Jul-2018 F100 C105 dateauth status 08-Jun-2018 Approved Pending 31-Jul-2018 Approved 01-Aug-2018 Approved 31-Jul-2018 Approved 01-Aug-2018 Approved 31-Jul-2018 Approved 31-Jul-2018 Denied estcost $5,000.00 $5,000.00 $5,000.00 $5,000.00 $2,000.00 $2,000.00 $2,000.00 $10,000.00 estaudience budno 80000 B1000 80000 B1000 80000 B1000 80000 B1000 12000 B1000 10000 1000 10000 B1000 5000Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started