Stock Control System And Analysis Design System Computer Science Essay

Published:

This essay has been submitted by a student. This is not an example of the work written by our professional essay writers.

As we are the student of the International Advanced Diploma in Computer Studies, we have to do this Systems Analysis & Design assignment. Our assignment title is Townsville Kicks Soccer Club. This assignment is intended to utilize some of the features of the Systems Analysis and Design.

The primary object of the practical assignment is to access student's ability to assemble a stock control system and analysis & design system. This should demonstrate the understanding of the modeling of a data-driven system.

In this assignment, there are six tasks.

According to the tasks 1, we have to analyst the required system using structured systems analysis methods and need to produce a Process Model including:

Context Diagram of the Townsville Kicks Soccer Club

Aims and Objectives of the Townsville Kicks Soccer Club

Data Flow Diagram for the Townsville Kicks Soccer Club

Process descriptions

Dataflow descriptions

Data store contents

External entity definitions

In the task 2, we use the structured systems analysis methods to analyst the required system and have to produce a Data Model including:

Entity Relationship Diagram

Entity descriptions for all entities

Appropriate attributes for all entities including primary and foreign keys

Optionality and degree of relationships between entities.

For the task 3, we have to produce a Entity Life History for a Townsville Kicks Soccer Club

For the task 4, we have to create a relational database design for the system including.

A set of fully normalized tables showing the normalization process for each.

Data Dictionary entries for all items included in the database design.

In the task 5, we have to make a prototype user interface for the Townsville Kicks Soccer Club. The following functions:

Searching for an item of Townsville Kicks Soccer Club

Processing the purchase of an item of Townsville Kicks Soccer Club

Adding a new item of Townsville Kicks Soccer Club

Task 6 is to produce a brief report and details of site preparation for the installation of the System plus details of the hardware to be installed.

(a)Context Diagram

(b) Aims and Objective

In this system have many processes, purchase, searching and sale, discount, stock control, loan and report. All the records of whole process are in book and on paper.

In the purchase process, the staff records about the purchase order and invoice, and also checked the purchase items. If the items haven't the required quality and the system difficult to know that those items are purchased from which supplier. Also they want to know how many items exist in each type of Townsville Kicks Soccer Club. Townsville Kicks Soccer Club has many types. So they conflict about the order. Sometime the staff missed what Townsville Kicks Soccer Club are ordered to which supplier. The reason is if they have poor quality items, the staff returns to goldsmith this item and changes with the new item. So they need a long time to search the records.

In the searching process there may be search of Townsville Kicks Soccer Club. In this process it takes a long time to find a required Townsville Kicks Soccer Club and not display Townsville Kicks Soccer Club catalogue in short time. When the customer is request Townsville Kicks Soccer Club, it takes a long time to give about Townsville Kicks Soccer Club. The user is searching Townsville Kicks Soccer Club takes up a lot of time and mistakes can be made. It takes about five minutes to serve each customer because of the wrong Townsville Kicks Soccer Club list system and customers are beginning to complain about the wasted time.

In the sale process, staffs record selling item with quantity. After making order, invoice produce for the customer about the sale. The calculation process can complex in the invoice form. The payment process can be made mistakes to record of payment. And the staff give need to update the accounting, but sometime lack.

In the discount process the manager is decide which of the older Townsville Kicks Soccer Club will be sold at discount prices to customers. The manager is checking the older Townsville Kicks Soccer Club take up a lot of time and wrong check of the older Townsville Kicks Soccer Club records.

In the stock control process the staff is checking the Townsville Kicks Soccer Club, purchase order and sale of all status. In this process it takes a long time to find all status and wrong records of Townsville Kicks Soccer Club status.

In the report process the staff may be report of Townsville Kicks Soccer Club and sale detail to give the manager. In this process report can complex and mistakes can be made for record of monthly report. All of processes are made by manually.

We want to overcome the above process problem of their business by changing computerized system of their process. In the sale and purchasing process we want to distinguish the records clearly. E.g. customer records, order records, invoice records etc.

(c) Data Flow Diagram

Process Descriptions

1.Registration Process

This process, the member registration to the Townsville Kicks Soccer Club of the member. The staff the display the Townsville Kicks Soccer Club's Explain the Class Catalogue and Pay the Member form . Fill to the member to the member form of the member information.

