Change the structure of the Coast Jewelers database
a. Add the following product to the Product table. Product ID: 11; Name: Pearl Necklace; Description: "A 14K gold 18 inch cable chain holds a genuine 6mm round cultured pearl."; Supplier ID: 1; Category ID: 3; Product Number: PRLN652; Unit Price: 95; Reorder Level: 3; Lead Time: 7; Buyer ID: 1; Image: 11.
b. Add the following product to the Product table. Product ID: 12; Name: Swiss Army Watch; Description: "Officer's watch in rugged stainless steel."; Supplier ID: 6; Category ID: 1; Product Number: 24277; Unit Price: 175; Reorder Level: 3; Lead Time: 10; Buyer ID: 4; Image: 12.
c. Resize the column width of each field and the record's row height of the Product table so that they fit on one page when printed. (Don't worry if not all the information is shown or if the field name isn't fully visible when the table is printed.)
d. Print the Product table in landscape orientation.
e. Resize the column width of each field and the record's row height of the Supplier table so that they fit on one page when printed. (Don't worry if not all the information is shown or if the field name isn't fully visible when the table is printed.)
f. Print the Supplier table in landscape orientation.
g. Create a validation rule for the Reorder Level field of the Product table, making the field a required one and making sure the reorder level is greater than 0 but less than 100 units. Create your own feedback statement and insert it as the validation text.
h. Establish 7 as the default value for the Lead Time field of the Product table.
i. Establish a phone number input mask for the Buyer Phone field of the Buyers table.
j. Enforce referential integrity between the Product table and the Buyer and Category tables.
k. Print the Relationships window.
l. Print documentation on the properties of the Reorder Level field of the Product table and the Buyer Phone field of the Buyers table.
m. Save your file as Chl0-02_student_name (replacing student name with your name). Note: if you completed assignment 1 and/or 2 above this will replace the file you already saved.