Answered step by step
Verified Expert Solution
Link Copied!
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

image text in transcribed

I need SQL-Code to all of the following questions.image text in transcribed

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 5000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students explore these related Databases questions