DVD Store System

Published:

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

INTRODUCTION

I am a student of IADCS in KMD computer center and now I have to do three assignments, Enterprise Networking, Advanced Java and System Analysis And Design in this first semester held on coming March 2010. This assignment is about the System Analysis And Design and now I will describe it briefly task by task. It is about the DVD Store System and it will allow members of the general public, who have registered as members, to borrow DVDs of movies from around the world. The DVD store is installing a system consisting of several workstations, two of which are for use by the public: The public workstation is for using the member to search desired DVD by title, keyword, director and category to loan. There are six tasks in this assignment and I have to do the associated tasks by using SSADM Techniques. Task 1 is about to create a process model for DVD Loans system including a context diagram, a statement of the aims and objectives and a data flow diagram for the DVD Loan System. In Data Flow Diagram, process descriptions, dataflow descriptions, data store contents and external entity definitions have to be included. In Task 2, an Entity Relationship Diagram, Entity descriptions for all entities in the diagram, appropriate attributes for all entities including primary and foreign keys and relationships detailing optionality and degree of relationships between entities. I have to draw an Entity Life History for a DVD in Task 3 and Task 4 is about to normalize the forms for DVD Loan System and a data dictionary entries for all items included in database design. I have to create a prototype for DVD Loan System including these three forms, DVD Search Form, Loan And Return Form and Member Registration Form. Moreover, I have to print screenshots of these three forms and describe the validation rules for that three forms. The last task is about to write a report for DVD Store System including 4500 words in total. In this report, review, details of task 1 to 5, site preparation for the installation of the system, details of hardware and review of the whole assignment have to be included.

(b) AIMS AND OBJECTIVES

The objective of the DVD Store system is to change new computerized system from manual system. We can reduce time, effort and cost by change computerized system. the DVD Store will allow members of the general public, who have registered as members, to borrow DVDs of movies from around the world. There are several workstations and two of which are for use by the public: The public workstation can be used by the members who want to search desired DVD to loan. The remaining workstation can only be used by the counter of the staff. The customer who wants to loan DVDs from DVD Store must register as a member before he/she loan. DVDs can be loaned for an agreed period of 24 hours, 48 hours or one week and there is a different loan fee for each. Payment have to be made simultaneously after loaning DVD and recorded it with manual system before doing this computerized system. On that time, there were several errors such as duplicate data and data lost. So, all the staff has a little difficulty. But if we change this system to computerized system, it is so easy to use for the staff and the loan members. Moreover, last manual system, if the member wants to search the desired DVD, the staff have to be review and search from the DVD record book and loan detail. So, there was a little difficulties and complexity to search. But now, the member can easily search desired DVD by themselves by changing to computerized system.

(c) DATA FLOW DIAGRAMS

PROCESS DESCRIPTIONS

No

Process No

Process Name

Process Description

1

1

Ordering DVD

Firstly, the manager will search the update qualified DVD to order. Then, he will order new DVD from the distributor to loan in his DVD Store. This is the initial stage of DVD Store System

2

2

Member Registration

The customer must register as a member if he/she wants to loan the desired DVD. After making his/her registration, he/she can loan the desired DVD with his/her member ID.

3

3

Searching desired DVD

The member can search and choose the desired DVD by title, keyword, director and category from the public work station.

4

4

Loan DVD

After choosing DVD, the member can loan desired DVD from the staff. Then, the staff will record about his/her information with his/her member ID.

5

5

Giving overdue fee

If the member will return the loaned DVD after due date, he/she must pay the overdue fee for fine to the staff

6

6

Return DVD

The member will return the loaned DVD before due date and then he/she can loan again or not.

7

7

Sales old DVD

The manager will collect the old DVDs to sale to the customers.

DATA FLOW DESCRIPTIONS

No

Data Flow

Source

Destination

Data Flow Contents

1

Enquiry

Customer entity

Process1, make enquiry

The customer enquiry the information of the appointment and training process and the system give the require information

2

Make register

Customer entity

Process2, make register for the training.

When the customer make register, the system give the registration form and then the customer fill the information. The system give the member ID

3

Appointment

Member

Proces3, take an appointment for the training

The customer take an appointment for training, the system show the time schedule and make the appointment.

4

Training

Member

Process4, the member make training

The member make the training at the system

5

Payment

Member

Process5, the customer pay money for the training cost

The customers make the payment for the training cost. The system gives the invoice for the cost of training.

6

Monthly Payment

Member

Process6, the customer pay money as a monthly payment

This is the monthly payment for the training cost. The system gives the invoice for the Monthly payment.

Data Store Contents

No

Data Store name

Flow In process

Flow out process

Data store contents

1

Distributor file

Record Distributor, ordered new updated DVD and DVD cost

To review the ordered new updated DVD and DVD cost

2

DVD record

Save DVD information

To review the DVD information(new updated DVD or old DVD)

3

Order

Record about the ordered DVD

To record the ordered DVD detail information and its cost.

4

Member Information

Record member information

The member information is recorded in this file.

5

Loan Detail

Record the loan detail of hired DVD

To record the loaned member and loaned DVD.

6

Old DVD Detail

Record the old DVD information

To record the old DVD information to sale to the member.

7

Sales

Record about the old DVD and its related sales information

The manager will sales the old DVD to the member and record the related sales information in this file.