2. Searching Process

This process, the Member searches the Townsville Kicks Soccer Club from the Townsville Kicks Soccer Club store of sale clerk. The staff is display the Townsville Kicks Soccer Club catalogue. To search, this Member needs to make the required Townsville Kicks Soccer Club. Next, the staff gives the about jewellery item. When search the Townsville Kicks Soccer Club, the staff checks the Townsville Kicks Soccer Club.

3. Receive Payment Process

This process, the accounting checks payment form Bank. The staff needs to check the credit card or cheque. And the staff is checking the accounting information. Next, the bank transfers the payment for the accounting. Than, the accounting to need the update of accounting.

7. Report Process

This process, the sends to report for the manager. The loan and sale old Townsville Kicks Soccer Club clerk needs to check the Townsville Kicks Soccer Club and report detail. And the sale clerk is sending the report. Next, the manager gives the report for the sale clerk. Than, the sale clerk to need the update of monthly report.

Data Flow Descriptions

1. Order by phone

Staff is order the new Townsville Kicks Soccer Club by phone to supplier.

2. Accept order and invoice

Supplier gives the accept order and invoice to Information Department.

3. Give payment

Purchase Department is give payment of new Townsville Kicks Soccer Club to the supplier.

4. Receive payment and give jewellery item

Supplier gives the receive payment and give Townsville Kicks Soccer Club.

5. Enquiry

Member is enquiry to the staff.

6. Information

Staff gives the information.

7. Searching the catalogue by category

Customer is searching the Townsville Kicks Soccer Club Catalogues by Title, Director Name, Actor Name and Category of the Townsville Kicks Soccer Club.

8. Show Townsville Kicks Soccer Club catalogue

Staff is to show the Townsville Kicks Soccer Club catalogue for customer.

9. Request Townsville Kicks Soccer Club

Customer requests the jewellery item to sale clerk.

11. Give invoice

Staff gives the invoice to member.

12. Give Member fee

Customer gives the Member fee (cash, credit card or cheque).

13. Check credit card or cheque

Bank to check the credit card or cheque.

14. Transfer

Bank transfer the payment to accounting.

15. Send report

Staff sends report to the manager.

16. Give report

Manager gives the report to the Staff.

Data Store Contents

1. Member

To keep the member information that is Member ID, Member Name, Member Address, Member Phone, Member E-Mail, Member Register Date, Expire Date and Register Fee,

2. Member Order Detail

To keep the member order information that is invoice No, Payment Date, Deposit and balance.

3. Report

The staff is needed to update the report for monthly report end of the manager gives the report file.

External Entity Definitions

2. Member

Member has made search the catalogue by category and request Townsville Kicks Soccer Club at the Townsville Kicks Soccer Club store. And then the member is choosing the new Townsville Kicks Soccer Club and gives payment (cash, credit card or cheque) for the Townsville Kicks Soccer Club. He/she is receiving the discount for old Townsville Kicks Soccer Club from the Townsville Kicks Soccer Club store of Manager.

3. Bank

Bank is transferring the payment (credit card or cheque) from the Townsville Kicks Soccer Club store of accounting.

4. Manager

Manager is checking the monthly report from the staff.

(a) Entity Relationship Diagram

(b) ENTITY DESCRIPTIONS

Member

Member entity is to store the Member information. It is used to get the Member data for sale form. This entity is containing five attributes. They are -

Member ID

Member Name

Address

Phone

Email

Member Registration Detail

Purchase order detail entity is connected to the purchase order entity and Townsville Kicks Soccer Club entity. This entity is containing three attributes. They are -

1. Member ID

2. Member Name

3. Address

4. Phone

5. Email

6. Member Type

7. Age

8. Gender

9. Education Level

10. Total

11. Staff Name

12. Staff Sing

13. Member Sign

(c) Attributes

EINTITY NAME - Member

Attributes

Data Type

Size

Comments

Member ID

String

30 bytes

Primary Key

Member Name

String

50 bytes

Address

String

50 bytes

Phone

Number

8 bytes

Email

String

50 bytes

EINTITY NAME - Member Registration Detail

Attributes

