Video Rental Store Database Information Technology Essay

2341 words (9 pages) Essay

1st Jan 1970 Information Technology Reference this

Tags:

Disclaimer: This work has been submitted by a university student. This is not an example of the work produced by our Essay Writing Service. You can view samples of our professional work here.

Any opinions, findings, conclusions or recommendations expressed in this material are those of the authors and do not necessarily reflect the views of UKEssays.com.

Development of a Video Rental Store database application for JJ Video Library to facilitate efficient data storage and retrieval.

Background to the Project

JJ Video Library is a store which rents out videos to its members. It was established in 2006. It is located in Kimara, Kinondoni district of Dar es Salaam. The store’s success is due to the good service it provides to its members and the wide and varied stock of videos available for rent. The store is having difficulties in managing the increasing amount of data used and generated. It can’t cope with its own success. It now offers a larger selection of videos to a growing number of members, which means that the level of service it provides is falling. A system that will speed up the way they work, i.e. something to automate a lot of the day-to-day tasks that seem to take forever to complete is needed.

The aim of this project is to develop a database application that will help solve the increasing problems of data management.

Objectives

The main objectives for the system are as follows:

3.1) Technical

To produce an overall requirements specification for the system.

To design and develop the system by adapting the waterfall model.

3.2) Personal

To gain programming experience in PHP and MySQL.

To produce a system that will meet the need of the store.

To improve my understanding in organizing and carrying out a software development project.

3.3) Academic

To meet the academic requirements of the B.Sc. ICTM final year Project.

Justification

4.1) Reasons for choosing this project

The primary reason for choosing this particular project is to solve the business need of JJ Video Library, which is detailed in section 5.1. Without a real-time database application, it is extremely difficult to manage the growing size of the data being stored.

In the new system the following manual functions will be automated:

Check in and out

Find customer & show details.

Show customer’s current rentals.

Return a video on time.

Return a video late & pay fine.

Return late video without paying.

Paying outstanding fines.

Locate video details to check out.

Check a video out.

Search

Search for a movie.

List genres.

Add title

Add the new title to the database.

Find the ID of the film we just added.

Create copies of the film.

Find existing artist.

Connect the artist with the film.

Get genres.

Sign up

Add new customer details.

Get ID of new customer.

List all debtors

Show list of customers with unpaid fines.

A secondary reason for choosing this project is to broaden my knowledge in both the areas of PHP scripting and database application development. I am greatly interested in both areas and see this project as a way for me to investigate how both these areas can be combined to create robust database applications.

4.2) How this project draws from other course subjects

During this project I will use many skills I have acquired during my coursework, the table below summaries this:

Code

Course Subject

Techniques/Knowledge to be used

ICT 106

Introduction to Information Technology.

Document and presentation preparation techniques.

ICT 110

Fundamentals of Computer Networks.

Appliation deployment techniques and protocols.

ICT 209

Global Networks.

ICT 116

Management Information Systems.

Salient components of Information Systems and how they couple with functional areas of a business.

ICT 211

Information Technology and Business Computing.

ICT 208

Database Concepts and Design.

Relational database design techniques.

ICT 214

Computer Programming.

Programming constructs.

COM 200

Business Communication Skills.

Report writing techniques.

PUB 220

Research Methods.

Research techniques.

ICT 313

Database Management and Administration.

This subject has not been covered yet, so this project will serve as an early investigation of subject.

ICT 314

Information Technology and Society.

This subject has not been covered yet, so this project will serve as an early investigation of the subject.

ICT 315

Software Engineering.

This subject has not been covered yet, so this project will serve as an early investigation of the subject.

ICT 316

Systems Analysis and Design.

This subject has not been covered yet, so this project will serve as an early investigation of the subject.

ICT 317

IT Project Management.

This subject has not been covered yet, so this project will serve as an early investigation of the subject.

4.3) What are the expect gains from doing this project

The development work will give me the opportunity to gain handy practice in a programming language. The project will give me a chance to put to use many of the techniques and concepts which I have learnt in my coursework. Database development methods and the application of formal systems development model to mention a few.

Furthermore, upon the completion of the project, JJ Video Library store will have a powerful tool which they can use to store and retrieve information more efficiently.

The development work will serve as the means for meeting the requirements of the B.Sc. ICTM project component. The project will enable me to improve my software development ability by developing a considerably sized software application, thus allowing me to gain valuable experience in:

planning and organizing project work

problem-solving

systems analysis

systems design

programming and testing

4.4) Video rental industry background study

The movie rental industry has changed drastically over the years. Previously, movie fans could only rent movies at their local movie renting store, but the birth of new technologies and movie distribution methods has changed the way the movie rental industry operates. Today, there are three major ways for movie buffs to obtain their movies: the traditional movie rental store, online movie rental services, or no-return movie rental services.

While the movie rental industry is rapidly changing, movie rental stores are still very financially successful. Movie rental stores make their money through a number of different methods including membership fees, rental fees, late fees, and movie purchases. Because online movie rental services are both cheap and convenient, they are quickly becoming a strong competitor within the movie rental industry.

Both options are ideal for movie rental enthusiasts who enjoy renting movies regularly but don’t want to be bothered with returning the movies.

One of the leaders in no-return movie rentals, Flexplay, offers superior quality and convenience over other no-return movie rental companies.

