Lilydale Movies Information System Design

This document outlines the information system design for Lilydale Movies, a hypothetical movie rental store. It details key processes like customer registration, loaning movies, and DVD purchase. The report also presents logical and physical data dictionaries for the Customer and Movie tables, illustrating the database structure and attributes. A process description for 'Overdue Loan' is included, highlighting system automation in managing overdue rentals.

Running head: CURRENT SYSTEM ANALYSIS AND MODELLING
Assignment 1: Current System Analysis and Modelling
Name of the Student
Name of the University

1CURRENT SYSTEM ANALYSIS AND MODELLING
Executive Summary
The report reflects the system analysis and design of Lilydale Movies information system. The
system is capable of carrying out the key processes of the organization. The system analysis and
design is a great source of mitigating the internal issues, enhancing the efficiency and expanding
opportunities. Within this report, the system analysis has been done in the context of Lilydale
Movies. The organization is interested in carrying out system analysis and design for grab most
of the business opportunities and better control over the market. The report is combination of
business description and system data description. The introduction part is for familiarizing the
whole report. The business and data description are provided under two different sections.
Through the conclusion, the report is reviewed. Lilydale Movies needs to have a system that can
generate different reports based on the data that is put inside the database. Another issue that the
organization is having is overdue. The system must be able to analyze the data and limit the
overdue issues. Two logical data dictionary and two physical data dictionaries has been used.
The key process that has been described within the report are customer registration, loan and
DVD purchase. Moreover, the lower level process that has been selected within the report is
overdue loan.

2CURRENT SYSTEM ANALYSIS AND MODELLING
Table of Contents
1. Introduction:................................................................................................................................3
2. Organization Background:...........................................................................................................3
3. Documentation:............................................................................................................................4
3.1 Data Dictionary:.....................................................................................................................4
3.2 Process Description:..............................................................................................................8
3.2.1 Key Processes:................................................................................................................8
3.2.2 Lower Level Process:.....................................................................................................8
4. Conclusion:..................................................................................................................................8
Bibliography:.................................................................................................................................10

3CURRENT SYSTEM ANALYSIS AND MODELLING
1. Introduction:
The system analysis and design is a great source of mitigating the internal issues,
enhancing the efficiency and expanding opportunities. The data processing requirements are very
much depended on the business scale and type of operations done within the business (Dennis,
Wixom & Tegarden 2015, p 127). The system analysis and design provide the organization to
concentrate on the organizational wide data processing and business operations. If the system
analysis is done properly then the organization can have a better hold in the market and perform
better than the competitors. The system analysis and design allows the organization to determine
the ways a system can be used. In allows the organization to cover various operations of several
departments (often the whole organization).
Within this report, the system analysis has been done in the context of Lilydale Movies.
The organization is interested in carrying out system analysis and design for grab most of the
business opportunities and better control over the market.
The purpose of the work in this report is to develop an understanding of the business
processes, requirements and other factors. These will improve the understanding the reason of
carrying out this report. After the business factors are recognized then the system functions and
designs are to be done to provide an overview of the improved system.
The report is combination of business description and system data description. The
introduction part is for familiarizing the whole report. The business and data description are
provided under two different sections. Through the conclusion, the report is reviewed.
The data collection is mainly done from the case study example of Lilydale Movies. The
real information is gathered from the case study itself. On order to make the report critical,
various articles and websites has been read.
2. Organization Background:
Lilydale Movies is a developing film deals and rental tie wishing to overhaul their data
frameworks. The specialty he saw was that while the real motion picture employ chains give the
most recent and more well-known motion pictures which individuals should gather and decide
for themselves, Lilydale Movies could give additional administrations to clients, for example,

4CURRENT SYSTEM ANALYSIS AND MODELLING
pickup and conveyance, individual help to clients about their choices and to give a much more
broad choice of films for contract or deal from around the globe and from the past. The first store
was opened quite a long while back by three youthful business visionaries Peter Young, Mark
Goh and Alice Wong. Dwindle and Alice were motion picture fans and exceptionally educated
about films, yet Mark was especially inspired by it as a business opportunity filling a market
specialty.
And additionally finding their specialty, achievement has happened through cautious
determination of areas and of submitted and proficient administrators to run each store. The
stores have been much more fruitful than the proprietors could have envisioned. The
organization now has five stores in Melbourne rather than one and can see chances to extend the
chain into different urban areas and states. So far the proprietors have possessed the capacity to
oversee and bolster store administrators adequately by standard individual contacts. Be that as it
may, plainly in the event that they are to extend this will turn out to be more troublesome and
there must be a change in the data frameworks to screen execution and offer help.
Lilydale Movies needs to have a system that can generate different reports based on the
data that is put inside the database. Another issue that the organization is having is overdue. The
system must be able to analyze the data and limit the overdue issues.
3. Documentation:
3.1 Data Dictionary:
Table Name: Customer
Attribute Description Update
Frequency
Example Key
Cust_ID The unique
identifier to
recognize each
row uniquely
Daily Cust1 Primary
Name The name of
the customer
Daily Adams Jenkins None