Data Type

Size

Comments

Member ID

String

30 bytes

Primary Key

Member Name

String

50 bytes

Primary Key

Member Address

Number

10 bytes

Phone Number

Number

10bytes

Email Address

Sting

20bytes

Member Type

String

15bytes

Age

Number

5bytes

Gender

String

10bytes

Education Level

String

30bytes

Total

Number

6bytes

Staff Name

String

20bytes

Registration Date

Sting

10bytes

EINTITY NAME - Player Member

Attributes

Data Type

Size

Comments

Member ID

String

30 bytes

Primary Key

Player Name

String

50 bytes

Address

String

50 bytes

Phone

Number

8 bytes

Email

String

50 bytes

EINTITY NAME - Member Registration Detail

Attributes

Data Type

Size

Comments

Member ID

String

30 bytes

Primary Key

Player Name

String

50 bytes

Primary Key

Player Address

Number

10 bytes

Phone Number

Number

10bytes

Email Address

Sting

20bytes

Player Type

String

15bytes

Age

Number

5bytes

Gender

String

10bytes

Education Level

String

30bytes

Total

Number

6bytes

Staff Name

String

20bytes

Registration Date

Sting

10bytes

(d) OPTIONALITY AND DEGREE OF RELATIONSHIP

1. Member and Reservation

Between Member and Reservation is one to many relationships. A Member may make Reservation. For Reservation, one order must have one Member.

2. Member Registration Detail

Registration Process contains many different Member Registration detail and it is relate to only one Member Registration.

3. Copy Townsville Kicks Soccer Club and Member Registration Detail

Between Copy Townsville Kicks Soccer Club and Member Registration Detail is one to many relationships.

4. Member and Member fee

Between Invoice and Member fee is one to many relationships.

5. Player Member and Reservation

Between Player Member and Reservation is one to many relationships. A Player Member may make Reservation. For Reservation, one order must have one Member.

6. Player Member Registration Detail

Registration Process contains many different Player Member Registration detail and it is relate to only one Player Member Registration.

7. Copy Townsville Kicks Soccer Club and Player Member Registration Detail

Between Copy Townsville Kicks Soccer Club and Player Member Registration Detail is one to many relationships.

8. Player Member and Player Member fee

Between Invoice and Player Member fee is one to many relationships.

ENTITY LIFE HISTORY

(a) Normalization

Member Order Form (Normalization)

UNF (Gather Data)

Member ID

Member Name

Address

Phone

Email

Date

Member Type

Gender

Age

Education Level

Total

Member Sign

Staff Sign

Staff Name

II Choose Key

Member ID

III INF

Member ID

Address

Phone

Email

Date

Staff Sign

Staff Name

Optimization

Member ID

Total

[Member]

Member ID

Member Name

Address

Phone

Email

VII Data Model

Member Registration Form (Normalization)

I UNF (Gather Data)

Member ID

Member Name

Address

Phone

Email

Date

Member Type

Gender

Age

Education Level

Total

Member Sign

Staff Sign

Staff Name

II

Choose Key

Member ID

III

INF

Member ID

Member Type

Address

Phone

Email

Sale Date

Staff Sign

Staff Name

Relation Group

Member Type

Member ID

Age

Education Level

Total

VII Data Model

(b) Data Dictionary

Title: Townsville Kicks Soccer Club

Type: Element

Author: Aung Kyaw Nyunt

Date: 15/1/2010

No.

Name

Alias

Definition

Occurrence

Picture

Notes

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

Member ID

Member Name

Address

Phone

Email

Member Type

Date

Total

Age

Education Level

Gender

Staff Name

Player Member ID

Player Name

Player Address

Player Phone

Player Email

Date

Player Type

Player Age

Player Gender

Player Education Level

Staff Name

To identify Member ID

Name of the Member

Address of the Member

Telephone No of the Member

Email of the Member

To Type the Member Type

Date of each

Total of Member

Age of Member

Member Education level

Male or Female

Registration Staff Name

To identify Player ID

To identify Player Name

Player Address

Player Phone Number

Type of Type of Player Email Address

Type of Date

Type of Player Type

To type Player Age

To type of Male or Female

Education level

To type staff Name

1 value for Member ID

