6) Study the data in the table below:

Table Name: COMPLAINT_NOTES

7 ) Study the data in the following table:

8) Study the data in the following table: \

9) In your table, you have a column QUARTER_NUMBER that identifies a calendar quarter of a year. The valid values for this column are 1, 2, 3, and 4. How can you insure in your database design that this column cannot store values other than 1, 2, 3, and 4?

10) Is it possible for a foreign key field of a table to have a NULL value?

QUESTION 6 Study the data in the table below Table Name: COMPLAINT NOTES NOTE ID COMPLAINT D NOTES TEXT NOTES DATE NOTE ENTERED BY Customer called to inform that he has not yet received the shipment. When 100 2/1/2014 JACOB I verified the shipment went to differe nt address 2 Customer called to inform that is 200 3/1/2014 PPETER product is defective. Customer has been given full refund 100 with a 50% coupon for the next 2/31/2013 JJA COB purchase For the above table, the column COMPLAINT ID can be the Primary Key TRUE or FALSE True False QUESTION 7 Study the data in the following table ORDER ID PRODUCT ID PRODUCT NAME ORDER QUANTITY 1 1 PENCILS 100 1 2 PENS 200 2 1 STAPLES 300 2 390 NOTEBOOKS The primary key for the above table is a concatenated key of ORDER ID and PRODUCT ID s this table in First Normal form? 0.5 points Save Answer 0.5 points Save