DOC

Best Video Rental Libraries Database Management Software System

By Gladys Collins,2014-06-22 12:28
7 views 0
Best Video Rental Libraries Database Management Software System

    CAAF

    Best Video Rental Libraries Database Management Software System

    Semester Project COSC 578

    Chi Yeung, Akwasi Owusu, Andrew Chrismer, Francois Cressin

    12/1/2007

INDEX:

    EXECUTIVE SUMMARY……………………………..………………………..…3 INTRODUCTION…………………………………………………………….…..……4 BUSINESS PROFILE……………………………………………………………….....5 PROBLEM STATEMENT………………………………………………….…..…...5-6 BUSINESS PROCESS FLOW………………………………………………....……6 REQUIREMENTS ANALYSIS………………………………………………..………7 USER REQUIREMENTS…………………………………………………....8-9-10 ERD………………………………………………………………………………..….…11 SCHEMAS AFTER NORMALIZATION……………………………………..……..12

    -14 SYSTEM DESCRIPTION AND FUNCTIONALITIES…………………………13FEASABILITY ASSESSMENT……………………………………………………14-15 ECONOMICAL ANALYSIS………………………………………………………15-16 FINANCIAL SUMMARY………………………………………………..16-17-18-19 BREAK EVEN ANALYSIS…………………………………….……………..…… …19 PAYBACK ANALYSIS……………………………………………………………..…20 TECHNICAL ANALYSIS……………………………………………………….…20-21 OPERATIONAL ANALYSIS………………………………………………….…..21-22 GANTT CHART……………………………………………………………………23-24 MEETING AND WORK LOG…………………………………………………..……25 MANUAL AND WALK THROUGH……………………………………..……….26-34

    2

1 EXECUTIVE SUMMARY