EXTERNAL ENITITY DEFINITIONS

No

External Entity

External Entity Description

1

Customer

The customer who wants to be a member to loan DVDs from DVD Store.

2

Member

The member who can loan the desired DVD from DVD Store.

3

DVD Distributor

The distributor who want to sale their DVDs.

(a) EINTITY RELATIONSHIP DIAGRAM

(b) ENTITY DESCRIPTIONS

No

Entity Name

Entity Description

1

Distributor

Distributor=Distributor ID, Name

The distributor who wants to sale ordered new DVD.

2

Order

Order=Order No, Distributor ID, Order Date, Expected Delivery Date

The order is recorded about detail of making order information.

3

Member

Member=Member ID, Name, Address, Phone No, Email

Member who want to loan DVDs from DVD Store.

4

Loan

Loan= Loan ID, Member ID, Loan Date, Expected Return Date, Total No Of Loan DVD

When the member loan desired DVD from DVD Store, this is to record about loan DVD information.

5

DVD

DVD= DVD ID, Title, Unit Price

This the information about DVD detail.

6

Sales

Sales= Sales ID, Staff ID, Sales Date,

No Of Sales DVD

This is the information about sales.

7

Old DVD

Old DVD=DVD ID, title, Unit Price, Old DVD ID

This is the information detail about the old DVD.

(c) ATTRIBUTES

EINTITY NAME - Distributor

Attributes

Data Type

Size

Comments

Distributor ID

String

4 bytes

Primary Key

Name

Text

25 bytes

EINTITY NAME - Order

Attributes

Data Type

Size

Comments

Order No

String

4 bytes

Primary Key

Distributor ID

String

4 bytes

Foreign Key

` Order Date

String

4 bytes

Expected Delivery Date

String

4 bytes

EINTITY NAME - Member

Attributes

Data Type

Size

Comments

Member ID

String

4 bytes

Primary Key

Name

Text

25 bytes

Foreign Key

` Address

Text

25 bytes

Phone No

String

25 bytes

Email

String

25 bytes

EINTITY NAME - Loan

Attributes

Data Type

Size

Comments

Loan ID

String

4 bytes

Primary Key

Member ID

String

4 bytes

Foreign Key

