Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SQL statements needed - 1. Use the Management Studio to create a new database called Membership2 using the default settings. (If the database already exists,

SQL statements needed

image text in transcribed

- 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 IndividuallD 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 Dues Paid column with a default Boolean value of False. Individuals Group Membership Groups GroupID, int GroupID, int GroupName, varchar IndividuallD, int IndividuallD, int FirstName, varchar LastName, varchar Address, varchar Phone, varchar DuesPaid, bit Dues, money 3. Use the Management Studio to index the GroupMembership table. Create a clustered index on the GroupID column, a nonclustered index on the IndividuallD column, and a unique index and constraint on both columns

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intranet And Web Databases For Dummies

Authors: Paul Litwin

1st Edition

0764502212, 9780764502217

Students also viewed these Databases questions

Question

What do Dimensions represent in OLAP Cubes?

Answered: 1 week ago