1value for CustomerName

1value for Address

1value for Phone

1 value for Email

1 value for Member type

1 value for Date

1 value for Total

1 value for Age

1 value for Education Level

1 value for Male or Female

1 value for Staff Name

1 value for Player

ID

1 value for Player Name

1 value for Player Address

1 value for Player Phone Number

1 value for Player Email Address

1 value for Date

1 value for Player Type

1 value for Player Age

1 value for Male or Female

1 value for Education Level

1 value for Staff Name

Title: Townsville Kicks Soccer Club

Type: Structure

Author: Aung Kyaw Nyunt

Date: 15/1/2010

No.

Name

Alias

Definition

Occurrence

Picture

Notes

1

2

3

4

5

6

Member

Member Registration

Member Registration Detail

Player

Player Register

Player Registration Detail

Member=

Member ID+

Member Name+

Address + Phone +

Email

Member=

Member ID+

Member Name+

Address + Phone +

Email

Member Order= Member No+ Member Date+ Member ID+ Total

Player =

Player ID+

Player Name+

Address + Phone +

Email

Player=

Player ID+

Player Name+

Address + Phone +

Email

Player Order= Player No+

Player Date+ Player ID+ Total

Title: Townsville Kicks Soccer Club

Type: Data store

Author: Aung Kyaw Nyunt

Date: 15/1/2010

No.

Name

Alias

Definition

Occurrence

Picture

Notes

1

2

3

4

5

6

Member File

Player File

Member Registration

Member Registration Detail File

Player Registration

Player Registration Detail

Member=

Member ID+

Member Name+

Address + Phone + Email

Player=

Player ID+

Player Name+

Address +Phone+ Email

Member

Member IC+ Registration Date+ Total

Member

Member IC+ Registration Date+ Total

Player=

Player ID+

Player Name+

Address +Phone+ Email

Player=

Player ID+

Player Name+

Address +Phone+ Email

Max Size of the store[Table- 5,721,300]

Expected Size of the store[4,777,440]

Max Size of the store[Table- 4,725,300]

Expected Size of the store[3,778,440]

Max Size of the store[Table- 9,300]

Expected Size of the store[7,440]

Max Size of the store[Table- 9,300]

Expected Size of the store[7,440]

Max Size of the store[Table- 6,985,300]

Expected Size of the store[5,857,440]

Max Size of the store[Table- 8,400]

Expected Size of the store[7,560]

Flow in: Record

Member information

Flow out: Retrieve Member information

Flow in:Record

Player information

Flow out:Retrieve Player

Information

Flow in: Record

Member Name and Member ID information

Flow in: Record

Member Name and Townsville Kicks Soccer Club

Flow in: Record

Member Name and Member ID information

Flow in: Record

Player ID and Player Name

Flow out: Retrieve Player ID

Title: Townsville Kicks Soccer Club

Type: Data flow

Author: Aung Kyaw Nyunt

Date: 15/1/2010

No.

Name

Alias

Definition

Occurrence

Picture

Notes

1

2

3

4

5

6

7

8

Enquiry

Request for member registration

Receiving member card

Searching the Catalogue

Enquiry

Player for member registration

Receiving Player card

Searching the Catalogue

Enquiry for member

Member registration to become member of the system

After registration, the system give member card

Search catalogue=title + director +category +

Member card

Enquiry for Player

Player registration to become Player of the system

After registration, the system give Player card

Search catalogue=title + director +category +

Player card

30 person per day, Maximum50, and Minimum 5, No seasonal variation

30 persons per day, maximum 50, minimum 5, no seasonal variation

30 persons per day, maximum 50, minimum 5, no seasonal variation

30persons per day, maximum50, minimum 5, no

Seasonal variation

30 items per day, maximum 50, minimum 5, no seasonal variation

30 items per day, maximum 50, minimum 5, no seasonal variation

30 persons per day, maximum 50, minimum 5, no seasonal variation

30 persons per day, maximum 50, minimum 5, no seasonal variation

Source:

Customer

Destination

Registration Process

Source: Customer

Destination: Searching Process

Source: Customer

Destination: Searching Process

Source: Searching Process

Destination: Customer

Source: Customer

Destination: Searching Process

Source: Searching Process

