Video rental and sales system

A dissertation submitted in partial fulfilment of the University of Greenwich’s

Bsc (Hons) Software Engineering

Abstract

In the current business functions, an especially rental resource is on of the main challenging part. So that, utilising the resources that are implemented by the companies. The business processes are the major task according to the project budget as well as time limitation. So that software solutions those managing and controlling the functions has to be analysed in a proper way to obtain the successful use of them. The report illustrate about the project that analyse the problem of renting and how to gain the solution for those procedures. Video rental and sales is a complete software solution for controlling and managing rentals of customers. This research is all about controlling and managing resources for everyday rentals. Based on the client needs the resources could be rented. An excellent desktop application has been processed and implemented in order to manage that resource that is currently used by the video rental system. This system solution has been implemented using the technologies of front-end Microsoft Vb.Net and back end SQL Server.

Preface

This thesis is partial fulfilment of university of the Greenwich undergraduate programme, prepared and submitted by me. This software project helps me a lot to gain knowledge in different parts such as software design and development.  During this project research and development period, I get the clear understanding, how these software engineering principals, technologies can be applied in real time projects. This project approach as a practical way in all stages of software development and make me clear in every stages that software engineering techniques could be applicable.

  I am a software engineering student. In this case, this project is closely related to my programme of study and other subjects. My current study is helps me each stage of this project such as system analysis, designing, coding, testing, implementing, Etc, to a develop a final solution for this business.

I use MicrosoftVb.Net programming language in order to develop the proposed system. I implemented desktop application the help with Microsoft.net framework based on the customer requests. Moreover this project gives some ideas to access the a range of software engineering techniques and tools for the successful project.

Acknowledgements

This work carried out for this project would not have been a success without the good guidance a given to me by various people and various time. There are many people helped me. First, special thanks to my project Supervisor Mr. Alexander M. Fedorec and Second Marker. Who helped me in the literature review part and guide me to get the Approval for the Ethical Research application. His comments and guidance helps me to make this report according to a professional standard.

My thanks to all the lecturers and University staffs specially library staffs who guide me to get good online journals from the Student portal. In addition, thanks to the authors of articles and magazines which are really helps to my final Document. At last, I wish to thank my Colleagues, their reviews and proof reading about my project helps me to do  more reliable and useful last time.

1 Introduction

1.1 Background Information

At present world, widely the uses of software solutions for the companies are considerably increased. The reason is they might get whole solution for their entire services in a single software application rather than doing sub services. It will save lots of money, time and human resources, etc. Therefore most of companies are likes to computerize for their business operations.

The melodius company Current situation is they do not have any improved technology. They are spending a lots money, time consuming, extra workers, etc to run their business operations. As a result of these the melodius company has decided to computerize their business. They are trying to make a new revolution in the video rental market.

1.2 Overview

The melodius video rental (pvt) Ltd started its business operations as a small size in 2000.And gradually extend out their business to length and breath. Video rental main purpose is renting and selling Video DVDs, Audio CDs, etc. Purchase the products from the supplier and Allocates the products (CDs, DVDs) for sales and rental is the main area of concern for this company. Each staff of the company from top level to bottom level has a typical, free and unique role to play for their company needs.

If we have a look in the project proposal ,the main aim of this project is carry out a deep investigation about rental, sales operations and resources allocation for an integrated Movie rental and sales system.

The proposed software package gives some improved facilities to the Staffs and the users

To run their business smoothly. This could be an entire solution for movie rental and sales functions problems. According the company needs operations are able to divide in to two main types. Such as Sales and Rental. At present the company keeps all the paperwork’s, documents in manual form. The Following modules are currently in process in the system, Member, Employee, Supplier, Sales, Rental, Payment, product.

These existing operations are linked to each other of the modules. Due to these reasons, management faces lots of difficulty. Generally, the overall existing system is slow and unsystematic. The current system and those issues have driven to the top management (Owner of the business) in order to choose for an alternative option. That will enable the company to improve its operations and good progress.

There for the management has decided to computerize their existing manual operations.

Here my duties and responsibility was to develop a video rental system and sought out these kinds of administration problems, give freedom to the management level people and let them do their central part activities. Moreover, giving an excellent customer service and user friendly product.

1.3 Scope of the project

At present in real world, the new technologies are developed in every field. According to these changes, we have to adjust our business activities. This project overall target was design an excellent desktop application and implement for the melodius video company. This helps a lot to the Management and the staff to work for this company freely and pleasurably.

The main purpose of this project creates a user friendly, unique and modern software package.

With higher security facility (User levels, Password encryption). Make easier to use the forms with navigate Buttons.

User could feel free and comfortable when he uses the system.

1.4 Aims and Objectives

When the project was begun its cover the whole business operations and benefits of the system. In order to achieve these benefits a few objectives were initialized. Such objectives are.

