Video Rental Store Database Information Technology Essay

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

Hire a custom writer who has experience.
It's time for you to submit amazing papers!


order now

Background to the Undertaking

JJ Video Library is a shop which rents out pictures to its members. It was established in 2006. It is located in Kimara, Kinondoni territory of Dar Es Salaam. The shop ‘s success is due to the good service it provides to its members and the broad and varied stock of pictures available for rent. The shop is holding troubles in pull offing the increasing sum of informations used and generated. It ca n’t get by with its ain success. It now offers a larger choice of pictures to a turning figure of members, which means that the degree of service it provides is falling. A system that will rush up the manner they work, i.e. something to automatize a batch of the daily undertakings that seem to take everlastingly to finish is needed.

The purpose of this undertaking is to develop a database application that will assist work out the increasing jobs of informations direction.

Aims

The chief aims for the system are as follows:

3.1 ) Technical

To bring forth an overall demands specification for the system.

To plan and develop the system by accommodating the waterfall theoretical account.

3.2 ) Personal

To derive programming experience in PHP and MySQL.

To bring forth a system that will run into the demand of the shop.

To better my apprehension in forming and transporting out a package development undertaking.

3.3 ) Academic

To run into the academic demands of the B.Sc. ICTM concluding twelvemonth Undertaking.

Justification

4.1 ) Reasons for taking this undertaking

The primary ground for taking this peculiar undertaking is to work out the concern demand of JJ Video Library, which is detailed in subdivision 5.1. Without a real-time database application, it is highly hard to pull off the turning size of the informations being stored.

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

Check in and out

Find client & A ; show inside informations.

Show client ‘s current leases.

Return a picture on clip.

Return a picture late & amp ; pay mulct.

Return late picture without paying.

Paying outstanding mulcts.

Locate picture inside informations to look into out.

Check a picture out.

Search

Search for a film.

List genres.

Add rubric

Add the new rubric to the database.

Find the ID of the movie we merely added.

Create transcripts of the movie.

Find existing creative person.

Connect the creative person with the movie.

Get genres.

Sign up

Add new client inside informations.

Get ID of new client.

List all debitors

Show list of clients with unpaid mulcts.

A secondary ground for taking this undertaking is to broaden my cognition in both the countries of PHP scripting and database application development. I am greatly interested in both countries and see this undertaking as a manner for me to look into how both these countries can be combined to make robust database applications.

4.2 ) How this undertaking draws from other class topics

During this undertaking I will utilize many accomplishments I have acquired during my coursework, the tabular array below sum-ups this:

Code

Course Subject

Techniques/Knowledge to be used

ICT 106

Introduction to Information Technology.

Document and presentation readying techniques.

ICT 110

Fundamentalss of Computer Networks.

Appliation deployment techniques and protocols.

ICT 209

Global Networks.

ICT 116

Management Information Systems.

Outstanding constituents of Information Systems and how they couple with functional countries of a concern.

ICT 211

Information Technology and Business Computing.

ICT 208

Database Concepts and Design.

Relational database design techniques.

ICT 214

Computer Programming.

Programing concepts.

COM 200

Business Communication Skills.

Report composing techniques.

PUB 220

Research Methods.

Research techniques.

ICT 313

Database Management and Administration.

This topic has non been covered yet, so this undertaking will function as an early probe of topic.

ICT 314

Information Technology and Society.

This topic has non been covered yet, so this undertaking will function as an early probe of the topic.

ICT 315

Software Engineering.

This topic has non been covered yet, so this undertaking will function as an early probe of the topic.

ICT 316

Systems Analysis and Design.

This topic has non been covered yet, so this undertaking will function as an early probe of the topic.

ICT 317

IT Project Management.

This topic has non been covered yet, so this undertaking will function as an early probe of the topic.

4.3 ) What are the expect additions from making this undertaking

The development work will give me the chance to derive ready to hand pattern in a programming linguistic communication. The undertaking will give me a opportunity to set to utilize many of the techniques and constructs which I have learnt in my coursework. Database development methods and the application of formal systems development theoretical account to advert a few.

Furthermore, upon the completion of the undertaking, JJ Video Library shop will hold a powerful tool which they can utilize to hive away and recover information more expeditiously.

The development work will function as the agencies for run intoing the demands of the B.Sc. ICTM undertaking constituent. The undertaking will enable me to better my package development ability by developing a well sized package application, therefore leting me to derive valuable experience in:

planning and forming undertaking work

problem-solving

systems analysis

systems design

scheduling and proving

4.4 ) Video rental industry background survey

