Question: USING MICROSOFT SQL SERVER MANAGEMENT STUDIO I've done numbers 3 and 4 but am having trouble with number 8 can someone please help me with
USING MICROSOFT SQL SERVER MANAGEMENT STUDIO
I've done numbers 3 and 4 but am having trouble with number 8 can someone please help me with the T_SQL query please
3) Create a new schema named CustomerService with owner of dbo.
4) Create a new filegroup in the AdventureWorks2014 DB containing one file name the filegroup AD_CustomerService and file whatever you wish, but use standard naming convention for the suffix.
8) Create a new CLUSTERED table named CustomerService.Contacts on the newly created Filegroup with the following columns and properties:
a. Column called ContactID that is the primary key and an ever-increasing unique integer (use Identity property and make this the primary clustered key)
b. Column called CustomerID that is integer and must exist in the Sales.Customer table (enforce with referential integrity with the CustomerID column in the Customer table and nulls are not allowed)
c. Column called RepID that is integer and must exist in the CustomerService.Reps table (enforce with referential integrity with the RepID column in the Reps table and nulls are not allowed)
d. Column called ContactDateTime, which is of type datetime and not null
e. Column called ContactMethod, that is a variable length character with a maximum length of 5 that only accepts the following values: Email, Phone, Chat, Other, (use a check constraint and defaults to Other) and nulls are not allowed
f. Column called ContactPhone, that is a variable length character with a maximum length of 14 with nulls allowed.
g. Column called ContactEmail, that is a variable length character with a maximum length of 50 with nulls allowed.
h. Column called ContactDetail, which is a variable length character with a maximum length of MAX and nulls not allowed.
i. Table should be compressed at the page level
j. ($$)DELIVERABLE COPY THE T_SQL TO CREATE THE ABOVE TABLE BELOW:
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
