Need helpAssignment 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.
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.