The purpose of this assignment is to continue with our design modeling of the ITOT Case Study.
For the Manage Shopping Cart use case, you will create a test scenario, and two test cases. You will also create a persistent UML class diagram and SQL statements for ShoppingCart and ShoppingCartItem. Finally you will map your domain classes ShoppingCarat and ShoppingCartItem to Java statemens. Use you domain class diagram with attributes and operations.
You will create two test cases following the format described in your design specification. In testing, test cases are developed first and then tested later by a different team. You will not be able to exercise your test cases (so you won’t have Actual Results) but you can create the test case. You will also create SQL statements including constraints forShoppingCart and ShoppingCartItem. You will also create sample Java statements for ShoppingCart and ShoppingCartItem design classes.
In this assignment you complete the following sections in your Design Specification
Sections 6, 6.1, 6.2, 6.2.1, 6.3, 6.3.1 on test cases, Sections 7, 7.1, 7.1.2, 7.2, 7.2,1 on SQL, and Sections 8, 8.1, 8.2 on Java.
Instructions
1. Review the Quick Resources listed at the end of this assignment.
Test Scenario and Test Cases
2. Section 6, 6.1. You will identify and document one test scenario (name and description) based on the Manage Shopping Cart use case and complete Sections 6 and 6.1 in your design specification. A test scenario is not the same thing as a test case!
3. You will create and discuss two test cases for your scenario above for Manage Shopping Cart including test Case Name, Description, Prerequisites, Steps, Input, Expected Result, Actual Result, Status. The steps of the test case must be numbered!
Test Scenario:
Test Case ID
Test Case Description
Test Case Steps
Expected Results
Actual Results
Test Case Status
TC001
1.
2,
…
…
…
…
…
…
TC002
2,
…
…
…
…
…
…
3.1 You will create Test Case 1 based on your scenario for Manage Shopping Cart and add it in the table format in Section 6.2 of your design specification.
3.1.1 You will add a discussion of Test Case 1 to Section 6.2.1 in your design specification.
3.2 You will create Test Case 2 based on your scenario for Manage Shopping Cart and add it in the table format in Section 6.3 of your design specification.
3.2.1 You will add a discussion of Test Case 2 to Section 6.3.1 in your design specification.
4. Your entity (persistent) classes will most likely become tables in a relational database. In database design, we would follow normalization and functional decomposition guidelines to normalize our entities (classes) into valid relations. Then we would create SQL (Structured Query Language) statements to create the tables and add constraints. After that, we could populate our tables with data. We will assume our classes are normalized for this exercise.
Persistent Class Diagram
4.1 Create a persistent UML class diagram (without operations) of persistent data. You most likely already have this. Make certain that you include ShoppingCart and ShoppingCartItem. Designate primary and foreign keys. Add this to Section 7.1 in your design specification.
4.2 Include a discussion of your persistent class diagram in Section 7.1.2 in your design specification.
SQL Statements for ShoppingCart and ShoppingCartItem
5. You will use two classes (ShoppingCart and ShoppingCartItem) from your persistent UML class diagram and create the SQL statements to implement the tables and constraints. You will need to include primary key and foreign key constraints. Add the SQL Statements to Section 7.2 of your design specification.
5.1 Include a discussion of your SQL statements in Section 7.2.1 in your design specification
6. Complete Section 7 of your design specification.
Java for ShoppingCart and SoppingCartItem
7. Using Chapter 18 examples in your textbook or your resources below, create Java statements for ShoppingCart and ShoppingCartItem detailed design classes. Note that ShoppingCart and ShoppingCartItem have a composition type of part whole relationship. See the Engine and Piston example at
2. Guru99. (n.d.). How to Write Test Cases: Step by Step Guide with Examples. Retrieved from
http://www.guru99.com/test-case.html
3. Software Testing Help. (2016, December 24). Writing Test Cases from SRS Document (Download Live Project Sample Test Cases) – Software Testing QA Training Day 4. Retrieved from
1. Chapter 19 in your textbook provides a mapping from Java classes to SQL and sample SQL statements for implementing your tables. See Figure 19.5 p. 355 for a 1:N mapping to SQL.
UML to Java
1. See Chapter 18 in your Blaha textbook.
2. See Java Coding and UML Aggregation v/s Composition at
https://coderanch.com/t/443002/java/Java-Coding-UML-Aggregation-Composition
for an example of implementing composition in the Engine and Piston example.
3. Wampler, Bruce E. (2001). The Essence of Object Oriented Programming with Java and UML. Chapter 3. Objects in Java. Retrieved from
5. Gudmestad, Evan (2011 November 1). Java Tutorial – 9 – UML to Code conversion. Retrieved from
This is a video of how to convert a class diagram to Java.
What Will You Get?
We provide professional writing services to help you score straight A’s by submitting custom written assignments that mirror your guidelines.
Premium Quality
Get result-oriented writing and never worry about grades anymore. We follow the highest quality standards to make sure that you get perfect assignments.
Experienced Writers
Our writers have experience in dealing with papers of every educational level. You can surely rely on the expertise of our qualified professionals.
On-Time Delivery
Your deadline is our threshold for success and we take it very seriously. We make sure you receive your papers before your predefined time.
24/7 Customer Support
Someone from our customer support team is always here to respond to your questions. So, hit us up if you have got any ambiguity or concern.
Complete Confidentiality
Sit back and relax while we help you out with writing your papers. We have an ultimate policy for keeping your personal and order-related details a secret.
Authentic Sources
We assure you that your document will be thoroughly checked for plagiarism and grammatical errors as we use highly authentic and licit sources.
Moneyback Guarantee
Still reluctant about placing an order? Our 100% Moneyback Guarantee backs you up on rare occasions where you aren’t satisfied with the writing.
Order Tracking
You don’t have to wait for an update for hours; you can track the progress of your order any time you want. We share the status after each step.
From brainstorming your paper's outline to perfecting its grammar, we perform every step carefully to make your paper worthy of A grade.
Preferred Writer
Hire your preferred writer anytime. Simply specify if you want your preferred expert to write your paper and we’ll make that happen.
Grammar Check Report
Get an elaborate and authentic grammar check report with your work to have the grammar goodness sealed in your document.
One Page Summary
You can purchase this feature if you want our writers to sum up your paper in the form of a concise and well-articulated summary.
Plagiarism Report
You don’t have to worry about plagiarism anymore. Get a plagiarism report to certify the uniqueness of your work.
Free Features $66FREE
Most Qualified Writer
$10FREE
Plagiarism Scan Report
$10FREE
Unlimited Revisions
$08FREE
Paper Formatting
$05FREE
Cover Page
$05FREE
Referencing & Bibliography
$10FREE
Dedicated User Area
$08FREE
24/7 Order Tracking
$05FREE
Periodic Email Alerts
$05FREE
Our Services
Join us for the best experience while seeking writing assistance in your college life. A good grade is all you need to boost up your academic excellence and we are all about it.
On-time Delivery
24/7 Order Tracking
Access to Authentic Sources
Academic Writing
We create perfect papers according to the guidelines.
Professional Editing
We seamlessly edit out errors from your papers.
Thorough Proofreading
We thoroughly read your final draft to identify errors.
Thorough Proofreading
We thoroughly read your final draft to identify errors.
Delegate Your Challenging Writing Tasks to Experienced Professionals
Work with ultimate peace of mind because we ensure that your academic work is our responsibility and your grades are a top concern for us!
We Analyze Your Problem and Offer Customized Writing
We understand your guidelines first before delivering any writing service. You can discuss your writing needs and we will have them evaluated by our dedicated team.
Clear elicitation of your requirements.
Customized writing as per your needs.
We Mirror Your Guidelines to Deliver Quality Services
We write your papers in a standardized way. We complete your work in such a way that it turns out to be a perfect description of your guidelines.
Proactive analysis of your writing.
Active communication to understand requirements.
We Handle Your Writing Tasks to Ensure Excellent Grades
We promise you excellent grades and academic excellence that you always longed for. Our writers stay in touch with you via email.
Thorough research and analysis for every order.
Deliverance of reliable writing service to improve your grades.