1. A deep investigation about the existing manual system and their accessible process measurements.
2. Write  a system analysis report based on the system requirements
3. Understand the requirements and the principles when developing a software application
4. Design and develop a video rental system using software engineering techniques.
5. Testing the video rental system using available accessible data.
6. Evaluate the final product and think about new ideas to improve further development.

1.5 Project Management Methodology

The successfulness of the project is depends on the selection of the technology, tools and how we are applied in the project. If we take our project, it was a long-term project and its takes more than six months time. The traditional waterfall model is most suitable for long time projects. According this project the waterfall model is most suitable.

The following reasons are easy to identify the requirements that enable to develop the system is In. We require a life cycle system. That is before being the system; the requirements are studied through the interview. It is not need to make the changes in the system and it is not advisable while creating the system or modifies the system.

Hence since the steps to create this system is in co-ordination with the waterfall model. Therefore I have chosen this waterfall model. Which is follows.

The Waterfall Model

Each stage related into the next

Feedback in the Waterfall Model

The Advantages of using waterfall model is By far the most commonly used approach up to now.

The waterfall model underpins all the most widely used methods. The stages are clear-cut.

The innovative ideas were behind that documents are produced at each stage

Consequently preferred by managers as easy to manage.

All research and design done before coding starts, it means better quality program design.

Well suited for developing stable and well understood computer-based applications.

Feasibility study

This feasibility study main aim is depth analysis and decides the melodius video rental company and about its businesses operations whether it will be operationally, financially or technically feasible to develop the software product. These studies involve analysis of current issues and gather the relevant information’s. Here I have selected three important types of studies for measure the system success as the operational feasibility, technical feasibility, and economical feasibility.

Operational feasibility

The operational feasibility is discuses about the company performance, information, economy and control.

1. The management is not happy with existing the manual system. Because that is very slow and it is having many mistakes. So he doesn’t like to work with the manual system.

2. The manager is unable to produce the day to day transactions and other business information from the departments.

3. They have to spend more time consuming to send information and to get information from the other departments.

4. Receipts or invoices are not in a clear format, when giving after the business transaction to a customer or supplier.

5. The economy level is poor which means it’s hard to get good benefits from the system. Because of the resources (Rental, communication, and electricity bill) cost is very high now days. For these reasons they have to reduce the cost. In order to increase the benefits.

6. The business data’s handling is not a secure way. Anyone can handle the records. And higher possibility of data loses.

7. The management have to spend more time to search the information and produce the reports about their transactions.

8. The existing manual system is not flexible and more complicated there for they must have to computerize the existing system.

Technical feasibility

The technical feasibility analysis, what the technical resources are available in the system, and what are the technical resources are need for the new computerized the system.

Available technical resource:

Air conditions facilities, Fans, Tables, Chairs, Shelf’s

They have limited technical resources. Earlier they have done all operations manually so they didn’t need any technical resources. When they have work with computerized system they must need some all the relevant technical resources and the trained staffs. Following resources are needed in order to develop the system.

• Computers
• Processor: Pentium 2.2GHz or more
• Hard drive: 40GB or More.
• RAM: 512MB or more.
• Network cables
• switches
• CD-ROM drive.
• Monitor 15′ colour
• colour printer & black white printer
• Software requirements:
• Windows operating system.
• Special software for sales & rental
• Microsoft Visual basic .Net
• SQL Database

Economical feasibility

The economical feasibility analyses about the cost and benefits of the company existing system and proposed system. Such as Software development coast, Hardware coast, as well as the system running coast.

Schedule feasibility study

The aim of the Schedule feasibility is analysis the planning and assessing the time period for the completion of this project

Analysis-This analyse part, the problems and objectives were identified and the user requirements for the project. It takes two weeks time.

Design-Based on the user requirements this part focuses on the system design. It could be divided in to two main parts. It takes three weeks time.

Development-This part took six weeks time to develop the software product.

Testing-In this testing part, two testing types took place. First, is unit testing and second is Acceptance testing in order to find out errors and solve the errors. This takes one weeks time.

Implementation-The implementation section will show how section implemented. This takes one week’s time.

Maintain-This part checks the objectives of the project and that it has met the user requirements. And this tells the project successfulness.

2 Literature Review

2.1 Introduction

A large amount of analytical and theoretical works discovers new things, thorough that can encourage Effective improvements. However, it is essential to study the direct connections based on observation and research in order to get in to the related various type of efficiency achievements.

In this literature, review I analysed based on research and observation straight away in the video rental business in order to find the key points and drawbacks.

”At presents the video rental business being the main topic of deep concern from the operations management community (Drezner and Pasternack, 1999; Dana and Spier, 2001; Pasternack, 2001; Lariviere and Cachon, 2002)’

Re: – Coordination of quantity and shelf-retention timing in the video movie rentalindustry
Gerchak, Y; Cho, RK; Ray, S | IIE TRANSACTIONS | 2006-0738:7, | 525-536 | Description: Times Cited: 6

