Answered step by step
Verified Expert Solution
Link Copied!

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 questionsimage text in transcribedimage text in transcribed

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 database

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Online Market Research Cost Effective Searching Of The Internet And Online Databases

Authors: John F. Lescher

1st Edition

0201489295, 978-0201489293

More Books

Students also viewed these Databases questions