Question: Section 2: Structured Query Language (15 Marks) Given a boat reservation database schema as defined below. Captain (CID, CaptName, CaptRating, Captage) Boat (BoatID, BoatName, BoatColor)

Section 2: Structured Query Language (15 Marks) Given a boat reservation

Section 2: Structured Query Language (15 Marks) Given a boat reservation database schema as defined below. Captain (CID, CaptName, CaptRating, Captage) Boat (BoatID, BoatName, BoatColor) Reservation (CID, BoatID, Date, Purpose) 1. 2. 3. Find the names and ages of all captains. [2 marks] Find all captains with ratings above 7. [2 marks] Find the names of Captains who have reserved boat number 110. [3 marks] Calculate the total of reservations of Red boats. [3 marks] Find the names of Captains who have reserved at least one boat. [3 marks] Find the ages of Captains whose name begins with a B. [2 marks] 4. 5. 6

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

What does SQL stand for? Question 2 0 options: 1 ) Standard Query Linguistics 2 ) Structured Query Language 3 ) Strict Query Language 4 ) None of the above

Lab 2 Structured Query Language. Student Firstname Lastname Student Number Date of birth Address Street City State Zipcode County Country Grades Module Attempt (1,2,3 etc..) DateExam DateEntered...

1. Key features of cloud database include... A. Enterprise users are able to host databases without the need to buy and maintain specialized hardwareEnterprise users are able to host databases...

CS630 - DATABASE Systems-Final Project Group Project: 2 students The following is an example of the business case similar to what you must create:(You can still select other domains like library,...

Which is used in many applications, where we require at least 2 of the following (something you know, something you have, something you are)? * 1- Open Authentication 2- Structured Query Language 3-...

1- What are the basic requirements of a relational database? 2- Structured Query Language (SQL) is used to retrieve data from a database. Why an accountant would needs to learn?

You are part of a team required to create an E-commerce Website (Business to Consumer e.g. amazon) Question 1: Software Life Cycle (SDLC) a) List the functional requirements to build the system...

XML external entities ( XXE ) attacks target which type of data? 1 - User authentication credentials 2 - Structured Query Language ( SQL ) commands Prove compliance with COBIT. 3 - provide feedback...

I am working on my final project in an SQL class using MYSQL. I am working my way through it but it is going slow so I think that I may need a little bit of help to finish in time. If I could get a...

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

The preconditions for an audit are that management acknowledges and understands its responsibility for: A) Preparation of the financial statements in accordance with the applicable financial...

Anusha the supervisor in packaging department collects all time cards from employees, review, and submit them to payroll department. Payroll department is responsible to prepare the payroll cheques...

A company made an ordinary repair to a delivery truck at a cost of 1 5 0 0 . The companies s accountant debited the asset account equipment was this treatment and error and if so , what will be the...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

In an Excel Pivot Table, how is a Fact/Measure Column repeated?

In Gender Pay Equity Studies in the Federal Service, how can comparisons be ensured across Job of Comparable Worth?

In the Federal Evaluation System (FES), what standards are used in the Job Evaluation Process?