Because people are thinking now a day’s home video is very good leisure and it is a valuable entertainment expenses, which is make movie rental as a big business.  Normally video DVDs or CDs available on hand to the public, after a few months from release. These materials are available to public in two ways; first one is renting DVDs or CDs from rental Stores second one is selling DVDs form Retail Stores. My project deals with both Rental and Sales. According this system three main type of people will work

Admin and staff who control the system.

Supplier who providing the resources (CDs, DVDs)

Member who renting or buying the CDs.

Normal Customer who only buying CDs

Company’s main focus is video rental and sales. Currently the company give services to their customers through their manual system and handling all the transactions by manually. It’s inconvenient to the customer often. For this reason the company has lose the customers in past and their turnover is shrinking when compare other stores.

So the management has decided to computerize the transactions instead their existing manual system in order to give the efficient and improved services to their customers.

This literature review will carried out the problems and make sure the work is going right way and valuable.

Problems identified in the current system

1. Handling customer

They are handling their customers manually. This will cause them difficulty and time consuming to search a Customer card. In case if a record has not been entered in to the required file or a book, there may be some disagreements between the customers and the employees of the company. This leads to shrink the fame of the company.

Solution:-Handling and maintain of the customers in a glowing comportment.

2. Maintaining the sales records

The sales records of the company are not kept very effectively. Records cannot be easily track in case of future reference. The company cannot have a well planned future business because it can’t go through the past records and most of the records are not very accurate.

Solution:-Well organized method of handling of all the sales.

3. Maintaining the information of their products

The details of their products are not kept in a well organized manner and cannot be referred when needed. The products sold, and the stock balance is not easily tracked, hence the shortage or some time certain important products maybe out of stock, then in such a circumstance customer satisfaction will be very much reduced.

Solution:-All the products and its brands are clearly following a path.

4. Problems on maintaining the Payment

Sometime they may ask the customer to pay for one product twice by mistake, such incident will make to shrink the good relation and the trust of the customer, making to lose customers confidence as well loosing the customer.

Solution:-Product balance can be tracked time to time.

5. Maintaining the supplier information

There would be a lot of suppliers. It’s difficult to find a supplier detail without being delayed or maybe in some cases they might loss a contact detail of a particular supplier, which might be an important contact for a special product or a Brand, loosing this sort of information will make the company to have problems of finding products of famous brands.

Solution:-All the supplier information will be collect then and there.

6. No updated information available

Updated information is not very easy to provide to customers if the company runs manually.

Solution:-Brands and latest editions that are being handled by the company can be tracked without doubt.

7. Payments can only be made by cash or credit payments

Running manually, the company could have only the payment methods of cash and cheques. This is a great disadvantage for the customers who use the credit payment card.

Solution:-Payment can be made in cash or credit, and efficient and quick service can be provided.

8. Problem:-Dissatisfaction of customers

While the business is running on the manual system, the customers would not be satisfied of the services provided to them. They might have to wait in a long queue to pay for the items they bought. This may be due to the absence of the employees or maybe due to the slow system of the company.

Solution:-Membership form will be filled automatically, according to the sales that are made and this would only be for the required sales.

Some additional solutions

• Make sure the integration, integrity and independently for the video rental system and reduce as soon as possible changes for human errors by introducing database concepts.
• Introduce high secure functionality. It is important that customers and the suppliers’ information be prevented from leaked out.
• System will also enables the management to do accurate calculation as well as obtain reports such as total income for the given time period.
• Better utilization of storage space. Doing away with manual will reduce the space taken up by the data storage. This can be utilizing the better for other purpose.
• A comprehensive project database that act as a central repository to track the below mentioned needs.
• Define work in progress.
• Easy access for the items short shipped on the order.
• Easy to scheduling and tracking records
• Easy of maintaining, schedules, monitoring, reporting of progress.

2.2 Legal Social Ethical and Professional Issues and Considerations

In this project, I am used copyright material, such as Microsoft products, and Adobe products. I’m used university of Greenwich licence to use the other related soft ware’s. As a university student, I have the rights to use university resources.

Some Interviews and questionnaire done by me with Owner of the business, staffs and some customers. In the project there are no any personal data’s did not collected. Therefore, the data protection will not affect my project. All the collected data is stored in my personal computer with password protection. All the information will be deleted after completion this project.

4 Requirements Analysis

4.1 Introduction

When consider about software development projects, requirement analysis is a most important part. In this part, be able to collect information’s together about current situations in order to indentify the drawbacks about the system. This requirement analysis should be correct, testable and relevant to the company requirements. Moreover, it must be significant to system designing part.

4.2 Requirements Gathering

In this part requirements can be collect in to the system boundary by contact the users to find out their requirements. In this part used to gather different types of techniques such as interviews, questionnaires, observation, etc…

4.2.1 Questionnaires 

Questionnaires are quick gather information from large amount of people in a certain period.

It is possible to do paper based document either electronic copy. In addition, it is very cost effective method when compare with interview. Major advantages are most of the people are familiar to questionnaires and very easy to analyse. 

This questionnaire has been used to gather information’s from the customers.