Destination: Customer

Source: Customer

Destination: Sale Process

Source: The system Destination:

Purchase Process

(a) Draft Screen Design

Text Box - To type the Member ID

Option Button - To choose the Male or Female

Text Box - To type the First Name

Text Box - To type the Last Name

Text Box - To type the No

Text Box - To type the NRC No

Text Box - To type the Address

Text Box - To type the Post Code

Text Box - To type the Country Name

Check Box - To choose the check box

Text Box - To type the phone No

Text Box - To type the E-mail Address

Button - To Apply the Member Form

Button - To cancel the Registration

Text Box - To type the Member ID

Option Button - To choose the Male or Female

Text Box - To type the First Name

Text Box - To type the Last Name

Text Box - To type the No

Text Box - To type the NRC No

Text Box - To type the Address

Text Box - To type the Post Code

Text Box - To type the Country Name

Check Box - To choose the check box

Text Box - To type the phone No

Text Box - To type the E-mail Address

Button - To Apply the Member Form

Button - To cancel the Registration

(b) Prototype

Townsville Kicks Soccer Club

All the text boxes and combo boxes must be entered or selected before clicking Apply button

Data in boxes must be correct data type for Example Name, NRC No, Address Post Code, Country Name, Phone No, and Email Address must be written in its format else show message to refill.

Check all Data are entered in boxes else show message to enter.

Online Training

Open the Internet explorer

