Constraints – Hardware, Software and users IT knowledge and skills
The current computer system is a
AMD Athlon Xp 2000
80 Gb HDD
512ddr RAM
The system came with windows XP Home and Microsoft office XP Professional the user will just need to know how to use Microsoft Access. To install Microsoft office the user will need about 500mb of space. The current computer should be sufficient to run Access.
The system inputs and outputs
The inputs are:
- Member Details – Member ID, Name, Address, Age, D.O.B
- Video Details – Video ID, Video Name, Age Rating
- Video - Where the user will type in the film and Microsoft Access will see if it is available, it will also say how many people have got it and who those people are
- Type in a video - And it will display a brief review
- Borrowing – video, member, date, days borrowed
The system outputs are:
- A report in the style of a receipt
Identify processing requirements
The system will have to do queries an example is looking for a member. The system will also have to add up bills. There will also be an administrative area where a person can access an area to add new films etc.
Work out the return date and how much the member has to pay
Work out if a video is overdue
Produce letters to members with overdue videos
Identification of Entities
Entities that I will use on this project are
- Member
- DVD/Video
- Borrowing
Entity Relationships
Member Table
DVD/Video Table
Borrowing Table
Start-up Settings for Forms
The forms will be set so that the user can not access the bulk of the program, the toolbar will designed with limited options on them. When the user starts up the program it will go straight to the main page.
Implementation
Implementation Log
This is tbl_member this table will hold the details of the members; the key field of the table is Member ID. The Field size for all text types is 20. Apart from Postal Code, the field size is 7 and its format is > this means all text entered will be in upper case.
This is tbl_borrowing, all the details of what people have borrowed will be held in this table. It has to key fields DVD ID and Member ID
This is tbl_dvd/video it will hold all the information of the DVD’s i.e. name, age rating etc. The key field is DVD ID
This is tbl_member_dvd/video this is a link table, the key fields a Member ID and DVD ID
This is my relationships window, it shows the relationships between the tables, it also shows that referential integrity has been enforced.
This is tbl_member this is showing that the data has been entered but is also showing erroneous data being rejected.
This is tbl_dvd/video in datasheet view it shows all the data that has been entered
Testing
Module Testing
Forms
This is the main form, the first button of the form goes to the members form
The buttons at the bottom of the page allow the user to go through the different record, add record and delete records.
The next button goes to the borrowing form.
This is the borrowing form, this is where you would enter the information for letting out DVD/Videos
This shows that the navigational buttons work, it also shows that the drop down boxes have been used to add a new record the other buttons include Add record, Delete record and the usual navigational buttons.
The last button is DVD/Videos button this button takes you to this screen
This is where you add a Film details into the database, the buttons on this form include functions such as add record, delete record, and navigate through records.
Queries
The only query that have got is to produce a receipt for the customer
when run together with the frm_borrowing form it produces this
It shows the data that has been entered in the borrowing form.
Report
This is the report that has been produced from the above query.
Screenshot 1
Screenshot 2
Screenshot 3
Screenshot 4
Evaluation
The original user requirements are
- Be able to keep a list of members and their details
- Be able to keep track of videos and DVDs in stock
- Be able to see what person has got what video
- Be able to track of how much money a person owes
- Be able to rent out and return videos quickly
- Be able to print out lists of overdue videos
Meeting objectives
Be able to keep a list of members and their details
This was one achieved through creating the members form, this form allows the user to add/delete members, and also give you details on where they live and how old they are.
Be able to keep track of Videos and DVD’s in stock
This was done through the DVD/Video form, this form allows the user to ADD/Delete videos in the database and also view information about the video, i.e. Age Rating, Genre
Be able to see what person has got what video
This achieved along side with the members form, when you select different members a table will show you what DVD’s they have, and when they are due etc.
Be able to track how much money a person owes
The table will show you how much each DVD costs and from this you can add up what they owe. But this could take time.
Be able to rent out and return videos quickly
This has been achieved, the borrowing form has been made as user friendly as possible, the user has to select the members ID and the Video they wish to borrow then the amount of days, and the computer will work out the rest, this is a very quick system. The only bad thing about this is that the current system only allows the user to hire out one video at the time.
Be able to print out a list of overdue videos
This can be done by looking at the videos hired out and the videos over due can be worked out from this. This could have been made easier for the user but it has not.
Enhancements
The first main enhancement I would make is being able to hire out more than one video at a time, as this a serious limitation. This is do-able. Another enhancement that I would make is making it easier to see what is over due and how much the person owes, this would make the system much more stress free for the user as at the end of the day the last thing the user wants to do is to work out if a video is overdue or not or how much a person owes, if this was all computerised there would be less room for error.