The film lease industry has changed drastically over the old ages. Previously, film fans could merely lease films at their local film leasing shop, but the birth of new engineerings and film distribution methods has changed the manner the film rental industry operates. Today, there are three major ways for film fans to obtain their films: the traditional film lease shop, on-line film lease services, or no-return film lease services.

While the film rental industry is quickly altering, film lease shops are still really financially successful. Movie rental shops make their money through a figure of different methods including rank fees, rental fees, late fees, and film purchases. Because on-line film lease services are both inexpensive and convenient, they are rapidly going a strong rival within the film rental industry.

Both options are ideal for film rental partisans who enjoy leasing films on a regular basis but do n’t desire to be bothered with returning the films.

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

Scope & A ; System Requirements

5.1 ) Scope

The range of the system will be limited to the nucleus concern maps ( Connolly & A ; Begg, 2004: 132 ) of JJ Video Library, viz. :

To keep ( enter, update, and delete ) information on pictures

To keep ( enter, update, and delete ) information on members

To keep ( enter, update, and delete ) information on picture leases

To keep ( enter, update, and delete ) information on staff

To execute hunts on pictures.

To execute hunts on picture leases.

To execute hunts on members.

To describe on pictures.

To describe on members.

To describe on video leases.

5.2 ) System Requirements

Use of the database application will be restricted to two groups of users, viz. the supervisor who will hold unrestricted entree to the system and the other staff members who will hold limited entree to the system.

To efficaciously run into the demands of JJ Video Library the functionalities listed below demand to be delivered. Due to the clip constraints the undertaking will merely present the contents of this specification.

The system will supply the undermentioned functionality:

Log in

Connect to MySQL database: username & A ; watchword.

Locate user in employees table.

Log out

Terminate MySQL database connexion.

Check in and out

Find client & A ; show inside informations.

Show client ‘s current leases.

Return a picture on clip.

Return a picture late & amp ; pay mulct.

Return late picture without paying.

Paying outstanding mulcts.

Locate picture inside informations to look into out.

Check a picture out.

Search

Search for a film.

List genres.

Add rubric

Add the new rubric to the database.

Find the ID of the movie we merely added.

Create transcripts of the movie.

Find existing creative person.

Connect the creative person with the movie.

Get genres.

Sign up

Add new client inside informations.

Get ID of new client.

Make a user history

Add a new user.

Grant privileges to user.

Remove a user history

Get the username of the user.

Remove the user from database.

Revoke user ‘s privileges.

Get user ID.

List all debitors

Show list of clients with unpaid mulcts.

Deliverables

6.1 ) Development Approach

For this undertaking I plan on utilizing the Waterfall systems development life rhythm theoretical account and an object oriented development attack utilizing UML schematization tools to pattern the system ‘s architecture.

The waterfall theoretical account ( Pressman, 2005: 79 ) will let for a systematic, consecutive attack to package development that will get down with customer-specification of demands and will come on through planning, mold, building, and deployment, climaxing in ongoing support of the completed package. The figure below shows the proposed theoretical account.

Waterfall Systems Development Model

( Pressman, 2005: 79 )

Another ground for taking the waterfall theoretical account ( Pressman, 2005: 79 ) was because the demands for the undertaking are fixed and work is to continue to completion in a additive mode. And if there is any alteration in the demands the theoretical account will supply for feedback cringles ( loop ) .

6.2 ) Artifacts

The undermentioned parts of the undertaking life rhythm are portion of this papers. These include undertaking induction, undertaking feasibleness and demands analysis. A high-ranking design papers will be the following deliverable. After that for each phase the undermentioned deliverables will be produced at the listed stages:

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

Construct

Working Application

Trial

Test Plan & A ; Test Cases for:

Acceptance Testing – To acquire a little sample of user sentiments.

Performance Testing – To prove the velocity of the system under burden, in a unrecorded environment.

Execution

User Guide

Extra deliverables required for the B.Sc. ICTM undertaking constituent that will be produced include:

Final Project Report.

Formal Oral Presentation

Timing

7.1 ) Major Milestones

Appendix A gives a elaborate dislocation of the hours I have at my disposal to work on the undertaking. I am positive that I will be able to present within the mark day of the months.

Idaho

Milestone

Hourss

Start Date

Target Date

Pelvic inflammatory disease

Undertaking 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 construction

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

Entire

535

18 January 2011

June 2011

Extra Information

8.1 ) Undertaking Administration

The undertaking will be conducted wholly by myself.

The undertaking supervisor will be Mr. Almasi Maguya.

8.2 ) Resources:

The undermentioned tools will be put to utilize during this undertaking:

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

Artworks Editing Tool.

OpenOffice.org 3.2.1

Office Suite.