Type the Address bar (http://www.townsvillersoccer.com)

Report

Our assignment scenario is Townsville Kicks Soccer Club Store system. This assignment is make good use of the Systems Analysis and Design.

According to the tasks 1, we have to analyst the required system using structured systems analysis methods. We have made the context diagram of the Townsville Kicks Soccer Club store system. We have to do the aims and objectives of the Townsville Kicks Soccer Club store system. This process is including many processes, they are: purchase order process, searching process, sale process, receive payment process, discount process, stock control process and report process. We have made the process descriptions, dataflow descriptions, data store contents, and external entity definitions of the system.

In the task 2, we have used the structured systems analysis methods to analyst the required system and we have to produce a data model. We have to draw the entity relationship diagram for the system. And then, we make the description of the all entities in the diagram. After, we have specified the primary and foreign keys for all entities. Then we have made the optionality and degree of relationships between entities.

For the task 3, we have to make an Entity Life History for a Townsville Kicks Soccer Club.

For the task 4, we have to make a relational database design for the system including. It is a set of fully normalized tables showing the normalization process for purchase order and sale forms. After, we have described the data dictionary entries for all items included in the database design. The data dictionary entries are include the data elements, data structures, data stores and data flows

In the task 5, we have made a prototype user interface for the Townsville Kicks Soccer Club store system. It is create three forms. There are searching for an item of Townsville Kicks Soccer Club, processing the purchase, and add new item of Townsville Kicks Soccer Club. Then include the validation checking and reasons for each prototype.

(a) SITE PREPARATION FOR THE INSTALLATION OF THE SYSTEM

Power Supply

The Townsville Kicks Soccer Club store will be installing a system consisting of several workstations, four machines of which are for use. Each machine need to Uninterruptible Power Supply (UPS) for external power fails time (i.e. electric outlets fail). This action also prevents hard disk crash situation when power failure occurs. The UPS takes the incoming A/C power and output it directly to machines after filtering all unwanted noise, sags or surges. This is a clean supply. The UPS can connect to computer and monitor, etc. The power cables from the computer, monitor and printer are approximately 2m (6ft) long. The incoming A/C mode of input voltage is170- 265 Volt and input frequency is 48-60 Hz. Output voltage is 220-240 Volt, and out put power is 650 VA. The UPS load for this system is need to 4 pieces.

Heat Dissipation

The Townsville Kicks Soccer Club store is incorporated in most computers, using even a single machine in an office can change the temperature and humidity. As the room temperature increase, system reliability decreases. All electronic components generate heat while operating. This heat must be dissipated to the surrounding air for the components to operate reliably. There must be a good flow of air conditioning must be capable of maintaining a constant temperature. The air conditioning load for this system is need to 2 pieces.

Office Alternations

The large computer may be need to more space than is currently available required the modifications to the office layout. The computer may be restructuring the installation of new system. The air conditioning may be necessitating the head dissipated for the new system. And then, required the increasing security for prevent access to the data and prevent the theft of equipment.

Office Layout

When the siting of computer equipment, or considering the redecoration of an office in which it is already used. Any the potential sources of fixed stare, reflection and high contrast in the colour scheme. Neutral colors such as light brown and cream should be used. And then paintwork should be not shining. White should be used a little.

Office Furniture

The office furniture is required the particularly important to ensure, any agronomic requirements of user are properly met. The desk should have enough space for documents and desk height must be between 700 and 720 mm. Other requirements are document holders and foot-rests. The chair used at the workstations should be adjustable seat and back-rest heights and have short or no arm rests.

(b) Hardware Requirements

For Four PC:

Processor: CPU: Intel Pentium 4 Core 2 Dual 2.5 GHz

ASUS P5KPL-CM (6MB L2 Cache, 1066 MHz) with Sound + VGA + LAN

Kingston 3 GB DDR2

350 GB (Seagate) SATA

Snmsung Keyboard

Snmsung Tech Mouse

17" 1918wm wide view LCD Monitor(View sonic)

UPS Power Tree (650 VA) Classic

DVD-RW Light Scribe [Sony] SATA

Speaker 180 Watts

P4 Casing (Normal Light)

Other Accessories Requirements

CANON LaserJet 3050 Printer

ESPON TX101 All in One Color Printer

Network Interface Card (NIC) Requirements

Prolink (fast ethernet NIC 100Mbps) for PC

Prolink (gigabit ethernet NIC 1000Mbps) for workstation

Store Security Requirements

CCTV Cameras

Emergency Alarms Systems

Identity Card System

Software Requirements

Window Server 2008

Microsoft Visual Studio 2005

Microsoft .NET Framework SDK v2.0

Microsoft Access 2003

Internet Browser

Assumptions

(a) ADVANTAGES AND DISADVANTAGES

Strength

Context diagram show main external entities and data flow

Data flow diagram show details processes with its external entities, data flow and data store

Detail explanation of relationships between entities in entity relationship diagram

Step by step normalization of forms

User friendly interface of webpage

Weakness

Some processes are left in data flow diagram

Incomplete description for all entities in the diagram

Confused logical decision in drawing data model

Difficulties

Some entities has few data flow with system

Small processes are difficult to draw data flow diagram

Choose a key in relation is confused

Normalization processes take time to build

(b) FUTURE DEVELOPMENT

Some processes will include in system

More and better prototype user interfaces

Detail normalization processes for each table

Separate and detail files to store data

Perfect validation for web pages

Entity life history for other entities

(c) RECOMMENDATION

Although my assignment is not completed for whole system, it is for assignment requirements and basic modeling, design and analysis. For instance, data flow diagram, entity relationship diagram, normalization and prototype are included but they can miss some fact because we are just considering for a system after browsing some sites from internet.

Writing Services

Essay Writing
Service

Find out how the very best essay writing service can help you accomplish more and achieve higher marks today.

Assignment Writing Service

From complicated assignments to tricky tasks, our experts can tackle virtually any question thrown at them.

Dissertation Writing Service

A dissertation (also known as a thesis or research project) is probably the most important piece of work for any student! From full dissertations to individual chapters, we’re on hand to support you.

Coursework Writing Service

Our expert qualified writers can help you get your coursework right first time, every time.

Dissertation Proposal Service

The first step to completing a dissertation is to create a proposal that talks about what you wish to do. Our experts can design suitable methodologies - perfect to help you get started with a dissertation.

Report Writing
Service

Reports for any audience. Perfectly structured, professionally written, and tailored to suit your exact requirements.

Essay Skeleton Answer Service

If you’re just looking for some help to get started on an essay, our outline service provides you with a perfect essay plan.

Marking & Proofreading Service

Not sure if your work is hitting the mark? Struggling to get feedback from your lecturer? Our premium marking service was created just for you - get the feedback you deserve now.

Exam Revision
Service

Exams can be one of the most stressful experiences you’ll ever have! Revision is key, and we’re here to help. With custom created revision notes and exam answers, you’ll never feel underprepared again.