As part of the Best Video rental libraries inc’s 2007 review on developmental strategies,

    C.A.A.F software development group was assigned to conduct a feasibility studies on how to expand and expedite the current transaction processes of Best Video Rental libraries inc. The studies revealed that, the development of a relational database of accessible format is important if Best Video Rental libraries inc. is to remain or have a competitive urge over other businesses in the video rental industry. Database Management Systems are increasingly used for libraries and catalogues, but there are some specific issues relating to the accessible formats that these systems do no generally address. Any system considered for hosting the software will require customization to hold the additional information, to provide accessible user interfaces. The initial work is just a feasibility study; hence, further funding will be required to develop the operational requirements document as well as the migration of the data from the existing system to the new one, should Best Video Rental libraries inc. continue to use our services.

    Notes:

    1. This report is the results of a feasibility study conducted by C.A.A.F software

    development group, and does not necessarily contain much detailed and technical

    information.

    2. This document is an internal document developed for Best Video Rental Libraries

    Inc ? and is therefore considered confidential.

    The remaining sections of this document provide a general description, including user requirements of this project. General description of the project is discussed in section 2 of this document. Section 7 gives the functional requirements, data requirements and constraints and assumptions made. Section 8 gives the functional requirements of the product. Specific requirements should be such that one may objectively determine whether they have been fulfilled or not. The final part shows the system working in the form of a walk through.

    3

    1 INTRODUCTION

    This document in a nutshell provides an indication of potential future development of Video Rental Store Database Management Software System (DBMS) as well as the software architecture required to operate the system. This software requirement specification (SRS) describes the function and performance requirements allocated to the Database Application.

    The scope of this document is to identify the processes that comprise the architecture and provide narratives for their functional content. The functional narratives are designed to provide all-inclusive specifications for an entire function rather than trying to derive a function from a set of individual requirements. In addition inter-process messaging and derived dependencies shall be identified. This level of specification is intended to provide enough information to properly review process system level functional content and inter-process messaging and dependencies in preparation for the subsequent effort to derive detail process requirements and design. Since this software will by default become the system functional specification, it is important to ensure that this level is as clearly defined as possible.

    The Video Store Database Management Software System shall be designed and developed to provide a clear and easy to use Database Management System for our customer, Best Video Rental Libraries inc. ?. The Database Management Software System shall facilitate and optimize employee management, customer interaction, and a virtual video warehouse.

    4

    2 BUSINESS PROFILE

    Best Video Rent libraries inc. operates in the highly competitive video rental industry which includes; the sale and rental of movies on either DVD or VHS. Notable competitors in the video rental industry include:

    ; Video store operators, such as Blockbuster and Movie Gallery.

    ; Online retailers, such as Netflix, Blockbuster and Amazon.com;

    ; Other retailer, including mass merchant retailer such as Wal-Mart, Best Buy and

    Targets.

    ; Recent addition to the video rental industry is the “automated kiosk” located at

    some fast food joints, such as McDonalds and super markets such as Shoppers. The industry’s current practice is sequenced as follows. After the initial release of a

    movie, movie makers generally make their movies available to home video retailers for either rental or sale after the movie has made its “run” through the movie theater. The

    rental or sale price is determined by how current of a release a movie is. To promote a movie primarily for rental after its initial release, movie makers’ price their movies

    extremely high to discourage its sales but promote its rental. As rental demand subsides, the prices of the movies are reduced to make it affordable to consumers.

    3 PROBLEM STATEMENT

    Rigorous competition in the video rental industry due to price reduction from retailer, in particular from mass merchant retailers, have affected consumer rental and purchasing behavior. The trend of the market indicate that, other than prices, most consumers base their decision to either rent or buy on how convenient, easy and simple the renting process is, as compared to purchasing. Best video rental libraries inc. low number of clientele has been attributed to slow and cumbersome process one has to go through to rent a movie. Our studies indicate that, the company’s inability to generate efficient

    database queries and capture critical information in a central location is giving competitors the advantage, hence the low number of customers and loss in profit.

    5

    The complex nature of the existing rental process can be attributed to a number of factors: a. Most of the operations were done manually (a new customer will have to

    manually fill out an application form before a clerk enters the information

    into the system) this results in a lot of mistakes being made. b. The manual movement and distribution of paper-based transactions

    resulted in substantial delays within the process and significantly limited

    the company’s ability to prioritize and improve performance

    c. Processes requiring precise coordination between groups in different

    departments tend out to be very challenging.

    d. There is no centralized repository, hence change in data by one department

    may not reflect in another department.

    e. Customer transactions (i.e. requests for statements, incorrect information,

    address changes, etc.) were frequently lost due to the mobility of

    information from one department to the other.

    f. Tracking and evaluating the rental process by management to determine

    areas that need improvement is almost impossible.

    4 BUSINESS PROCESS FLOW

     The current flow process to enroll a new customer is as follows: a. A new customer enters the store and is received by a clerk. The customer

    is then given a form to provide all the necessary information b. The clerk the files the form to be processed at the end of the business day c. The customer is then notified later via mail or phone on the status of

    his/her application (accepted or denied).

    d. If accepted, the customer is then provide with a card to use for subsequent

    rentals

    e. To view customer records, the manager will have to manually query the

    database.

    6 REQUIREMENTS ANALYSIS

    6

-User-Friendliness:

    -The system should provide confirmation messages for the user when the database

    is successfully updated.

    -When the database cannot be successfully updated, an error message containing a

    brief explanation of why the update was unsuccessful should be sent to the user. -Ease of Use:

    -Employees and managers with limited technical knowledge should be able to

    view and update the data.

    -Learning to use the system should be easy for all users.

    -Any person with basic experience with computers should be able to learn to use

    the system in a reasonable amount of time and with little help or tutelage.

    -A user manual and/or help directory should be supplied for users. Slightly

    different versions will be available for each type of user.

    -Adaptability

    -The database should not have to undergo serious changes when new technology

    emerges (e.g., new copy formats)

    -The code should be well-documented so that any problems or features needing

    any modification can be easily recognized.

    -Security

     -different types of users shall have different access privileges

    -the privacy of certain information needs to be protected and ensured

    -There should be protection from viruses, spyware, etc.

    -There should be validation messages when data is updated.

    -Attempts to enter invalid data should not be allowed, and should be accompanied

    by error messages.

    -System requirements:

     -Windows 2000 or higher

     -Internet Explorer 5.0 or higher

    7.1 USER REQUIREMENTS

    7