Questionnaires with customers

  Melodius video

1. Role of person completing this form

a. Manager (other company) b. Administrator

c. Computer Programmer d. Customer

2. When you contact a “melodius video” representative, is he/she courteous?

Are you satisfied with the way your problems or questions are handl?

a. Most Satisfiedb. Satisfied

b. Ok c. Dissatisfied

3. How you feel other music centre compared to “melodius video”?

a. Excellentb. Very good

c. Good d. Poor

4. How do you feel when you pay by using the membership card?

a. Most Satisfied    b. Satisfied

b. Okc. Dissatisfied

5. Who is the person in our organization you contact most frequently?

a. Company Owner  b. Sales men

b. Manager d. Others

6. How you are, feel about our payment system?

a. Excellentb. Very good

c. Goodd. Poor

7. Comments (Please write us on the back of this form)

Questionnaires with customers

Answer sheet

Melodius Video

1. Role of person completing this form

a. a. Manager (other company)-16  b. Administrator-5

b. c. Computer Programmer-3 d. Customer-26

2. When you contact a “melodius video” representative, is he/she courteous?

  Are you satisfied with the way your problems or questions are handle?

a. Most Satisfied  -5   b. Satisfied-15

b. Ok -25   c. Dissatisfied -5

3. How you feel other music centre is compare to “melodius video”?

a. a. Excellent -15 b. Very good-10

b. c. Good-20 d. Poor-5

4. How do you feel when you pay by using the membership card?

a. Most Satisfied  -10  b. Satisfied-12

b. Ok -8 c. Dissatisfied-20

5. Who is the person in our organization you contact most frequently?

a. Company Owner -6   b. Sales men-24

b. Manager -10  d. Others -10

6. How you are, feel about our payment system?

a. a. Excellent-5 b. Very good-5

b. c. Good -15  d. Poor-25

7. Comments? (Please write us on the back of this form)

4.2.2 Interviews

Interviews are one of the most common and powerful techniques to find out the requirements. This brings to face-to-face contact with customers or staffs to discover their requirements. And interviews are makes a higher response rate. Also, make clear about doubts and make sure that perfectly understood by repeating questions.

Appropriate People

1. Company Owner

2. Company manager

3. Payment Division manager

4. Stock division manager

5. Purchase division manager

6. Sales division manager

7. Lending manager

Interview with Company Owner:

Objectives:

1. Get the permission to analyze the system.

2. Identify the people who are participating the system.

3. Study about the problems of the existing system.

4. His/her expectation about the new system.

Questions:

1. What are the major departments you have?

2. What are they doing?

3. What are the problems are you facing with in the current system?

4. How should be the proposed system?

5. What are the facilities you want to include with the proposed system?

6. Do you have enough money for the new system?

Interview with Company manager

Objectives:

1. Study the problems with the existing system.

2.  Study about manager work.

3.  Study about what are the difficulties he/she facing his/her work.

4.  Who are the people involved with each departments

Questions:

1. How you are working for current system?

2. What are the problems you are facing for the current system?

3. Are you satisfied with other staff work?

4. What are you expect of the new system.

Interview with payment Division manager

Objectives:

1. Know the problems with the existing payment system.

2. Study about his/her work.

3. Identify the difficulties with his/her work. 

Questions: 

1. How you are working for existing payment system?
2. What are the problems are you facing for the current system?
3. When more customers come to make the payment, can you manage?
4. How will your action if a customer is not made his payment?

5. How you handle your payment database?

Interview with stock Division manager

Objectives:

1. Know the problems with the existing payment system.

2. Study about his/her work.

3. Identify the difficulties with his/her work.

Questions:

1. How you are working for existing system?

2. What are the problems are you facing for the Stock activities?

3. When more and more items come to the stock, how can you handle?

4. Do you like increase stock division people amount? What are the reasons?

5. How you handle your stock database?

Summarize of the interview

Interviewer: Company owner

Subject: Study of the company

Duration: Two hours

Mr. Thanushan is the owner of the “melodious video” company. He likes to build the manual system to the computerize system, because the company staff have to work quickly and accurately. For that, he is satisfied to have a centralized database. He is not satisfied to have an online computerize system. In addition, he likes to have good quality software for the company sales, inventory& rental activities.

Thanking interview.

Interviewer: Company Manager

Subject: Study of the complete system

Duration: Two hours

Mr. David is company manager. He likes to work with computerize system, because the company staff have to work quickly and accurately. In addition, he is unable to get the information from the sub divisions. He is not satisfied to have an online computerize system. Moreover, he likes to have good quality software for the company sales, inventory & rental activities.

Thanking interview

Interviewer: Payment division Manager

Subject: Details of the payment system

Duration: Two hours

Mr. Suresh is the manager of the payment division. He likes to work with computerize system, and centralized database system, because he feel very difficult to work with the manual system. In addition, he has to generate the report quickly and accurately.

Thanking interview

Interviewer: Stock Division manager

