1. Use the Management Studio to create a new database called Membership2 using t
ID: 3748843 • Letter: 1
Question
1. Use the Management Studio to create a new database called Membership2 using the default settings. (If the database already exists, use the Management Studio to delete it and then recreate it.)
2. Use the Management Studio to create the following tables and relationships in the Membership database. Define IndividualID and GroupID as IDENTITY columns. Allow Address and Phone to accept null values; none of the other columns should allow null values. Define the Dues column with a default of zero and a check constraint to allow only positive values. Define the DuesPaid column with a default Boolean value of False.
3. Use the Management Studio to index the GroupMembership table. Create a clustered index on the GroupID column, a nonclustered index on the IndividualID column, and a unique index and constraint on both columns.
Explanation / Answer
Ans:
1.Initially, Open Management studio express, a connection window through SQL server will be opened.
2.Enter Server name and Authentication of windows and click connect.
3.After connecting, click database folder, set DB name Membership2 and owner default, click OK.
4.Insert tables, views, diagrams, etc.
5.Now we will add a table Web Table.
6.Open a new table.
7.New table data structure will open 3 parts:
8.Insert fields in columns and set properties and data type for each column.
9. You can set Primary key also.
10.To finish, just click on "X" in right side of table structure window and save it.
11.Table will appear in the list of Tables folder.
As per chegg policies,I have answered only part 1 from the given question.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.