Question: USING MICROSOFT SQL SERVER MANAGEMENT STUDIO I've done numbers 3 and 4 but I'm having trouble with the T_SQO query for number 5, could someone
USING MICROSOFT SQL SERVER MANAGEMENT STUDIO
I've done numbers 3 and 4 but I'm having trouble with the T_SQO query for number 5, could someone please help
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.
5) Create a new CLUSTERED table named CustomerService.Reps on the newly created Filegroup with the following columns and properties:
a. Column called RepID that is the primary key and an ever-increasing unique integer (use Identity property and make this the primary clustered key)
b. Column called BusinessEntityID that is integer and must exist in the Person.Person table, if populated (enforce with referential integrity with the BusinessEntityID column in the Person table DO NOT CASCADE DELETES or UPDATES and nulls are not allowed)
c. Column called SupervisorID that is integer and must exist in the Person.Person table, if populated (enforce with referential integrity with the BusinessEntityID column in the Person table DO NOT CASCADE DELETES or UPDATES and nulls are not allowed)
d. Table should be compressed at the page level
e. ($$)DELIVERABLE COPY THE T_SQL TO CREATE THE ABOVE TABLE INTO 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