Subject: Details study of the stock activities

Duration: Two hours

Mr. Rohan is the manager of the stock division. He likes to work with computerize system, and centralized database system. Moreover, he likes to increase the stock division employees. In addition, he likes to have more shelves to keep the stock. Because he have difficult to keep the items without damages and the staff have to spend more time to find out the place of the items.

Thanking interview

Interviewer: Purchase division Manager.

Subject: Details of the purchase activities

Duration: Two hours

Mr. Kishan is the manager of the purchase division. He likes to work with computerize system, and centralized database system, because he have to work quickly and accurately. And he likes to purchase the cds from good quality Product Company. For that, he likes to contract some good quality companies.

Thanking interview.

Interviewer: Sales division Manager

Subject: Details analysis of the sales activities

Duration: Two hours

Mr.Roys is the manager of the sales division. He likes to work with computerize system, and centralized database system, because he have to work quickly and accurately. And he has to have a relationship to purchase division. And he has to generate the report quickly.

Thanking interview

Interviewer: Lending Division manager

Subject: study about lending activities

Duration: Two hours

Mr. Jude is the manager of the Lending division. He likes to work with computerize system, and centralized database system. In addition, he likes to have more shelves to keep the Cds. Because he have difficult to keep the items without damages and the staff have to spend more time to find out the place of the items.

Thanking interview

Common meeting with cashiers and salesmen;

Subject: details analysis of the system

Duration: One and a half hours

They like to work with the computerize system, because they are unable to work quickly and accurately.

They have to give a clear invoice bill to the customers.

They are unable to handle the return items quickly.

And most of the cashiers have an experience with computerize system.

Thanking meeting.

4.2.3 Observation

The observation is one of the research methods. It has been developed to observe the people. The main purpose of observation is focuses on their usual daily activities.

Objectives:

• Find out the problems
• Know the customers anticipation

When I observe the company activities, they are unable to work quickly, because of the manual system. And the customers have to wait for long time to make their payments. In addition, the customers were asking about the bill, because the bill is not clear. The staffs are unable to manage the customers, because the staff’s amount is not enough.

4.2.4 Functional specification

Functional specification is like documentation and it has explains the expected features of the proposed system. In addition this document further explain the sub functions of the system such as customer registration, purchase movie, Sell a movie, Rent a movie, Return. Etc.

Functional requirements

Staffs must be able to create login account and register.

Staff should be enable to do add or edit functions, and must be disable for data delete function.

I found out the major functionalities according to the staffs requirements.

1. Customer Registration

If a customer wants to be a member, the person should be able to register with some details such as name, address, phone number etc.

2. Place an order

Make orders according the less stocks and place them to a supplier.

3. Purchase products

If supplier accepts the order, purchase the products

4. Allocate products

Allocate the products for sales separately and rental separately

5. Sales

After the allocation of the products sales could be done.

6. Rental

Member customers only lend the CDs

4.2.5 Non Functional requirements

1. The system should be user friendly and attractive.
2. Interface should content navigation buttons.
3. According the process data System should provide high performance with in minimal time.
4. If the System needs any new requirements, the must be easier to maintain

4.2.6 Summary

This chapter describes a detailed study of the requirement and analysis part based on the customer information. Next chapters are talk about how did these changed to executable code during user design and implementation part.

5 Design of the System

5.2 Designing part of the Product

5.2.1 Introduction

This part contains screen shots and describing of the main functions of the system. This screen shots gives idea how main functionalities of the system are divided and how are they assemble the fully functional system.

User account creation

Administrator and Staff are the two user levels.

1. Type the relevant user name to login the system
2. Admin
3. User
4. Type the relevant password in to the password field
5. 123
6. 456
7. Click on the Add button. If login successful the following message will be appear.

These are the main procedures and its can handle by the administrator or the staff such as.

1) When new customer registers for the membership enter the customer details in to the system.

2) When new supplier registers in to the system enter the supplier details.

3) Add the movie, album, or audio cds details into the database when purchase new products.

4) Allocate and enter the cd details in the system when purchase new cds for the purpose of lend or sell the movies.

5) When sell the cds or the albums enter the sales details.

6) When customer lending cds enter the cd details.

7) When cds returning from the customers enter the return cd details.

8) Create new user accounts and choose the login password according the job level (Admin/ Staff).

9) When leave the system Click the Exit button and Ok button.

Actor Adding

Actor id will be automatically generated.

Enter the New Actor name and then click the Add button.

Note: – This actor name will be loaded to Actors combo box in to the Add movie form.

If enter again same Actor name the system will through a warning message bellow. All forms are validated.

Actress Adding

Actress id will be automatically generated.

Enter the New Actress name and then click the Add button.

Note: – This actress name will be loaded to Actress combo box in to the Add movie form.

If enter again same Actress name the system will through a warning message bellow.

Employee Registration

Employee ID will be automatically created.

Enter the First, Last name and address.

Select the gender and enter the phone numbers, these should be numeric values because these boxes are validated to accepted only numeric values.