` Loan Date

String

4 bytes

Expected Return Date

String

25 bytes

Total No Of Loan DVD

Number

25 bytes

EINTITY NAME - DVD

Attributes

Data Type

Size

Comments

DVD ID

String

4 bytes

Primary Key

Title

Text

25 bytes

Unit Price

String

4 bytes

EINTITY NAME - Sales

Attributes

Data Type

Size

Comments

Sales ID

String

4 bytes

Primary Key

Staff ID

Text

25 bytes

Foreign Key

Sales Date

String

4 bytes

No Of Sales DVD

Number

25 bytes

EINTITY NAME - Old DVD

Attributes

Data Type

Size

Comments

DVD ID

String

4 bytes

Foreign Key

title

Text

25 bytes

Unit Price

String

4 bytes

Old DVD ID

Number

25 bytes

Primary Key

(d) OPTIONALITY AND DEGREE OF RELATIONSHIP

Entities

Distributor and Order

Degree of relationship

One to Many

Optionality

The distributor can have one or more order.

The order might have one distributor.

Entities

Member and Loan

Degree of relationship

One to Many

Optionality

The member can have one or more loan.

The loan can have one member.

Entities

DVD and Old DVD

Degree of relationship

One to Many

Optionality

The DVD file can have one or more Old DVD.

The Old DVD may have one DVD.

Entities

Sales and Old DVD

Degree of relationship

Many to Many

Optionality

The sales can have one or more Old DVD.

The Old DVD can have one or more sales.

Sales.

Entities

Member and Sales

Degree of relationship

Many to Many

Optionality

The member can have one or more sales.

The sales may have one or more members.

Entities

Loan and DVD

Degree of relationship

Many to Many

Optionality

Loan can have one or more DVD.

The DVD may have one or more loan.

Entities

Order and DVD

Degree of relationship

Many to Many

Optionality

The order can have one or more DVD.

The DVD may have one or more order.

(a) ENTITY LIFE HISTORY For DVD Store

(a) NORMALIZATION

1.UNF

LoanID

MemberID

Name

Address

PhoneNo

Email

LoanDate

ExpectedReturnDate

TotalNoOfLoanDVD

CopyNo

Title

LoanPrice

OverdueFee

ActualReturnDate

2. Choose a key

LoanID

3. 1NF

Single Group

LoanID

MemberID

Name

Address

PhoneNo

Email

LoanDate

ExpectedReturnDate

TotalNoOfLoanDVD

Repitition Group

LoanID

CopyNo

Title

LoanPrice

OverdueFee

ActualReturnDate

4. 2NF

LoanID

MemberID

Name

Address

PhoneNo

Email

LoanDate

ExpectedReturnDate

TotalNoOfLoanDVD

LoanID

CopyNo

OverdueFee

ActualReturnDate

CopyNo

Title

LoanPrice

5. 3NF

LoanID

*MemberID

LoanDate

ExpectedReturnDate

TotalNoOfLoanDVD

MemberID

Name

Address

PhoneNo

Email

LoanID

CopyNo

OverdueFee

ActualReturnDate

CopyNo

Title

LoanPrice

6.Optimization

[Loan]

LoanID

*MemberID

LoanDate

ExpectedReturnDate

TotalNoOfLoanDVD

[Member]

MemberID

Name

Address

PhoneNo

Email

[LoanDetail]

LoanID

CopyNo

OverdueFee

ActualReturnDate

[CopyDVD]

CopyNo

Title

LoanPrice

7. Data Model

1.UNF

Purchase-OrderNo

PurchaseDate

ExpectedDeliveryDate

DistributorID

Name

Address

PhoneNo

Email

DVDID

Title

UnitPrice

Quantity

Amount

TotalPrice

ActualDeliveryDate

2. Choose a key

Purchase-OrderNo

3. 1NF

Single Group

Purchase-OrderNo

PurchaseDate

ExpectedDeliveryDate

DistributorID

Name

Address

PhoneNo

Email

Repititon Group

Purchase-OrderNo

DVDID

Title

UnitPrice

Quantity

Amount

TotalPrice

ActualDeliveryDate

4.2NF

Purchase-OrderNo

PurchaseDate

ExpectedDeliveryDate

DistributorID

Name

Address

PhoneNo

Email

Purchase-OrderNo

DVDID

Quantity

Amount

TotalPrice

ActualDeliveryDate

DVDID

Title

UnitPrice

5. 3NF

Purchase-OrderNo

*DistributorID

PurchaseDate

ExpectedDeliveryDate

DistributorID

Name

Address

PhoneNo

Email

Purchase-OrderNo

DVDID

Quantity

Amount

TotalPrice

ActualDeliveryDate

DVDID

Title

UnitPrice

6. Optimisation

[Purchase]

Purchase-OrderNo

*DistributorID

PurchaseDate

ExpectedDeliveryDate

[Distributor]

DistributorID

Name

Address

PhoneNo

Email

[Purchase Detail]

Purchase-OrderNo

DVDID

Quantity

Amount

TotalPrice

ActualDeliveryDate

[DVD]

DVDID

Title

UnitPrice

7.Data Model

1.UNF

SalesID

SalesDate

NoOfSalesDVD

StaffID

Name

DVDID

Title

Category

Quantity

SalesPrice

Amount

TotalPrice

2. Choose a key

SalesID

3. 1NF

Single Group

SalesID

SalesDate

NoOfSalesDVD

StaffID

Name

TotalPrice

Repitition Group

SalesID

DVDID

Title

Category

Quantity

SalesPrice

Amount

4. 2NF

SalesID

SalesDate

NoOfSalesDVD

StaffID

Name

TotalPrice

SalesID

DVDID

Quantity

Amount

DVDID

Title

Category

SalesPrice

5. 3NF

SalesID

*StaffID

SalesDate

NoOfSalesDVD

StaffID

Name

SalesID

DVDID

Quantity

Amount

DVDID

Title

Category

SalesPrice

6. Optimisation

[Sales]

SalesID

*StaffID

SalesDate

NoOfSalesDVD

[Staff]

StaffID

Name

StaffEmail

[Sales Detail]

SalesID

DVDID

Quantity

Amount

[DVD]

DVDID

Title

Category

SalesPrice

7. Data Model

(b) DATA DICTIONARY

Title: DVD Store

Type: Element

Author: Aye Mya Thidar

Date: 9 Jan 2010

No

Name

Alias

Definition

Occurrence

Picture

Notes

1

LoanID

LoanNo

ID of loan

No for loan

2

MemberID

MemberNo

Customer No for the one who want to loan DVD

ID for the customer

3

LoanDate

Date for loan DVD

Date for the started loan day

4

ExpectedReturnDate

Return date for loan DVD

The guess date for returning loan DVD

5

TotalNoOfLoanDVD

NoOfLoanDVD

The total No of loan DVD

The total No of loan DVD

6

MemberName

Name of the member

The member name which is the mark of the member

7

Address

The place where member live

The place where member live

8

PhoneNo

ContactNo

The connected no of member

The No that can be connected with member

9

Email

Email of member

Email address of the member

10

CopyNo

Copy No of original DVD

Copy No of original DVD

11

OverdueFee

OverdueFine, OverduePayment

The fine for overdue return DVD

The money that must be given for overdue return DVD

12

ActualReturnDate

The date for real return DVD

The date in which the member return DVD

13

Title

DVDName

The Name of DVD

The DVD name which is the mark of DVD

14

LoanPrice

LoanPayment

Price for Loan DVD

The money that must be given for loan DVD

15

Purchase-OrderNo

Purchase-OrderID

The ID No for purchase & order

16

DistributorID

DistributorNo

The ID for the distributor

The Distributor No for the one who purchase DVD

17

PurchaseDate

Date for purchase DVD

Date for the started purchase dvd

18

ExpectedDeliveryDate

Delivered date for DVD

The guess date for delivered DVD

19

DistributorName

Name of the distributor

The distributor name which is the mark of the distributor

20

Address

The place where distributor live

The place where distributor live

21

PhoneNo

ContactNo

The connected no of distributor

The No that can be connected with distributor

22

Email

Email of distributor

The email account of distributor

23

DVDID

DVDNo

ID No of DVD

ID No of DVD

24

Quantity

No of DVD

No of DVD

No of DVD

25

Amount

Price per DVD

Price per DVD

26

TotalPrice

TotalAmount

Total amount of loan DVD

Total amount of loan DVD

27

27

ActualDeliveryDate

The date for real delivered DVD

28

UnitPrice

UnitPayment

Price per DVD

Price per DVD

29

SalesID

SalesNo

The ID No for sales DVD

The ID No for sales DVD

30

StaffID

StaffNo

The ID for the staff

The staff no for the staff

31

SalesDate

Date for sales DVD

Date for the started sales

32

NoOfSalesDVD

Total No of sales DVD

Total No of sales DVD

33

StaffName

Name of the staff

The staff name which is the mark of the staff

34

Email

The email of staff

The email account of staff

35

Category

Type of DVD

Type of DVD

Title: DVD Store

Type: Structure

Author: Aye Mya Thidar

Date: 9 Jan 2010

No.

Name

Alias

Definition

Occurrence

Picture

Notes

1

2

3

4

5

6

7

8

9

10

11

Loan

Member

LoanDetail

CopyDVD

Purchase

Distributor

PurchaseDetail

DVD

Sales

Staff

SalesDetail

Hire

HireDetail

Loan=LoanID+MemberID+

LoanDate+ExpectedReturn

Date+TotalNoOfLoanDVD

Member=MemberID+Name+

Address+PhoneNo+Email

LoanDetail=LoanID+CopyNo+

OverdueFee+ActualReturnDate

CopyDVD=CopyNo+Title+Loan

Price

Purchase=Purchase-OrderNo+

DistributorID+PurchaseDate+Ex

pectedDeliveryDate

Distributor=DistributorID+Name+

Address+PhoneNo+Email

PurchaseDetail=Purchase-OrderNo+DVDID+Quantity+Amou

nt+TotalPrice+ActualDeliveryDate

DVD=DVDID+Title+UnitPrice+Category

Sales=SalesID+StaffID+SalesDate+

NoOfSalesDVD

Staff=StaffID+Name+StaffEmail

SalesDetail=SalesID+DVDID+Quan

tity+Amount

Title: DVD Store

Type: Data store

Author: Aye Mya Thidar

Date: 9 Jan 2010

No.

Name

Alias

Definition

Occurrence

Picture

Notes

1

2

3

4

5

6

7

8

9

10

11

Loan

Member

LoanDetail

CopyDVD

Purchase

Distributor

PurchaseDetail

DVD

Sales

Staff

SalesDetail

Hire

HireDetail

Loan=LoanID+MemberID+

LoanDate+ExpectedReturn

Date+TotalNoOfLoanDVD

Member=MemberID+Name+

Address+PhoneNo+Email

LoanDetail=LoanID+CopyNo+

OverdueFee+ActualReturnDate

CopyDVD=CopyNo+Title+Loan

Price

Purchase=Purchase-OrderNo+

DistributorID+PurchaseDate+Ex

pectedDeliveryDate

Distributor=DistributorID+Name+

Address+PhoneNo+Email

PurchaseDetail=Purchase-OrderNo+DVDID+Quantity+Amou

nt+TotalPrice+ActualDeliveryDate

DVD=DVDID+Title+UnitPrice

Sales=SalesID+StaffID+SalesDate+

NoOfSalesDVD

Staff=StaffID+Name+StaffEmail

SalesDetail=SalesID+DVDID+Quan

tity+Amount

100 member currently

Title: Rugby Club

Type: Data flow

Author: Aye Mya Thidar

Date: 9 Jan 2010

No

Name

Alias

Definition

Occurrence

Picture

Notes

1

Order new DVD

Purchase = Purchase-OrderNo +

DistributorID + PurchaseDate

Source : Order Process

Destination : Distributor

2

Record new DVD

Record = DVDID + Title + DistributorID +

UnitPrice + PurchaseDate

Source : Order Process

Destination : DVD Record file

3

Give payment

Purchase = Purchase-OrderNo +

DistributorID + PurchaseDate + Ex

pectedDeliveryDate

Source : Order Process

Destination : Distributor

4

Request for member registration

Registration = RegistrationID + MemberID + StaffID + RegisteredDate

Source : Member

Destination : Registration Process

5

Give member information

Member = MemberID + Name + Address + PhoneNo + Email

Source : Registration Process

Destination : Member Info: file

6

Browse DVD

Search = MemberID + Title + Keyword + Director + Category

Source : Member

Destination : Searching Process

7

Loan DVD

Loan = LoanID + MemberID +

LoanDate + ExpectedReturn

Date + TotalNoOfLoanDVD

Source : Member

Destination : Loan Process

8

Request for overdue fee

Overdue fee = LoanID + CopyNo +

OverdueFee + ActualReturnDate

Source : Give Overduefee Process

Destination : Member

8

Give Overdue fee

Overdue fee = LoanID + CopyNo +

OverdueFee + ActualReturnDate

Source : Member

Destination : Give Overdue fee Process

9

Return DVD

Return = LoanID + MemberID +

LoanDate + ExpectedReturn

Date + TotalNoOfLoanDVD

Source : Member

Destination : Return DVD Process

10

Sale old DVD

Sales = SalesID + StaffID + SalesDate +

NoOfSalesDVD

Source : Sales Old DVD Process

Destination : Member

11

Choose & buy old DVD

Buy = SalesID + StaffID+ SalesDate + NoOfSalesDVD

Source : Member

Destination : Sale Old DVD

Draft-Screen Design (Member Registration Form)

1. Logo of DVD Store System

2. Label to insert the data

3. Textbox and combo box to enter and select data

4. Button to click the event

Prototype (Member Registration Form)

Validation Rules

If the user didn't fill data in data textbox and clicked “Save” Button in making Member Registration Process, the following error message will be displayed.

If data is null in Member Name field, this message box will be appeared.

If data is null in Member Address field, this message box will be appeared.

If data is null in Member Phone No field, this message box will be appeared.

If data is null in Member Email field, this message box will be appeared.

If data is null in Member Fee field, this message box will be appeared.

If data is null in Registered Date field, this message box will be appeared.

If data is null in Registered Date field, this message box will be appeared.

In Member Registration Form, the user can get a new form by clicking “New” Button.

After filling the data in Member Registration Form, the user can save the data by clicking “Save” Button. After that the following message box will be appeared if the data is correct.

If the filled data is incorrect, the following message box will be appeared. (i.e. Filling the data field(Text type) with number format without knowing its data type.

When the user updates data in Member Registration Form, the following message box will be appeared after updating the data.

If the updated data is incorrect, the following message box will be appeared. (i.e. Updating the data field(Text type) with number format without knowing its data type.

The user can clear data in Member Registration Form by clicking “Clear” Button after filling data in data field.

Draft-Screen Design (Loan & Return Form)

1. Logo of DVD Store System

2. Label to insert the data

3. Textbox and combo box to enter and select data

4. Button to click the event

5. Data Grid View to show detail data

Prototype (Loan And Return Form)

Validation Rules

In Loan & Return Form, the user can get a new form by clicking “New” Button.

If the user didn't select Loan ID in data combo box in making Loan & Return Form Process, the following error message will be displayed.

If the user didn't select Member ID in data combo box and clicked “Save” Button in making Loan & Return Form Process, the following error message will be appeared.

If data is null in Member Name field, this message box will be appeared.

If data is null in Member Address field, this message box will be appeared.

If data is null in Member Phone No field, this message box will be appeared.

If data is null in Member Email field, this message box will be appeared.

If data is null in Loan Date field, the message box will be appeared.

If data is null in Expected Return Date field, the message box will be appeared.

If data is null in Total No Of Loan DVD field, the message box will be appeared.

After filling the data in Loan & Return Form, the user can save the data by clicking “Save” Button. After that the following message box will be appeared if the data is correct.

If the filled data is incorrect, the following message box will be appeared. (i.e. Filling the data field(Text type) with number format without knowing its data type.

The user can clear data in Loan & Return Form by clicking “Clear” Button after filling data in data field.

Draft-Screen Design (DVD Search Form)

1. Logo of DVD Store System

2. Combo box to select data

3. Radio button to choose one data of them

4. Label box to enter data

5. Button to click event

6. Data Gird View to show detail data

Prototype (DVD Search Form)

Validation Rules

If the user didn't select Member ID in data combo box and clicked “Search” Button in making DVD Search Form Process, the following error message will be appeared.

If the user didn't select one radio button action and clicked “Search” Button in making DVD Search Form Process, the following error message box will be displayed.

If the user didn't enter the search data in Search textbox and clicked “Search” Button in making DVD Search Form Process, the following message box will be appeared.

(a) ASSUMPTIONS

This DVD loan system is about changing the computerized system from the manual system. To change the computerized system, I have used SSADM technologies and methods. SSADM means structure system analysis and design methodology. This method is very convenience both analyst and users because this method is users friendly. The users can know design by seeing the proposed system. In the SSADM methodology, we have to make the following approach for the giving of the prototype for the users. They are -

v Data flow diagrams;

v ERD

v ELH

v Data Dictionary

The whole system is a little complex in the manual system, so I have a little difficult problem in changing to new system. in task 1, I need to know about process model of DVD loan system and I have to draw a context diagram, aims and objectives and a data flow diagram including process descriptions, dataflow description, data store contents and external entity definitions. For these diagrams, I don't have any problems as I know completely and definitely them. In task 2, I have a little difficulty of designing the entity relationship diagram because I don't know exactly about it to design and a little complex in setting the primary key and foreign key to the associated entity. In task 3, I have to draw an entity life history for a DVD. It doesn't have any problem for me. In task 4, I have to normalize three forms not to duplicate data, such as loan and return form, purchase-order form and sales old DVD form. Moreover, I have to draw a data dictionary entries for all items included in the database design and don't have any problem about it. Task 5 is about a prototype of three forms, such as searching the DVD form, loan and return form and member registration form. I have to check the validation rules for those three forms and print screenshots for the user interface.

Task 6 is about the report and in report there are five main parts, assumption, review of task 1 to 5, advantages and disadvantages of the this system, site preparation for the installation of the system and hardware requirement.

(b) REVIEW OF TASK 1-5

In the first step of task 1, a context diagram is described and followed by aim and objectives of the DVD loans system. Then, DFD diagram is combined by the first step of process descriptions and dataflow description, data store contents, external entity definitions. Analyses of ERD and entity description for all entities are handled by another step which is supposed to be highlighted briefly. Optional ties of each degree of item and formed are assumed as appropriate attributes for all entities including primary key and foreign key. Identifying each relationship between entities is followed by as a next step. Task 3 is about Entity Life History. Task 4 is about to describe a normalization of table showing the processed by ERD and Data Dictionary entries for all items included in the database design. Task 5 is about to a prototype user interface for the DVD loans system including, as a minimum, the main functions.

(c) ADVANTAGES AND DISADVANTAGES

By changing computerized system from manual system in DVD Loan system, the staff and the member can get several advantages as well as disadvantages. Firstly, I will describe it briefly and detailed. In DVD Loan system, there may be many records for DVD, member registration, Loan, Loan Detail, overdue fee, return list, sales list and also order list. For these records, we can't search desired records within a few minutes in the manual system but can be available in computerized system within a few seconds. This is the first advantage and we can save time and effort for search. Another one good thing is that firstly, in the manual system, if the member wants to search the desired DVD, he/she had to tell the staff the DVD name and the staff had searched that DVD by himself or herself in so many DVD list in the record. Moreover, if the member didn't know the DVD name and he/she only knew the actor and actress or director or category in that movie, the staff could have difficult situation to search the DVD that the member want from so many DVD records. But now, this problem has been solved easily and systematically by the computerized system. we provide two workstation for use of the public: the first one is the public work station that is for the member who want to search the desired DVD by using only the keyword, director, actor and actress and the category. So, it doesn't matter if the member doesn't know the DVD name or not and the staff doesn't worry about the case that the member doesn't know the DVD detail and he/she can save effort and time. Moreover, the member doesn't need to rely on the staff to search desired DVD and he/she can browse desired DVD by himself/herself from the public workstation but he/she must register as a member to do such opportunity in DVD Loan System. From another point of view, the staff can record and review the complex loan, loan detail, member list and DVD loan list record from the remaining workstation in the computerized system. Moreover, he/she doesn't need to be worried about the data lost, duplicate data and difficult searching and review of data and updating the desired data. So, these two facts are the advantages of changing the computerized system from the manual system for DVD loan system. on the other hand, there may be some disadvantages of changing the computerized system from manual system for these facts. First of all, when we change the computerized system, the staff could have some difficulty of using the new computerized system because they haven't unfriendly the new system yet. So, the responsible person must call a trainee to give a training and to practice the staff for using the new computerized system correctly and systematically. For this case, the DVD Store owner, can cost a lot of money for training to the staff. Moreover, the owner can reduce the profit and time for giving training to the staff within the work hours. Moreover, to change the computerized system, the owner has to use a lot of money to buy new system and to buy the accessories such as computer, mouse, keyboard, casing box and generators. So, in this year, the owner can cost a lot of money and reduce the profit. This is the disadvantage of changing new system.

(d) SITE PREPARATION FOR THE INSTALLATION OF THE SYSTEM

These are the main stages for the installation of the new system in the DVD Store System.

Hardware requirement

Site preparation

Hardware requirement

Input of current data held in paper records into the new system

Requirements for pre-printed stationery and other media

Staff training

Changeover procedures from current paper system

System Testing

Site preparation,

Planning to get an efficient layout require a great of idea, knowledge and decision of he work for which facilities are bound to be provided. If a new system is regarded as its appearance are not able to accommodate and different from the current layout, it is a good idea to change the office layout at once. Office alternation is necessary to be completed well before the installation of equipment which may be damaged by dust or dampness. Sometimes, large changes may be required and may have to be able to cope with the new system until a future date. But, we can choice the best solution with the reasonable cost which should be consistence with the income of the practice. The comfort and reality as well as safety of the new system are an important role which should be done as first priority. In the veterinary practice system, not every current item and layouts need to be changed. A poor arrangement of office space wastes time and energy and is seemed to lose the communication between staff and customers.

As the office is not easy to go from one desk to another through the office, it is sure that there will be no evidence to improve work efficiency and performance. What is more, it is important not to arrange the office item

at the wrong place such that telephone is on the wrong desk and far away from the reach of the staff, lighting is fade and personal seat are turned back on the counter and under the air-condition and opposed the wall. New office equipment should keep the office flexible, and adjustable for the future changes. Normally, nearly almost of the manufacturers and suppliers tried to produce the office furniture and other accessories things which are designed to be comfortable and efficient of the user. for e.g., Chairs should be the correct height for the type of work being done. They should be fully adjustable, provide of vital importance to a sedentary worker and although many modern office chairs are costly the investment will be more than justified. Desks are also important of overlap, drawer space and whether the locking is necessary and its type of product (e.g. wood, metal, plastic, and veneer.)

Place desk to get a clear sight of view so that light come from the left shoulder for the right-handed person (the right shoulder for the left-handed person). From the point of view of management, trying to provide heating that is acceptable to all members of staff is no easy task. Outside the operation and treatment room in our system, temperature must be about 20C and we should be sufficient electrical outlets and the capacity of the circuit. Basically, heating option will be by gas, oil or electricity. Lighting too has its' problem. While natural lighting is always to be recommended, the DVD Store relies on supplementary lighting to see and read the record clearly, staff will have some problem and the lighting in DVD store should be bright and there is also a generator to supply the Store if the electricity is gone. A final environment consideration worthy of mention is noise. The office noise will come both from outside and within the building.

It is all very well to have a range of up-to-date equipment but it is equally important that working condition is at a comparable standard. It is not so very long ago that office conditions were, on the whole, very poor indeed. Giving that such a high proportion of workers now occupy office-based jobs, increasing attention has been given in recent years to office accommodation and facilities. Not only it is important to view offices in structure and economic terms but also in terms of the people who work there and the jobs they do. A variety of different layouts will be found in offices today but they are still likely to fall into tow broad categories, i.e. closed or cellular offices or some type of open plan. The former are based on the concept of staff occupying separate, sometimes even individual, offices and the work being transacted “behind closed doors”. Offices may be entered either a centrally located corridor or from one running along one side of a building. Such arrangements have the following advantages,

* More privacy

* Persons occupying status positions are easily identifiable improved security (individual offices may be located.)

* Few distractions,

* The possibility exists to control one's own immediate environment in terms of heat, light and ventilation,

* Isolations of noisy equipment

* The ability to personalize one's surrounding.

Design specialists and furniture manufacturers and suppliers have grown in number and there is a wide variety to choose from. Just as color schemes and fashions. Change within the home so, too, in offices, but basically it will be a master of selecting thing which are pleasant on the eye, comfortable and yet practical and businesslike. Carpets are an important feature of most modern offices in that they help absorb sound, prevent heat loss and generally add to comfort. Colors, designs, and textures will be selected with care both to blend with the overall scheme and be sufficiently uniform and easily cleaned. If we assume that the excessive heat is main problem, we may think about how to reduce the heat direct come from the sun. Heat is normally a big problem on hot days when the sun shines through windows and adds to the heart being generated by the machine. Sometimes, stand-clones air conditioning units may be required.

HARDWARE

All hardware that will be installed

The time taken to set up all of the hardware requirements for this new system may depend on each kind of different equipments. Take care and planning of the time must be done with the care before the new system starts. The work performance of the system wouldn't be increased if the new hardware equipment are not available at the time of need are not cope with the new system. If the time is late, it wouldn't be at ease because it need time to be familiar with the new hardware equipment even though (staffs) are well-trained.

Another point is that, before thinking of the changing of office layout, we must need to think of setting up new hardware. If the office has already designed for the new system, it is difficult to install and set up computer accessories and any alternations need to be completed well before the installation of equipment which may be damaged by dust or dampness.

No

Description

1

P4 Casing(Normal Light)

2

Keyboard

3

Mouse

4

15” SVGA digital control color monitor

5

Processor : CPU : intel Pentium 2.66 GHz (1MB L2 Cache, 533 MHz)

6

256 MB DDR RAM (PC 400 Mhz)

7

80 GB HDD (7200rpm)

8

UPS 600 VA (Power Tree ) Classic

9

GIGA 8S648 _ FX 775p 4MB (with sound + LAN)

10

Speaker 180 Watts

11

Floppy Drive (1.44 MB) Mitsumi

12

CD ROM 52X Sony (RW)

Input of current data held into the system

No matter how the data enters to an information system. The concept, sometimes know as garbage in and garbage out is familiar to IT professionals, who know that the best time to avoid problem is when the data is entered. The main object is to ensure that the quality, accuracy, and timeliness of input data. Input process should be effect, timely, logical. Systems analyst apply business proves engineering techniques when studying transactions and business operations to determine how and when data should enter the system. Usually, the first decision is whether to use batch or online input methods. Each method has its own advantages and disadvantages. Using bath input, data entry is performed on a specified time schedule, such as daily, weekly and monthly or longer. Although batch input is used in specific situations, most business activity requires online data entry. The online method offer major advantages, including immediate validation and availability of data. A popular online method is source data automation, which combines online data entry and automated data capture using input devices such as magnetic data strips, or swipe scanners. However, for this DVD Loan System, it doesn't need to have a contact from online user, so using batch input would be batter. Another point is that we must consider to reduce the input volume. To re duce input volume, we must reduce the number f data items required for each transaction. Data capture and data entry require time and effort, so when we reduce input volume, we avoid unnecessary labor costs, get the data into the system more quickly, and decrease the number of errors. What is more, reducing the number of input data errors improves data quickly. One way to reduce input errors is to eliminate unnecessary data entry. The best way to protect incorrect data is to identify and correct before they enter the system by using data validation. A data validation check improves input quickly by testing the data rejecting any entry that files to meet specified conditions.

Requirement for Pre-printed Stationery

In our new system, to replace a pile of paper docunment, we need to have a printer to provide the docunment such as customer invoice as well as supplier invoices and member registration form. So, the printing process is also a must to supply the new system. Printing process have to be done whenever necessary. In the old system, staff have to arrange realy and keep extra forms , so by replcing with working printer, the staff can print as much as they need at any time. From my personal point of view printer CPSON C -59 color pritner and HP laster Jet 1020 printer would be suitable and conviented with the new computerized system. It is also the responsibility of nurse to keep the blank paper to use in printing process.

Staff training

No system can be successful without proper training, whether it involves software, hardware or manufacturing. A successful information system requires training for staff in this system.

The main objective of effective training is to educate the relevant works and duties of stuff have to deal with the new system. Beyond that, an regular arranged training need to have not only the full meaning of understanding roles and responsibilities but also checking to make sure that stuff are really eager to meet with the new system. Introducing new system cost money in terms of both tangible and intangible benefit including software and hardware as well as other necessary equipment and the fact that the current work will delay and no proceed as before. It is just because not only staff ill no able to carry out the duties as much as before as they have to give the time for training but also they are worried and afraid of using a new system in a new way of with the introduction of new office layouts. In reality, training should not be too early because it can lead to nurse forgetting some of their newly acquired knowledge before the project starts. Choosing the best relevant time is also important in training session. If the introduction is presented in large amounts, they user might become confused and the training sessions would be meaningless. If it is decided to start early, it might be possible and user might have forgotten the important roles and responsibilities of new system before implementation. If it is too late, too much information must be digested in a short time, and if procedures prove confusing, there will be no time before implementation to modify them.

The entire system development effort can depend on whether or not people understanding of the system and know how to use if effectively and beneficially. We should start to consider a training plan early in the system development process. As we create documentation, we should think about how to use the material in future training sessions. When we implement the system, it is essential to provide the right training for the right people at the right time. The first step is to identify who should receive training and what kind of training is needed. We must look carefully at the practice how the system will support business operations, and who will be involved or selected. We must notice that each nurse needs a mix of general background and detailed information to understand and use the system .Among a wide variety of training method, I assumes that group training method which makes the most efficient use of time and training facilities is an effective method. As there are only three staff in the DVD Store, group is small, so trainers can learn the system together by asking questions and from the problem of each other. A training program must indicate the job interests skills of a wide range of participants. Problem often arise when some participants have technical backgrounds and others do not. However, it is sure the training will not meet every staff's needs. Training requirements are not difficult to decide. They will appear significantly from the new system to be installed and those people who will be affected by it. However, the time for determining should no be public holidays and we must consider their availability and freedom. Actually, the responsible person or supervisor should be trained first and may possibly train their stuff themselves (with the system analyst in attendance. Training should be done frequently and not taken long for each session. It is also the duty of the trainee to explain why the task is being performed and persuade the trainer to be involved in the new system himself or herself.

Changeover procedure from current paper system

After the system testing is complete, it is important to make a step to change the annual document into the computer system. First of all, it is generally accepted that who will involve changing procedures.

Therefore, it is an agreeable point and the responsible person who has headed the new system should inform the important facts to the person who will use the system later. The important procedures are as follow.

How - How the new system will change the paper document into the computer.

What - What type of data will be stored into the new system or what are the type of paper document will continue and follow as usual.

Who - the people who are involve in changing procedures. The new system is designed to record all of the information which might have stored from the beginning of the old system. Therefore, choosing the people to deal with the secret data is the main fact we have to think before making identifying the time to change the procedure. We need to think the responsible person is really reliable or trustworthy or skillful. If something is happened, what would be happened as a result of it and how can we make it recovery and how long it takes

When- After we have chosen the people to change the data from the old system to the new computerized system, we have to discuss with the responsible person to identify the time when would be convenient and consistence with the stuff and we have to input the fact such as their freedom and availability. Especially, time should be neither too late nor too early. For the DVD Store system, it is sure that time for changing the data would be a little longer because it is neither too large nor small. Another important point is that data changing will be started before the practice is open or out of office hours and shouldn't be on public holidays. If out of office hour, what we need to consider is the reliability of stuff and data may be lost because of the carelessness of the staff.

Where - A place for data changing procedure from current paper system should be first secure and reliable. First of all, it has to be neither too hot nor too cold and to be comfortable and adjustable. What we have to consider the appearance of the room where we chose for changing procedure such as the work stationery chairs, tables, and electronic devices and know how they work together.

System Testing

Sucessful completion of system testing is the key to user and management aprroval, which is why system test sometimes are called acceptance tests. Eveyr error caught during testing eliminates potetial expenses and operaitns problem . Acutally, not eveyr systme is 100 per cent error fee. Often there are many event where the erros go undetected until the system becomes operational. Minor erros, such as typographical erroes in screen titles, can be corrected later. It is also the final stage of validation and involves the entrie information system. A systme testing, which involves the entire information system which involves the entire imformtoin system, include all typical processing situations. During a system test, entere date , including sampels of actaul, or live data, performs queries, and produce reports to simulate actual operating coditins, All processing options and outputs are verified by nurse (user ) and IT project development team t ensure that the system functions correctly. Sytem testing has the following major objectives. Perform a final test of all programs to make sure that staff (user ) has the docunmentation and instructins needed to the system properly. Demonstarte that staff (user)can inteact with the system successfully . Confirm that the informaiton system can handle predicated values of data in a timely and efficient manner

REFERENCES

Book Reference

1. Business System Analysis NCC Education

Author: NCC Education ISBN: 1-90234-348-4

2. Business System Design NCC Education

Author: NCC Education ISBN: 1-90234-349-2

3. Microsoft Visual Basic.Net NCC Education

Author: NCC Education ISBN: 0-619-15970-7

4. SSADM Version 4 A Practical Approach

Author: Gookland, Mike 1954 Slater, Carolne 1957 ISBN: 007709073X

Websites Access Date

1. http://www.vbdotnetheaven.com 2/11/2009

2. http://msdn.microsoft.com 31/12/2009

3. http://www.c-sharpcorner.com/CrystalReports.asp 1/1/2010

4. http://codeproject.com 3/1/2010

5. http://www.freevbcode.com 4/2/2010

6. http://www.crystalreportsbook.com 7/1/2010

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.