Define a view named LARGE SLIP. It consists of the marina number, slip number, r

Question

Define a view named LARGE SLIP. It consists of the marina number, slip number, rental fee,
boat name, and owner number for every slip whose length is 40 feet.
a. Write and execute the CREATE VIEW command to create the LARGE SLIP view.
b. Write and execute the command to retrieve the marina number, slip number, rental fee, and
boat name for every slip with a rental fee of $3800 or more.
c. Write and execute the query that the DBMS actually executes.
d. Does updating the database through this view create any problems? If so, what are they? If
not, why not?
2. Define a view named RAY 4025. It consists of the marina number, slip number, length, rental
fee, boat name, and owner

Explanation / Answer

I] A) CREATE VIEW LARGE_SLIP AS SELECT Marina_Number,Slip_Number,Rental_fee,Boat_Name,Owner_Number FROM [TableName] WHERE Length=40 B) Select Marina_Number,Slip_Number,Rental_fee,Boat_Name from LARGE_SLIP where Rental_fee>=3800 C) Select Marina_Number,Slip_Number,Rental_fee,Boat_Name from LARGE_SLIP where Rental_fee>=3800 D) Updating The database through this view will changes the base table data. So, becareful while deleting, updating the rows in the view. keep in mind that we are not capturing all the columns of the base table. II] A) CREATE VIEW RAY_4025 AS SELECT Marina_Number,Slip_Number,Length,Rental_fee,Boat_Name,Owner_Lst_Nme FROM [Base_Table_Name] WHERE Boat_type="RAY 4025" B) Select Marina_Number,Slip_Number,Rental_fee,Boat_Name,Owner_Lst_Nme from RAY_4025 where Rental_fee

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---