The date will be show present date.

The following warning message will be appear if enter non numeric values.

Click on the Add button.

Employee registration Edit

If you want edit these Employees records, you can search by name, Id, or All Employee details by tick the relevant fields.

Delete Button will be Disable for the normal staff. It can be access only by Administrator.

Select the records which you need and click on the Edit Button.

Then the following form will appeared for editing

After the editing details click on the Update button.

Member registration

Member ID will be automatically created.

Enter the First, Last name and address.

Select the gender and enter the phone numbers, these should be numeric values because these boxes are validated to accepted only numeric values.

Date will display the current date.

Select the membership duration, two years or five years, membership fees and membership expire date automatically displayed.

Click on the Add button.

Member registration Edit 

If you want edit Members details, you can search by name, Id, or All Member details by select the relevant fields.

Select the records that you need and click on the Edit Button.

Then the following form will appeared for editing

Click on the update Button after the Edit member registration form.

Supplier Registration

Supplier Id will automatically generated.

Enter the supplier Name and the address.

Enter a numeric values to the telephone and fax fields.

Enter a valid email address (should contain the @ sign)

Current date will display.

Click on the Add button.

Supplier details Edit

If you need edit the supplier records, you can select either by Supplier id,Supplier name or All supplier.

Select the records that you need and click on the edit button.

Delete Button will be Disable for the normal staff. It can be access only by Administrator

Then the following form will appeared for editing

Click on the update Button after the Edit supplier registration form.

Adding Movie

Movie Id will be automatically generated.

Enter a movie name in to Title field, Select the appropriate media type, movie catogery, language, as well as the Actors and Actress names.

Type the Directors, producers, music directors and the technician’s names in to relevant boxes.

Click the Add button.

If data successfully add in to database the following message will displayed.

Order Form

Order id will generate automatically.

Select the supplier and video no from the combo boxes.

Then the title of movie automatically loaded in to title field.

Enter the amount of movies and fix the unit price after that press the + sign.

It will add the items to the grid view.

Click on the Add button.

Purchase Movie

Purchase no will created automatically.

When you Select the order no then the supplier details and ordered date will display.

Also ordered details, Quanity and unit price loaded in to the Ordered item grid view.

Note:- if we want we can change the quantity and unit price.

Then click the + sign button.

Now selected movies come to Selectetd  item grid view.

Click on the Add button.

When Select the video no the title of the movie has to be loaded automatically in combo box.

Then define the amount of copies for rental, rental duration,coast(per day) for each copy.

Click Add button.

Select the member name, member id will be automatically created.

Movie could be selected by, movie no, title, All movie options

Then click the rental button.

Click on the Add button.

5.2 Technical Design of the system

5.2.1 Introduction

Technical design of the system contains the entity relationship diagram, use case diagram, data flow diagram etc. These kinds of technical design diagrams made from the user requirements, which are gathered from requirement analysis part.

5.2.2 Use case diagram

The Use case diagram created based on the system main functionalities. These are already identified from requirements specification. This diagram gives a summary of the main functionalities and who are involves with these functions.

6 Development of Product

6.1 Introduction

The project was developed and implements a software solution for the melodius video sales and rental business without any issues. This chapter explains such technologies used for development and their benefits for handling the resources as well as time saving. In this project Vb.Net and SQL are used Vb.net as a programming language SQL as a database.

6.2 Implementation of a d

3 Evaluation

Introduction

When evaluates the system it based on consider both usefulness and achievement. Even though the use fullness of the proposed system is more important rather than the system development cost. However proposed system must be use full than the existing system. Because evaluation only be depending on the successfulness and reliability of the system.

Unit testing

The purpose of this unit testing is evaluates the functionality of the product .it means checks and make sure that there are no errors in the input data’s. During the system implementation unit tests consequently performs in order to ensure the error less final system.

The methods and the attributes were make sure that they work according the requirement specification. The quality of the system successfulness depends on achieve from the testing part and client satisfaction. Testing part technologies and tools are offered from Programming Integrated development environments.

4 Conclusion

Introduction

This conclusion part contains the most important functions, which were received during the overall project development and how the objectives have been gained during the whole stages of the project. The key review of the project describes the factors, which have been offered the negative contact to the project during the stages was undertaken. It also describes what the existing problems of the project are and how it can be decided in future.

Summary

This project could be judge a successful project because according to the software engineering tools and technologies has been applied during the development time and this project meets all its client requirements and Specification. There for this Project could consider as a good project.

The development methodology was waterfall method; this development method was very support to me to implement the project with limited time duration.

This waterfall method that I have used, help me to work out for small development life cycles. In addition, these methods help me to correct the system errors, which found the earlier stages. Advanced the usage of the prototype allowed me to implement a functional model of the video rental system. Therefore the user rechecked the requirements of the rental system when was the prototype was implemented.

Future Plans

According to the user, requirements this project was successfully achieved all the objectives. In future, the system should be move on to the Enterprise application level.

