Description

Pts

Your Score

Add a new field called For Sale, after weekly rate field.  Data type should be Yes/No

15

All units owned by Alonso Bonita are for sale.

15

The Bedrooms, Bathrooms, and Sleeps fields always should contain data.

15

All units should have a minimum of one bedroom, one bathroom, and sleep two people.

30

No unit rents for less than $700 or more than $1,500

10

Management has received a new listing from Mark Graty.  It is unit 300.  The unit sleeps 10, has 3 bedrooms, has 2.5 bathrooms, and includes linens.  Weekly rate is $1,400 and the owner is interested in selling the unit.

40

Specify referential integrity between the two tables.  Do NOT cascade the update or the delete. Print the Relationship Report

20

Print the Condo table (or Condo Unit Table)

10

Print the Database Documenter for the Condo Table

10

TOTAL POSSIBLE POINTS:

165