Construct an appropriate SQL query (Create Table) for the following i. Member ii. Make
Construct an appropriate SQL query (Create Table) for the following i. Member ii. Make
Chapter4: Analyzing And Charting Financial Data
Section: Chapter Questions
Problem 2.5CP
Related questions
Question
![Take a look at these member, booking, make tables.
Table 1: Member
Last Name Gender Age
Female 25
Male
36
Female 25
Female 25
Female 36
Male
37
Male
26
Female 37
Male 24
Male
23
Member ID
1582
2587
3549
9536
2567
2154
3265
8765
3259
6540
3
4
Booking ID
1
2
5
6
First Name
Mara
Philip
Kathleen
7
8
Sau
Shanice
Chase
Tommie
Dorcas
Angel
Weston
Room
Hashimoto
Gent
Hanner
Pfau
Mccrystal
Karner
Jia
Room 15
Room 25
Room 1
Room 15
Room 5
Room 21
Room 3
Room 8
Darity
Sanor
Martina
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
4
Table 3: Make
MemberID
3549
9536
6540
2154
2567
2154
3265
1582
Country
Uganda
France
United States
United States
China
Australia
5
6
7
8
United States
United States
France
China
Cost per day
$200.00
$80.00
$80.00
$150.00
$150.00
$80.00
$120.00
$300.00
BookingID
1
2
3
4
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
Pending
Pending](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F500cea67-3997-42d8-9421-57143e50bac2%2F61dfcc25-bce3-4951-b1cc-b67d4a89fc83%2Fksb8lgw_processed.png&w=3840&q=75)
Transcribed Image Text:Take a look at these member, booking, make tables.
Table 1: Member
Last Name Gender Age
Female 25
Male
36
Female 25
Female 25
Female 36
Male
37
Male
26
Female 37
Male 24
Male
23
Member ID
1582
2587
3549
9536
2567
2154
3265
8765
3259
6540
3
4
Booking ID
1
2
5
6
First Name
Mara
Philip
Kathleen
7
8
Sau
Shanice
Chase
Tommie
Dorcas
Angel
Weston
Room
Hashimoto
Gent
Hanner
Pfau
Mccrystal
Karner
Jia
Room 15
Room 25
Room 1
Room 15
Room 5
Room 21
Room 3
Room 8
Darity
Sanor
Martina
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
4
Table 3: Make
MemberID
3549
9536
6540
2154
2567
2154
3265
1582
Country
Uganda
France
United States
United States
China
Australia
5
6
7
8
United States
United States
France
China
Cost per day
$200.00
$80.00
$80.00
$150.00
$150.00
$80.00
$120.00
$300.00
BookingID
1
2
3
4
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
Pending
Pending
![1) Construct an appropriate SQL query (Create Table) for the following
i. Member
ii. Make
) Use the same tables to present any ONE (1) example of how
database integrity can be shown.
) Construct a proper SQL query for the following questions.
i. Display the names, age, date of booking of the member
who have made booking and their status shows paid.
ii. Find the information about the member's name, country
as well as the room's number who has made the booking
on 4th April 2022.
iii. How many female members over the age of 26, particularly
from China as well as France, are there?](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F500cea67-3997-42d8-9421-57143e50bac2%2F61dfcc25-bce3-4951-b1cc-b67d4a89fc83%2Frtuxfbv_processed.png&w=3840&q=75)
Transcribed Image Text:1) Construct an appropriate SQL query (Create Table) for the following
i. Member
ii. Make
) Use the same tables to present any ONE (1) example of how
database integrity can be shown.
) Construct a proper SQL query for the following questions.
i. Display the names, age, date of booking of the member
who have made booking and their status shows paid.
ii. Find the information about the member's name, country
as well as the room's number who has made the booking
on 4th April 2022.
iii. How many female members over the age of 26, particularly
from China as well as France, are there?
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.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![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
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Programming with Microsoft Visual Basic 2017](https://www.bartleby.com/isbn_cover_images/9781337102124/9781337102124_smallCoverImage.gif)
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L