Modifying Database Schemas

Need help

Assignment Instructions 

Before completing the Assignment, please watch the Unit 4 videos covering facets associated with database modifications. Navigate to the Academic Tools area of this course and select Library then Required Readings to access your texts and videos.

Use the Query Window of the Microsoft SQL Management Studio to run SQL queries to modify an existing database.

Using SQL DDL statements:

· Add a new table called Producer that contains the following columns:

· ProducerId – Integer, Identity(1,1), Primary Key

· Producer_FirstName – varchar(15)

· Producer_LastName – varchar(35)

· Add two new columns to the Producer table using ALTER TABLE commands (your choice as to column name and data type).

· Remove one of the columns you added via ALTER TABLE command.

· Add a foreign key referencing the Producer table using an ALTER TABLE command (Hint: This is not done to the Producer table).

· Make up four more changes and apply them (e.g., change maximum character length) using ALTER TABLE commands.

You can leverage the 

revised database design diagram

 as a resource for this assignment. Download and use this diagram for your analysis.

Create a screenshot of your Microsoft SQL Management Studio queries showing the changes you made. Also, create a screenshot of the new database physical model after the changes were made. Embed all screenshots into a Word document.

Explain what is being shown in each of your screenshots.

Assignment Requirements

Microsoft SQL Server Express and SQL Server Management Studio (SSMS) MUST be installed to complete this Assignment.

Compose your Assignment in a Word document and be sure to identify yourself, your class, and unit Assignment at the top of your paper. Embed the screenshots of your SQL statements and confirmatory output (e.g., table structure definitions) into the Word document.