Solution for the future plan

At present, the use of World Wide Web (WWW) suddenly increased. The use of internet gives lots of facility to the users such as time consuming, saving money, reduce risk and etc. There for we have to change our business activities according to the new environment.

Bibliography

Appendix A – Project Proposal

UNIVERSITY OF GREENWICH

Melodius

Video rental and sales system

Name: Amalan Perinparaja

Student ID: 000434254

Programme of Study: Bsc (Hons) Software Engineering

Date Proposal Submitted: 14/12/09

Project Hand in Date: 20/03/10

Supervisor: Mr.Alexander M. Fedorec

Keywords associated with the project:

1. User

2. Video rental

3. Video sales

4. Return

5. Fine

6. Order

7. Purchase

Introduction

“MELODI US VIEDEO” Centre is most popular selling and renting movie, music cds and DVDs. This company situated Wimbledon and established on 23rd Jan 2000.  Their existing manual system is conventional and cumbersome. Company Manager of the Mr. Kajan Managing this company. There is doing all the transaction doing by manually, therefore the management decided to computerize the system.

Current system

The company’s main focus of business is sales and CD rental. It has a good reputation among the public and it attracts more customers. Presently this company is providing services to customers through their manual system. It is inconveniencing the customers very often. Due to this company is losing customers for the past three months and company’s turn over seems to be poor compare to previous months. Therefore, company has decided to computerize their manual system in order to provide efficient services to its customers.

Problems identified in the current system & proposed solutions

1. Problem:- Handling customer

They are handling their customers manually. This will cause them difficulty and time consuming to search a Customer card. Incase if a record has not been entered in to the required file or a book, there may be some disagreements between the customers and the employees of the company. This leads to shrink the fame of the company.

Solution:- Handling and maintain of the customers in a glowing comportment.

2. Problem:- Maintaining the sales records

The sales records of the company are not kept very effectively. Records cannot be easily track in case of future reference. The company cannot have a well-planned future business because it cannot go through the past records and most of the records are not very accurate.

Solution:- Well organized method of handling of all the sales.

3 Problem:- Maintaining the information of their products

The details of their products are not kept in a well-organized manner and cannot be referred when needed. The products sold, and the stock balance is not easily tracked, hence the shortage or some time certain important products maybe out of stock, then in such a circumstance customer satisfaction will be very much reduced.

Solution:- All the products and its brands are clearly following a path.

4. Problem:- Problems on maintaining the Payment

Sometime they may ask the customer to pay for one product twice by mistake, such incident will make to shrink the good relation and the trust of the customer, making to lose customers confidence as well loosing the customer.

olution:- Product balance can be tracked time to time.

5. Problem:- Maintaining the supplier information

There would be a lot of suppliers. It’s difficult to find a supplier detail without being delayed or maybe in some cases they might loss a contact detail of a particular supplier, which might be an important contact for a special product or a Brand, loosing this sort of information will make the company to have problems of finding products of famous brands.

Solution:- All the supplier information will be collect then and there.

6. Problem:- No updated information available

Updated information is not very easy to provide to customers if the company runs manually.

Solution:- Brands and latest editions that are being handled by the company can be tracked without doubt.

7. Problem:- Payments can only be made by cash or credit payments

Running manually, the company could have only the payment methods of cash and cheques. This is a great disadvantage for the customers who use the credit payment card.

Solution:- Payment can be made in cash or credit, and efficient and quick service can be provided.

8. Problem:- Dissatisfaction of customers

While the business is running on the manual system, the customers would not be satisfied of the services provided to them. They might have to wait in a long queue to pay for the items they bought. This may be due to the absence of the employees or maybe due to the slow system of the company.

Solution:- Membership form will be filled automatically, according to the sales that are made and this would only be for the required sales.

Some additional solutions

• Ensuring the integration, integrity and independently for the information system and eliminating as far as possible changes for human errors by introducing database concepts.
• Implementing highly secure functionality. It is essential that customers and the suppliers’ information be prevented from leaking out.
• System will also enables the management to do accurate calculation as well as obtain reports such as total income for the given time period.
• Better utilization of storage space. Doing away with manual will reduce the space taken up by the data storage. This can be utilizing the better for other purpose.
• A comprehensive project database that act as a central repository to track the below mentioned needs.

Define work in progress.

• Easy access for the items short shipped on the order.
• Easy to scheduling and tracking records
• Easy of maintaining, schedules, monitoring, reporting of progress.

Vision

The company aspiration is to “always give you the best” hence to provide better quality Products at a reasonable price. Finally, the company hopes to become a best entertainment company in the London.

Mission

The company emphasizes on continuous improvement in their provides the best service to their consumers. They are inclined; achieve this by surveillance and increasing the expanding and resilience of their sales.

Objectives

Feasibility study: Is the project technically, operationally, financially and legally feasible? The feasibility study is used to determine if the project should get the go-ahead. If the project is to precede the feasibility study will produce a project plan and budget estimates, for the future stages of development.

