ITSS 4330 – System Analysis and Design: Fall 2016 Assignment 7: Database Design and Testing (30 points) Due on December 1, 2016 by 6:00 pm 1.Let's say that you are interviewing for a job as a systems analyst or database administrator and the interviewer asks you to discuss your thoughts on when to use perfectly normalized tables versus denormalized tables in your database design. What would you say and how would you respond? Prepare a response (1 –2 pages) that demonstrates your understanding of both terms. I am not looking for a text book answer. Be creative in your response to show the interviewer that you understand the concepts and are not just providing a textbook answer. A good response must also include an example for each normal form. (10 points)2.Consider the Use Case Diagram, Use Case Description, and Sequence diagram you created for the AVS scenario. Write a test case to test the “check -in video” functionality in the system. This is the function that gets called when an employee “checks in” a returned video. Typically the employee will scan the video code and the system will update the video rental information and the customer account information. Be sure to account for all possible cases that could occur (video returned is on time, video returned is late, customer account is invalid, etc). (20 points) A sample test case has been provided on the following page. Use this template to answer this
You've reached the end of your free preview.
Want to read both pages?
- Spring '16
- Login, Test Case