Display all the events happening on venue F3R21. Display all the events starting on November 21, 2019. • Display all events that have a seat count less than 150. Update the start date of event 1002 to November 19, 2019. ereenshot and document
Display all the events happening on venue F3R21. Display all the events starting on November 21, 2019. • Display all events that have a seat count less than 150. Update the start date of event 1002 to November 19, 2019. ereenshot and document
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
Related questions
Question
![• Display all the events happening on venue F3R21.
• Display all the events starting on November 21, 2019.
• Display all events that have a seat count less than 150.
Update the start date of event 1002 to November 19, 2019.
Screenshot your output and put it in 1 document file.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0091710a-db5e-4a71-a04b-b7b07210131d%2Fdf05f5bb-aa49-4cc4-aa22-c55c3378fde2%2F51o5e5h_processed.jpeg&w=3840&q=75)
Transcribed Image Text:• Display all the events happening on venue F3R21.
• Display all the events starting on November 21, 2019.
• Display all events that have a seat count less than 150.
Update the start date of event 1002 to November 19, 2019.
Screenshot your output and put it in 1 document file.
![Create a database named midLastname
Add below tables and their respective fields. Provide proper names for the tables
and attributes.
Events (Event ID, Event Type, Venue Code, Event Name, Start Date, End
Date)
Customers (Customer ID, Customer Name, Customer Phone, Customer
Email, Customer Address, Customer Payment Method)
Event Reservation (Booking ID, Customer iD, Event ID, Event Date, Event
Time, Date booking made, Booking Seat count)
Show all the tables inside the database.
• Add below information to each table and display the content of each table once
all the records are saved on the table.
1002
1003
1004
1005
Event ID Event Type Venue Code
Seminar
Review
Birthday
Training
FIR2
F3R21
F1R1
F3R21
Events
Event Name
TechiT Seminar
LET Review
Anna at 18
CSS Training
Customers
Start Date
2019/11/21
2019/12/12
2019/11/21
2019/11/21
End Date
2019/11/25
2019/12/23
2019/11/21
2019/11/25
Customer
Address
Pio Duran
09451387293hadapa@yahoo.com Sorsogon
City
Customer
Phone
Payment
Method
Cash
Visa
Customer Customer
Customer Email
ID
2110
2111
Name
Jona Lupera 09124581234lupera@gmail.com
Arby Hadap
2112
2113
Em Atanante 09931925195eatanante@gmail.com Legazpi City Master Card
Sheena
Aragon
09212345981saragon@gmail.com Camalig
Debit Card
Event Reservation
Date
Customer
Booking ID
ID
Event ID Event Date
Event
Time
Booking
Seat count
booking
made
2019/10/21 250
2019/10/12 300
3104
3105
3106
3107
2113
2112
2111
2110
1004
1002
1005
1003
2019/11/21
2019/11/21
2019/11/21
2019/12/12
5:00 PM
B:00 AM
9:00 AM
1:00 PM
2019/9/5
50
2019/10/18 h00](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0091710a-db5e-4a71-a04b-b7b07210131d%2Fdf05f5bb-aa49-4cc4-aa22-c55c3378fde2%2F1b2fdmq_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Create a database named midLastname
Add below tables and their respective fields. Provide proper names for the tables
and attributes.
Events (Event ID, Event Type, Venue Code, Event Name, Start Date, End
Date)
Customers (Customer ID, Customer Name, Customer Phone, Customer
Email, Customer Address, Customer Payment Method)
Event Reservation (Booking ID, Customer iD, Event ID, Event Date, Event
Time, Date booking made, Booking Seat count)
Show all the tables inside the database.
• Add below information to each table and display the content of each table once
all the records are saved on the table.
1002
1003
1004
1005
Event ID Event Type Venue Code
Seminar
Review
Birthday
Training
FIR2
F3R21
F1R1
F3R21
Events
Event Name
TechiT Seminar
LET Review
Anna at 18
CSS Training
Customers
Start Date
2019/11/21
2019/12/12
2019/11/21
2019/11/21
End Date
2019/11/25
2019/12/23
2019/11/21
2019/11/25
Customer
Address
Pio Duran
09451387293hadapa@yahoo.com Sorsogon
City
Customer
Phone
Payment
Method
Cash
Visa
Customer Customer
Customer Email
ID
2110
2111
Name
Jona Lupera 09124581234lupera@gmail.com
Arby Hadap
2112
2113
Em Atanante 09931925195eatanante@gmail.com Legazpi City Master Card
Sheena
Aragon
09212345981saragon@gmail.com Camalig
Debit Card
Event Reservation
Date
Customer
Booking ID
ID
Event ID Event Date
Event
Time
Booking
Seat count
booking
made
2019/10/21 250
2019/10/12 300
3104
3105
3106
3107
2113
2112
2111
2110
1004
1002
1005
1003
2019/11/21
2019/11/21
2019/11/21
2019/12/12
5:00 PM
B:00 AM
9:00 AM
1:00 PM
2019/9/5
50
2019/10/18 h00
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 8 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education