Question: Can anyone solve this ? Sailors(sid integer, sname: string, rating: integer, age: real) Boats( bid integer, bname: string, color: string) Reserves(sid integer, bid integer, day

Can anyone solve this ? Can anyone solve this ? Sailors(sid integer, sname: string, rating: integer,

integer, day date) Create data base tables using above attributes, Note: pk

Sailors(sid integer, sname: string, rating: integer, age: real) Boats( bid integer, bname: string, color: string) Reserves(sid integer, bid integer, day date) Create data base tables using above attributes, Note: pk represented as attribute underlined. Insert following information into those tables. rating | age l lsid I sname 22 Dustin 7 29 Brutus 31 Lubber8 32 Andy 45.0 33.0 55.5 25.5 35.0 35.0 16.0 35.0 25.5 22 10110/10/98 22 102 10/ 10098 22 10310/8/98 8 22 104 10/7/98 58Rusty 10 64 Horatio 7 71 Zorba 10 74 Horatio 9 85 Art 31 102 11/10/98 31 103 11/6/98 31 104 11/12/98 64101 9/5/98 64 102 9/8/98 74 103 9/8/98 95 Bob 3635 Figure S.1 An Instance 53 of Sailors Figure 5.2 An Iestance R2 of Reserves bid bname color 0 Interlake blue 102 Interlake red 103 Clipper green 104 Marinered Figure 5.3 An Iastance BI of Beats Write the query to extract following information from above tables. I a) Find the names and ages of all sailors? b) Find the' names and ages of distinct sailors

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!

6- Remember the Informal Design Guidelines for Relation Schemas. 11 - What does the following query find? In our example we have a university database. Instructors' information is kept in the...

25. What does the following query compute? 16- Following ER diagram is given to you. There is a 1:1 relationship between Professor and Department entities. Which of the following options are correct...

The question is related to mysql database. Given the following schema: Sailors ( sid: integer, sname: string, rating: integer, age: real ) Boats ( bid: integer, bname: string, color: string )...

Please do this in sql. Thanks, lmk if you have any questions. An Instance of Boats An Instance of Sailors An Instance of Reserves Sailors (sid: integer, sname: string, rating: integer, age: real)...

Run the following SQL querie. Do not show duplicates Find the age of the oldest sailor for each rating level that has reserved a red boat Sailors( sid: integar, sname: string, rating: integer, age:...

Relational Algebra Expression Create Database, Table and Use SQL Server Managament Studio to write code on New Query for each question Cho luoc do quan h gm cc quan h - Sailors(sid: integer, sname:...

Relational Algebra Expression Create Database, Table and Use SQL Server Managament Studio to write code on New Query for each question ( 6-7-8-9-10 ) Cho luoc do quan h gm cc quan h - Sailors(sid:...

Relational Algebra Expression Cho luoc do quan h gm cc quan h - Sailors(sid: integer, sname: string, rating: integer, age real) Boats(bid:integer, bname: string, color: string Reserves(sid: integer,...

keys are underlined in each relation. Specify the following queries in relational algebra using above database schema . 1). Find names of sailors who have reserved a RED boat? 2). Find names of...

keys are underlined in each relation. Specify the following queries in relational algebra using above database schema . 1) Find names of sailors who have reserved a RED or a GREEN boat? 1.1) Can also...

A Cold Inc. is a frozen food distributor with 10 warehouses across the country. Iven Tory, one of the warehouse managers, wants to make sure that the inventory policies used by the warehouse are...

The indexed nested-loop join algorithm described in Section 13.5.3 can be inefficient if the index is a secondary index, and there are multiple tuples with the same value for the join attributes. Why...

In the one - period valuation model, the current stock price increases if the dividend payment paid next year falls. the expected sales price increases. the expected sales price decreases. the...

In the context of the IT job market, the top information systems job belongs to the computer programmer chief technology officer systems analyst webmaster

KEY QUESTION You are choosing between two goods, X and Y, and your marginal utility from each is as shown on the next page. If your income is $9 and the prices of X and Y are $2 and $1, respectively,...

LAST WORD In what way is criminal behavior similar to consumer behavior? Why do most people obtain goods via legal behavior as opposed to illegal behavior? What are societys main options for reducing...

ADVANCED ANALYSIS A mathematically fair bet is one in which a gambler bets, say, $100, for a 10 percent chance to win $1000 dollars ($100 .10 $1000). Assuming diminishing marginal utility of...