Scope & System Requirements

5.1) Scope

The scope of the system will be limited to the core business functions (Connolly & Begg, 2004: 132) of JJ Video Library, namely:

To maintain (enter, update, and delete) data on videos

To maintain (enter, update, and delete) data on members

To maintain (enter, update, and delete) data on video rentals

To maintain (enter, update, and delete) data on staff

To perform searches on videos.

To perform searches on video rentals.

To perform searches on members.

To report on videos.

To report on members.

To report on video rentals.

5.2) System Requirements

Usage of the database application will be restricted to two groups of users, namely the supervisor who will have unrestricted access to the system and the other staff members who will have limited access to the system.

To effectively meet the needs of JJ Video Library the functionalities listed below need to be delivered. Due to the time constraints the project will only deliver the contents of this specification.

The system will provide the following functionality:

Log in

Connect to MySQL database: username & password.

Locate user in employees table.

Log out

Terminate MySQL database connection.

Check in and out

Find customer & show details.

Show customer’s current rentals.

Return a video on time.

Return a video late & pay fine.

Return late video without paying.

Paying outstanding fines.

Locate video details to check out.

Check a video out.

Search

Search for a movie.

List genres.

Add title

Add the new title to the database.

Find the ID of the film we just added.

Create copies of the film.

Find existing artist.

Connect the artist with the film.

Get genres.

Sign up

Add new customer details.

Get ID of new customer.

Create a user account

Add a new user.

Grant privileges to user.

Remove a user account

Get the username of the user.

Remove the user from database.

Revoke user’s privileges.

Get user ID.

List all debtors

Show list of customers with unpaid fines.

Deliverables

6.1) Development Approach

For this project I plan on using the Waterfall systems development life cycle model and an object oriented development approach using UML diagramming tools to model the system’s architecture.

The waterfall model (Pressman, 2005: 79) will allow for a systematic, sequential approach to software development that will begin with customer-specification of requirements and will progress through planning, modeling, construction, and deployment, culminating in on-going support of the completed software. The figure below shows the proposed model.

Waterfall Systems Development Model

(Pressman, 2005: 79)

Another reason for choosing the waterfall model (Pressman, 2005: 79) was because the requirements for the project are fixed and work is to proceed to completion in a linear manner. And if there is any change in the requirements the model will provide for feedback loops (iteration).

6.2) Artefacts

The following parts of the project life cycle are part of this document. These include project initiation, project feasibility and requirements analysis. A high-level design document will be the next deliverable. After that for each stage the following deliverables will be produced at the listed phases:

Detailed Design

Requirements Specification

User Interface Design

Database Design

Entity Relationship Diagram

Data Dictionary

Functional Design

Use Case Diagram

Class Diagram

Sequence Diagram

Deployment Diagram

Build

Working Application

Test

Test Plan & Test Cases for:

Acceptance Testing – To get a small sample of user opinions.

Performance Testing – To test the speed of the system under load, in a live environment.

Implementation

User Guide

Additional deliverables required for the B.Sc. ICTM project component that will be produced include:

Final Project Report.

Formal Oral Presentation

Timing

7.1) Major Milestones

Appendix A gives a detailed breakdown of the hours I have at my disposal to work on the project. I am convinced that I will be able to deliver within the target dates.

ID

Milestone

Hours

Start Date

Target Date

PID

Project Plan/Requirements Analysis

75

18 January 2011

31 January 2011

HLD

High-level Design Document

75

01 February 2011

14 February 2011

Development Phases

DP1

Core System/Database structure

35

15 February 2011

21 February 2011

DP2

Login_logout

17

22 February 2011

24 February 2011

DP3

Check_in_out

18

25 February 2011

28 February 2011

DP4

Search

35

01 March 2011

07 March 2011

DP5

Add_title

35

08 March 2011

14 March 2011

DP6

Sign_up

35

15 March 2011

21 March 2011

DP7

Create_user_account

35

22 March 2011

28 March 2011

DP8

Remove_user_account

35

29 March 2011

04 April 2011

DP9

List_debtors

35

05 April 2011

11 April 2011

FPR

Final Project Report

105

12 April 2011

02 May 2011

Total

535

18 January 2011

June 2011

Additional Information

8.1) Project Organisation

The project will be conducted entirely by myself.

The project supervisor will be Mr. Almasi Maguya.

8.2) Resources:

The following tools will be put to use during this project:

Tool

Description

Apache 2.2.17

Web Server.

PHP 5.3.3

Scripting Language.

Star UML 5.0

UML Diagramming Tool.

Komodo Edit 6.0.3

Text Editor.

Microsoft Project 2003

Project Management Software.

MySQL Workbench 5.2.31

Database Design Tool.

MySQL 5.5.8

Relational Database Management System.

Adobe Photoshop CS4 Extended

Graphics Editing Tool.

OpenOffice.org 3.2.1

Office Suite.

Cite This Work

To export a reference to this article please select a referencing stye below:

Reference Copied to Clipboard.
Reference Copied to Clipboard.
Reference Copied to Clipboard.
Reference Copied to Clipboard.
Reference Copied to Clipboard.
Reference Copied to Clipboard.
Reference Copied to Clipboard.

Related Services

View all

DMCA / Removal Request

If you are the original writer of this essay and no longer wish to have your work published on the UKDiss.com website then please: