Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Complete Alexamara Marina Group Database: Problems 1-12 with screen shots of sql required. Question one is Creat a LARGE_SLIP with the table shown. Rest of
Complete Alexamara Marina Group Database: Problems 1-12 with screen shots of sql required. Question one is Creat a LARGE_SLIP with the table shown. Rest of the questions are on the document. Screen shots are requied for questions
Decimal Places Nulls Alowe? Descipbon No Marina numler (primary beyh Slip niumbur in the marins Eprimary y Annual rental fee for the slip Name of bout currvnly in thhe slip Number of beat nor rentind the slip AR4 No CHAR4 0LARGE SLIP table layout the LARGE SLIP table the marina number, slip number, rental fee. boat name, d owner number for those slips whose length is 40 teet amara has increased the rentai fee of each large slip by $100. Update the rental LARGE SLIP table accordingly Ator increasing the rental fee of each large slip by $100 (Exercise 3), Alexamara deciders b decrease the rental fee of any slip whose fee is more than $4,000 by 1% Update the renta ses in the LARGE SLIP table accordingly sert a new sip into the LARGE SLIP table. The marina number is 1, the slip number s Ad, the rental fee is $3.900.00, the boat name is Basan, and the owner number s FEO Delete all slips in the LARGE SLIP table for which the owner number is TR72 The name of the boat in marina 1 and slip A1 is in the process of being changed to an nknown name. Change the name of this boat in the LARGE SLIP table to null Add to the LARGE SLIP table a new character column named CHARTER that is one char acter in length. (This column will indicate whether the boat is available to be chartered.) Set he value for the CHARTER column on all rows to N. Change the CHARTER column in the LARGE SLIP table to Y for the slip containing the bost named Our Toy Change the length of the BOAT NAME column in the LARGE, SLIP table to 60 characters Change the RENTAL FEE column in the LARGE SLIP table to reject nulls Delete the LARGE SLIP table from the databaseStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started