3025038110231 - Project 7 Implementation/Maintenance...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Project 7 – Implementation/Maintenance: DML/DCL IT 3233 – Database Design and Implementation Dr. Cheryl Aasheim Introduction: In the previous projects your team completed an initial conceptual and logical data model (ER diagram, data dictionary, relational schema and 3NF relations), created the database for myTunes and created SQL statements to query the new database system. With the design phase completed and the implementation phase started, your team is ready to design procedures to automate the queries written in the previous step. Write Stored Procedures: Put all TSQL commands written in this section in a Word document and label them according to the problem number to which each corresponds. Using the database provided in GA View , write the TSQL procedures to: 1. Change the password for customer specified by ID to “password”. Name: usp_assign7number1 CREATE PROCEDURE usp_assign7number1 @password char ( 20 ) AS SELECT Password FROM Customer WHERE Password = @password ; 2. Delete an errant purchase specified by customerID and songID. Name:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/13/2012 for the course IT 3233 taught by Professor Aashiem during the Fall '11 term at Georgia Southern University .

Page1 / 2

3025038110231 - Project 7 Implementation/Maintenance...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online