Unit 4 Assignment_ Modifying Database Schemas
docx
keyboard_arrow_up
School
Purdue Global University *
*We aren’t endorsed by this school
Course
234
Subject
Information Systems
Date
Dec 6, 2023
Type
docx
Pages
2
Uploaded by Savannah_98
Unit 4 Assignment: Modifying Database Schemas
Outcomes addressed in this activity:
Unit Outcomes:
●
Apply SQL Data Definition Language (DDL) commands to modify an existing
database schema.
Course Outcome:
IT234-2: Explore Data Definition Language (DDL) statements to define the database
structure or schema.
Purpose
Databases can evolve over time to meet evolving business needs. As a result, database
structures may be modified periodically due to new or changing requirements. This week,
you will learn how to use Data Definition Language (DDL) statements to modify a database
by adding tables and columns, removing a column, and adding foreign keys.
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.
Also review the university policy on plagiarism. If you have any questions, please contact
your professor.
The assignment is due by the final day of the Unit 4 week.
Directions for Submitting Your Assignment
Name your assignment document according to this convention:
IT234_<YourName>_Unit4.docx. (replace <YourName> with your full name). Submit your
completed assignment to the Unit 4 Assignment Dropbox by the final day of the Unit 4
week.
Review the Unit 4 Assignment Rubric before beginning this activity.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help