- First the customer will walk into the shop and then ask for what movie or game he wants.
- Then the movie which is asked for will be given.
- Then all details will be written down onto paper.
In this rental shop they have 3 staff and they all do the same job, which is to serve the customers.
The problem with this system is that everything is written and documents could get lost which is not good because on these papers could be personal details of the customers, like their address, telephone number etc. Another problem is that because everything is written down then he might be hard to see whether he has the video in the shop so it could be rented out.
There is also another problem with this current system and that is it very time consuming for the customer and the workers. This is because the customer has to wait to long to see whether the video is in stock or not and this could take long and this will make the customer dissatisfied and if all feel like this then the shop will lose it’s customers. This is not good for the company because it will not make that much money. Another problem is that because if everything is written down so if one of the workers has scruffy writing then it will cause problems because if another worker cannot read it then it will cause problems for the business. Another major problem is that because everything is written down on paper and could get lost at the month of the month the customer wants to do it’s accounts this could be very difficult because if papers are lost then it will be hard and the business will not know accurately whether it ahs made a profit or whether it is in loss and this could be detrimental to the business.
REQUIREMENTS OF THE NEW SYSTEM
- To store details of the customers.
- Keep track of all the videos in the store and that this information should be accurate.
- The system should be easy to use and should not be complicated.
- When typing in a query the results of the query asked should be accurate and should be related to the database.
SPECIFIC OBJECTIVES.
QUANTITATIVE
Here are some of the quantitative objectives we want to achieve and these can be easily measured.
- This database will store up to a minimum 300 records
- The database will locate a record which is wanted in less than 15 seconds.
- The database will automatically locate overdue videos
- The database should automatically keep track of stock in the shop
QUALITATIVE
Here are some of the qualitative objectives which we want to achieve but these cannot easily measured.
- The system should be user friendly
- In the layout of the database their should consistency
- The data should be accurate
- The database should be fast.
CONSTRAINTS
The hardware, which is available, is a computer, which is quite fast and very good. This available at home as well so it is better. A tower, monitor, printer is all available
The software, which is available, is Microsoft XP, which includes Microsoft Access, which is what the database will be created on. The person who will be using this system does not have to be an expert on using computers but will need intermediate IT skills to use the database. The reason being that training may also be needed to use the software because this is database, which will be made especially, made for the business itself. The workers which are going to be using the database do not have any experience of using the new system so they will need training. Because training will be needed then it might cost the business some more money and this training may take up to 6 months and this is really necessary.
DESIGN
COMPARISON OF ALTERNATIVE SOLUTION
This project I am doing at the moment is creating a database on Microsoft Access. Another alternative than rather using MS Access could be to use Microsoft Excel which is a spreadsheet package. The reason I feel that MS Access is better for creating this database is because of many reasons
One reason which I feel that MS Access is better and more efficient is that at typing queries in MS Excel you have to use formulas whereas in MS Access you can type your query in and you will be given results. This way is better for the end user because it is more easy than using formulas.
In MS Access it is easier to create files of different customers and it easy because you use forms and this is also user friendly.
JUSTIFICATION FOR CHOSEN SOLUTION
The reason I chose MS Access is that is better and more easy to use for a database than Ms Excel. Another reason I chose MS Access is that It can store a lot of customer files which is essential and a very important factor when creating the database.
DATABASE DESIGN
ENTITY-RELATIONSHIP DIAGRAM
There are three types of RELATIONSHIPS between the entities
- 1:Many
- Many:Many
- 1:1
A Many:Many relationship is that many customers can rent the same movie because the shop can have more than one copy of the video
A 1:1 relationship is that one customer buys one video
Customer Loans Video Supplier
DATA DESCRIPTIONS
TABLE NAME: VIDEO HIRE
CUSTOMER TABLE
LOANS TABLE
VIDEO TABLE
SUPPLY TABLE
INPUT
FORMS
The use of forms is also important because it is a easy way of inputting data of customers. It is also important that it is user friendly and easy to use also important that workers do not amend details of the customers so it should have levels of access. In levels of access the workers should have ID and password and in that they can only see certain whereas the manager can see everything.
OUTPUT
The use if forms to a business is very important because at the end of day the manager of the shop may want to check the sale for the day so on a report he will be able to see it. It is also important that workers cannot amend the data or check the database for any information and also that the workers have a level of access so they can only see certain things.
MENU DESIGNS
SECURITY
Security for database and for a business s very important because you do not want your workers to see all the details of customers or suppliers. for security there should be level of access where the manger can access everything and the customer can only access certain things. Another reason why it is important because you do not want workers to see your sales for the day or to see how much money you make.
TEST PLAN
TESTING
Testing is important because you have to check whether your database works or not or whether it does everything you want it do. One very important reason why testing is important is because if you give your database is being used and there is a fault with it then it will be difficult for the workers to sort it out so you have to make sure that everything works.