Notation:

    -The terms “copy” and “movie copy” will hereafter denote an individual copy, such as a DVD or video tape that a customer can rent

    -The word “movie” will mean the actual content of a copy, whether it is a film, live event, etc.

CUSTOMER:

    ; Each customer will have a first name, middle initial, last name, and title (Mr.,

    Mrs., Dr., etc.).

    ; Each customer has unique ID number provided by the store (8 digits total, first

    2 digits will be store id).

    ; Each customer will have an address comprising of house number, street, city,

    state, and zip code.

    ; Each customer’s date of registration will be stored

    ; Each customer may has a phone number

    ; Each customer has a date of birth

    ; Each customer must have at least one credit card that he/she uses to pay

CREDIT_CARD

    ; Each credit card is uniquely identified by the credit card number

    ; The credit card’s number, secret number, expiration date, and type will be

    stored

    ; Each credit card may belong to exactly one customer

BRANCH

    ; Each branch is identified by a unique ID number

    ; Each branch has an address comprising of street number, city, state, and zip

    code

    ; Each branch has a phone number

    ; Each branch has a Fax number

    8

    ; A branch may or may not have any movie copy, and may have any number of

    movie copies.

    ; A branch has at least one employee, and can have any number of employees

    EMPLOYEE

    ; Each employee has a unique Social Security Number

    ; Each employee can work in only one branch at any given time ; Each employee has a name comprising of first name, last name, title (Mr.,

    Mrs., Dr., etc.), and, if applicable, middle initial.

    ; Each employee started has a start date

    ; Each employee has a job title and may have an hourly pay rate ; Each employee has a phone number

    ; Each employee has a work schedule comprising of a start and end time for

    each of the seven days in a week. This schedule indicates the times when the

    employee is supposed to work, regardless of the hours that the employee

    actually works.

    ; Each employee may or may not have a supervisor. An employee will not

    have more than one supervisor at any particular time.

    ; An employee may or may not be a supervisor. A supervisor can supervise any

    number of employees.

    ; A supervisor has a salary

    ; An employee can fill one time card per day. He/she may have filled any

    number of time cards.

    ; A supervisor does not fill a time card

    MOVIE

    ; Each movie has a unique ID number

    ; Each movie has a title, a rating (G, PG, PG-13, R, etc.), duration, category

    (Comedy, Action, etc.), and a released date.

    ; Any number (including zero) copies of a movie may exist

    9

COPY

    ; Each movie copy has a own unique ID number

    ; Each copy has a format (e.g., DVD, VHS)

    ; Each copy has a rent duration

    ; Each movie copy is a copy of exactly one movie

    ; At any given time, a copy belongs to one and only one branch

    ; A movie copy does not exist if the corresponding movie does not exist

RENTAL:

    ; A rental is a unique transaction occurring any particular time a customer

    checks out a movie

    ; When a customer makes a rental, he/she is renting at least one copy, and may

    rent up to 10 copies.

    ; Each rental is made by exactly one customer

    ; A customer can rent the same copy any number of times

TIME

    ; The time and date that a customer rents a movie copy will be stored

    ; The time and date that a customer rents a movie copy will be unique for every

    rental

TIME_CARD

    ; Each employee will have one time card at any given time

    ; Each time card is filled by exactly one employee. Only one time card can be

    filled at any given time

    ; The start time and end time will be unique for every time card clocked

    ; The time card is filled once at the beginning of an employee’s day and once at

    the end.

    Assumptions: A combination of start time and end time is unique at any shift change.

    10

Report this document

For any questions or suggestions please email
cust-service@docsford.com