Analysis: Gather the requirements for the system. These stages include a detailed study of the business needs of the organization. Options for changing the business process may be considered.

Design: This focuses on high level design, low level design and data design).

Implementation: The designs are translated into code. Computer programs may be written using a conventional programming language to a fourth generation language (4GL) or an application generator.

Testing: The system is tested. Normally programs are written as a series of individual modules- these should be subject to separate and detailed test.

The system is then tested as a whole- the separate modules are brought together and Taste as a complete system. The system needs to be tested to ensure that interfaces between modules work (integration testing), the system works on the intended platform and with the expected volume of data (volume testing) and that the system dose what the user requires (acceptance testing).

Maintenance: Maintain the proposed system.

Time schedule for the Project

Relevant to programme and courses

I am currently studying software engineering, previously I did BTECH HND in software engineering. I have good skills about programming languages and database. I’m planning to do this project with Microsoft.net and SQL database.

Legal and Ethical Issues

I am Using Copyright material, Such as Microsoft Products. I am using University of Greenwich License to use the related software’s. As a University student I have permission to use their resources.

I m intend to interview Admin People and some other staff.

I would like to interview over the phone and make the questionnaire or through the email. So their data will be secure and must be protected. So in this case data protection act will affect me when doing my project.

My interim report will show the following details…

Benefits of this proposed system,

Database design and interface design,

Constraint of this project

Resources and People

Supervisor – Mr Alexander M. Fedorec

University Resources (Software’s)

Microsoft Products

References

1. Software Engineering 7th Edition

Ian Sommerville, Addison Wesley (2004), ISBN: 0321210263

2. Lecture notes

How I’m going to complete this objectives.

1. First of all I will investigate the existing system and their accessible process measurements.
2. I will examine the system requirements by using Interviews, questionnaires and observation, at the end of stage this part i will write a system analyse report.
3. I will do the design and development for video rental system using by software engineering techniques. Such as

• Create user accounts to improve the system security and safety.
• Using programming techniques to design the system such as (E-R-Diagram, use case diagram and dataflow diagrams).
• Using SQL statements in order to develop the searching purposes.
• Produce all probable transactions reports.
• Select an appropriate method in order to test the video rental system using available data’s.

Reasons for choosing this project

As a software engineering student, I wish to design and develop a software system to a company with using software engineering techniques. I am srilankan student, in my country many of the companies not computerized their business so far. Because there is shortage for software developers to computerized their company business operations. There for I’m selecting this project in order to gain such kind of experience through. When I go back to my country after complete my studies these experiences will help me to full fill an excellent job.

Melodius Video Company is owned by one of my friends. This was helps me to get permission to collect all appropriate data’s for the requirement analysis part and also their handling massive data’s in their business operations. Instantly they need a computerized system. There for I have decided to develop this system and I think it will reduce their risks and difficult work. And I believe, I have use all prior skills and knowledge’s to complete this project as a real time and error free.

Appendix B – ???????

Appendix C – ???????

Benefits of the system

Order

• By using combo box make easier to select supplier details and video no
• Possible to input the quantity and unit price as client needs
• By using grid view is easy to finalise the order
• It is impossible to order particular video no can not repeat in a same order id

Purchase

• It is impossible to purchase particular order no can not repeat in a same purchase no
• Quantity and unit price automatically loaded that already inputted in the order form
• Possible changes available in quantity and unit price

Allocate for rent

• Define the rent
• Allocate the days
• Manually input the no of copies as clients preferences
• Stock alert message appears according to the limit

Rental

• Easy to select member from the combo box for the member details
• User friendly movie search options
• Search categories in rental such as;  video no, movie title or all movie
• Confirmation is possible to choose the movies before adding to the system

Sales

• Sales categorized by member or cash customer
• By selecting member name member can do the purchase
• Discount available depends on the purchase 
• If the purchase over GBP 250 then could get 8% discount
• If the purchase over GBP 150 then could get 5% discount
• If the purchase over GBP 50 then could get 2% discount
• System checks automatically the stock level before enter the quantity

Introduction

This part contains the most important functions, which were received out during the overall project development and how the objectives have been gained during the whole stages of the project. The key review of the project describes the factors which have been offered the negative contact to the project during the stages were undertaken. It also describes what the existing problems of the project are and how it can be decided in future.

Summary

If the project meets its requirements proposed by the client in the requirement specification, Project can be judge as a proper project, 

According to the user requirements, this project meets the all specifications. Therefore, that it could be illustrated success system. Software engineering tools and techniques used in this project and designing, implementation also have been followed during software development life cycle.

The development methodology was waterfall method, that I have been selected. It was very support to me to implement the project while there was a limited time.

This waterfall method that I have used, help me to work out the small iterative development life cycles. In addition, these methods help me to re-correct the system errors. Advanced the usage of the prototype allowed me to implement a functional model of the video rental system. Therefore the user rechecked the requirements of the rental system when was the prototype was implemented.