COIT20226: Software Design and Implementation (Term 3, 2014) Assessment details for ALL students

COIT20226: Software Design and Implementation (Term 3, 2014)

Assessment details for ALLstudents

__________________________________________________

Due date:      Phase 1: Friday 12 Dec, 2014 11:45 PM AEST;

   Phase 2: Monday 12 Jan, 2015 11:45 PM AEST;

Weighting:    50%

Length:      NA

__________________________________________________

Assessmentitem1— Practical and written Assignment1(Can be done in a group of two to three students)

You have been working in CQU soft company as a software application developer for the past three years.  Super duper video store gallery has approached you to assist them in managing their information needs to perform their business operations effectively for which you have agreed.  The system is expected to be developed using Java language and JDBC so that the data can be stored in a database. 

Phase 1:  Base model design

During the Phase 1, you have decided to perform the technical feasibility study by developing a successful prototype to meet the information needs of Super duper video store.

Super Duper Video store gallery has provided the following details regarding their business operations and information needs:

Store has stock of DVDs. The data held on a DVD is the catalogue number, DVD number, title, category, daily rental, cost, status, and the names of the main actors and the director. The catalogue number uniquely identifies each DVD.

However, in most cases, there are several copies of each DVD at the store, and the individual copies are identified using the DVD number. A DVD is given a category such as Action, Adult, Children, Drama, Horror, or Sci-Fi.

The status indicates whether a specific copy of a DVD is available for rent. Before borrowing a DVD from the company, a customer must first register as a member of the store.  The data held on a member is the first and last name, address, and the date that the member registered. Each member is given a member number, which is unique throughout all branches of the company. Once registered, a member is free to rent DVDs, up to a maximum of three at any one time.

The data held on each DVD rented is the rental number, the full name and number of the member, the DVD number, title, and daily rental, and the dates the DVD is rented out and returned. The DVD number is unique throughout the company.

The system should provide the following functions to manage the video rental operations:

a. Add new customer

b. Delete existing customer

c. Modify existing Customer information

d. Add video

e. Modify existing video

f. search DVD

g. Borrow DVD/VCD Item

The prototype should be developed using either Swing or NetBeans GUI builder which uses JDBC to perform the predefined operations on the database.  At this stage/phase, the functionality is considered as important rather than the look and feel of the interfaces.

You need to submit the following as the deliverable at the end of Phase 1 (Due at 11:45 pm, Friday week 6) to your course website.

Implementation (zipped NetBeans project folder).

Assessment Criteria:

Phase 1: Technical possibility /Implementation (Total 20 marks)

Phase 2: System Development

By the time you completed your Phase1, the super duper video store is pleased with your prototype and have asked you to include below mentioned features for their customers.  They are so impressed with your design and development so far, they have asked you to include well-designed interfaces in the application.  The only additional requirement from them are as follows:

1. Return DVD item- When a customer shall return a borrowed item(s) to the shop, the program shall compute rental fees of VCD and DVD items. The program shall display report for a customer.

Customer Name: Albert

Available Credit: $40

Vidoe Title       Number of days borrowed            Number of days overdue            Rental Fee

Skyfall                  5                                                        0                                                       10

superman            5                                                        2                                                       15

Total Rental: $25

Current Credit: $15

2. Reporting Function- the program shall display the list of VCD and DVD items rented out to the customers as well as for customer names and customer codes with the list of DVD and DVD rented by each of them as following format

Video Code                          Title                                     Borrowed by

V0001                               Shutter island                      John/C0005

V0010                               Skyfall                                   Albert/C0011

In order to provide the information which is related to the business needs of Super duper video store, you need to develop a GUI application using Netbeans IDE and make sure that the all data have to be accessed from JavaDB database using JDBC.  Your application is expected to have three layered architecture comprising of presentation, application and data access layers so that it is conforming to MVP design pattern.

You have agreed to provide the following deliverables and hence you need to submit the following at the end of Phase 2 to your course website.

Assessment Criteria:

Phase 2: Phase 2 System Development (Total 30 marks)