5CURRENT SYSTEM ANALYSIS AND MODELLING
Address The address of
the customer
Daily 3/4 Adams Street None
Home_Telephone_Number The home
telephone
name of the
customer
Daily 001-334667 None
Work_Telephone_Number The number of
the office of
the customer
Daily 001-331667 None
Mobile_Number The personal
contact
number of the
customer
Daily 998877665544 None
Email_Address The personal
email address
of the
customer
Daily [e-mail] None
Drivers_Licence_Number The driver’s
license
number of the
customer
Daily LK87654 None
Medicare_Number The Medicare
number in case
of driver’s
license
number is not
available
Daily JUI876T None
Passport_Number The passport
number in case
of driver’s
license
Daily KJYRI897654THH77 None

6CURRENT SYSTEM ANALYSIS AND MODELLING
number and
medicare
number is not
available
Table 1: Logical Data Dictionary of Customer Table
(Source: Created by Author)
Table Name: Movie
Attribute Description Update
Frequency
Example Key
Movie_ID The unique
identifier to
find the
information in
the row
Once a Week Movie1 Primary
Title The title of the
movie
Once a Week Dunkirk None
Description The short
description of
the movie
Once a Week Evacuation of Allied
soldiers from
Belgium, the British
Empire, and France,
who were cut off and
surrounded by the
German army from
the beaches and
harbor of Dunkirk,
France, between May
26- June 04, 1940,
during Battle of
France in World War
None

7CURRENT SYSTEM ANALYSIS AND MODELLING
II.
Actors The name of
the main actors
Once a Week Harry Styles, Tom
Hardy, Cillian
Murphy
None
Director The director of
the movie
Once a Week Christopher Nolan None
Genre The genre
movie falls into
Once a Week War None
Length The total
duration of the
movie
Once a Week 02:00:00 None
Release_Year The year in
which the
movie was
released
Once a Week 2017 None
Price The price of the
copy in $
Once a Week 12 None
Table 2: Logical Data Dictionary of Movie Table
(Source: Created by Author)
Attribute Size Database
Name
Database location Data
Type
Name 25 Lilydale
Movies.db
Customer Table
second row
Char
Title 40 Lilydale
Movies.db
Movie Table second
row
Char
Table 3: Physical Data Dictionary of Name Attribute in Customer Table and Title
Attribute in Movie Table

8CURRENT SYSTEM ANALYSIS AND MODELLING
(Source: Created by Author)
3.2 Process Description:
3.2.1 Key Processes:
Customer Registration: The customer registration is a vital process that is to be done. In
order to provide better quality of services, Lilydale Movies must be able to store all the basic
data of the customer. The data will be collected by the system through internet and stored in the
database for further use. The customer data also provide the organization to keep track of
business processes in better way such as loaning a movie to a customer.
Loan: Loan is a very important part of Lilydale Movies’ business. The movies will be
provided to the customers as loan. The data that will be stored against a loan are customer
identification number and movie copy identification number1, date and time of loan and period
of the loan. The membership of the customer has to be current, otherwise the customer cannot
loan a movie.
DVD Purchase: Before purchasing a movie or DVD, Lilydale Movies staff will enter the
name and details of the movie to be purchased. The purchase order will be recognized by a
unique identifier. The supplier will be dispatching the movie along with an invoice.
3.2.2 Lower Level Process:
Overdue Loan: In case a customer does not return the rented movie within the defined
date, an auto generated notification will generated by the system. The store staff will contact the
customer directly. The system will also send an auto generated mail to the customer using the
email address stored in the database against the customer record.
4. Conclusion:
From the above report it can be concluded that Lilydale Movies is required to have a fully
functional and automated information system. An information system is capable of maintaining
the whole process of an organization automatically without the intervention of the humans.
However, because of the high cost of making that kind system, the system analysts prefer to
leave some of the less important processes to be done by the humans. The study has completely
relevant to the case study and report requirements. All the aspects of the business has been met
within the report. There are various processes that Lilydale Movies carryout in their daily

9CURRENT SYSTEM ANALYSIS AND MODELLING
operations. In this report only few of the processes has been visualized. The logical and physical
data dictionaries has been a great way of illustrating the insight of the database of the system.
Within the context of system analysis and design it is very important to have kludge about the
data.