Reference no: EM132917121

Do a new database called MyDB_[First and Last Name]. Example: MyDB_EricWilliamson Add the following script after the create database command: GO USE [Your database name] (The GO statement tells SQL to run any code that follows it as a separate statement. This will allow me to run your entire homework script in one pass.). Then:

Perform the syntax commands to show an Address table in the database.

Then add a unique constraint to the address table:

Add the following columns to the table:
AddresId int, AddressType varchar(10), AddressLine1
varchar(50), City varchar(30), State varchar(2), UserId int, CreateDate datetime.
Make the AddressId column the primary key for the table and also make it an identity column
with a starting point of 1 and an increment of 1.
The CreateDate column should default to the date and time a record is added to the table