Chapter 5, Question 12, Page 174:
Using your knowledge of the college environment, determine the functional dependencies that
exist in the following
table. After determining the functional dependencies, convert this table to a
Alexamara Marina Group Case
1. Create a view named LargeSlip using the data in the MarinaNum, SlipNum, RentalFee, BoatName, and
OwnerNum columns in the MarinaSlip table for those slips with lengths of 40 feet. Display the data in the view.
1. List the number and name of all customers.
148, Als Appliance and Sport
282, Brookings Direct
408, The Everything Shop
462, Bargains Galore
608, Johnsons Department Store
687, Lees Sport and Appliance
725, Deerfields Four Sea
Premiere Products Exercises
1. List the names of all customers that have a credit limit less than $10,000.
-Als Appliance and Sport, Fergusons, The Everything Shop, Lees Sport and Appliance,
Deerfields Four Seasons, All Season
2. List the descriptions of
Week 5 Assignment User Form:
Complete database exercise by converting user form located
the evaluation procedures section of the syllabus into 1NF and 2NF. Remember to identify your
primary keys for 1NF and 2NF. Your 1NF and 2NF response should use the sh