I\'m not understanding this part of database systems fundamentals. 30 points (Us
ID: 3908974 • Letter: I
Question
I'm not understanding this part of database systems fundamentals.
30 points (Use the Marina Database for the remaining questions below) 2. Create a view named RAY_4025. It consists of the marina number, slip number,length, rental fee, boat name, and owner's last name for every slip in which the boat type is Ray 4025. a. Write and execute the CREATE VIEW command to create the RAY_4025 view. b. Write and execute the command to retrieve the marina number, slip number, rental fee boat name, and owner's last name for every slip in the RAY 4025 view with a rental fee of less than $4,000 20 points (5 points each) 4 Wnte but do not execute, the commands to grant the following privileges User Oliver must be able to retrieve data from the MARINA SLIP table b Users Crandall and Perez must be able to add new owners and slips to the database Users Johnson and Klein must be able to change the rental fee of any slip. All users must be able to retrieve the length, boat name, and owner number for every slip 10 points 10. Ensure that the LENGTH column in the MARINA SLIP table can accept only values of 25 30, or 40Explanation / Answer
a.) SQL command to create the View :- create view RAY_4025 as select marina_number,slip_number,length,rental_fee,boat_name,owner_lastname from marina where boat_type=RAY_4025; // Here boat_type is a column in marina database(table).
b.) SQL command to retrieve desired column with given condition:-SELECT marina_number,slip_number,rental_fee,boat_name,owner_lastname FROM RAY_4025 Where rental_fee < $4000;