CIS336 Week 6 Group Project Task 4

Task 4 - Verification of Transaction Processing (30 points)

Develop a query that will identify and mark inactive those customers that have bills overdue by more than 30 days (this can usually be done using a sub-query). Remember, you are only marking a customer as inactive, not actually deleting the customer record from the system.

To submit this task, create a heading called MODIFY STATEMENTS in your group project SQL script, and name the file TEAM_X_TASK4.TXT. This should be the same script that contains your DROP TABLE, CREATE TABLE, and INSERT statements. Once you have verified that your SQL statement or statements work, create a spooled output showing the results of your statements.

Deliverables for this task:

Any revisions of task 3 based on feedback from your instructor. Task 4 comprised of the complete script file (DROP, CREATE, INSERT, SELECT, and UPDATE statements) and the output file showing that it works. Team member responsibilities document outlining contributions by team member to this deliverable.

Photos

CIS336 Week 6 Group Project Task 4
$10.00 Tax included. Shipping not included.

User reviews

No reviews. Be the first to write one!

Delivery

All purchases are sent via email. Check your inbox and spam folder for an email from DevryGenius.com.

Promotions

Subscribe to our newsletter to receive special discounts and offers.

Contact us

DevryGenius.com
New York, NY 10011
support@devrygenius.com,

Newsletter

Sign up and never miss another deal.