Using Dafesty Database provided $($as MS$-$Access file$),$ convert it to your local SQL Server

database and try the following questions.

$1.$ Create a Table called MemberCategories with the following fields:

MemberCategory character size $2$

MemberCatDescription character size $200$

None of the fields above can be null. Set the MemberCategory as the Primary key.

$2.$ Add the following data into the MemberCategories Table:

MemberCategory MemberCatDescription

A Class A Members

B Class B Members

C Class C Members

$3.$ Create a Table called GoodCustomers with the following fields:

CustomerName nvarchar$(50)$

Address nvarchar$(65)$

PhoneNumber nvarchar$(9)$

MemberCategory nvarchar$(2)$

Only Customer Name and Phone Number is mandatory.

Since there could be two customers having the same name, make CustomerName and

PhoneNumber as a composite primary key.

The MemberCategory should have a referential integrity to the MemberCategories

Table so that only those categories that have been listed in MemberCategories Table

could be entered.

$4.$ Insert into GoodCustomer all records form Customer table with corresponding fields

except Address, which is to be left Null. Only Customers having Member Category $$A$$ or

$$B$$ are good customers hence the table should be inserted only those records from the

Customers table.

$5.$ Insert into GoodCustomers the following new customer.

CustomerName $=$ Tracy Tan

PhoneNumber $=736572$

MemberCategory $=\text{'}$B