Input
Data Manipulation
In the system Customer, Car and Sales tables are required.
The individual fields in each table will be as follows:
MEMBER [MemberID, Title, First name, Last name, Address, Town, Country/Region]
VIDEO [VideoID, Video name, Video price, Video age rating, Video popularity, Genre]
RENTAL [RentalID, MemberID, VideoID, Date borrowed, Date returned, Name of person]
Member table is used for inserting all the members’ details. Video table is used for inserting all the videos details. Rental table is used fro inserting all of the renting of the videos details. All of the tables have a primary key reports and forms would be produced. Tables and queries would be created to search and sort data. The reports can be printed out any time hard copies of data is required. Also, the Forms would be used to enter data, edit and update data.
My primary keys
Member ID- Member
Video ID- Video
Rental ID- Rental
Data flow Diagram
Output
Data will be displayed on a computer monitor and should be viewable. These could be viewed by the employees. Data will be printed of using a printer. Things such as over due videos and new videos out to rent could be printed out. The date and time could be printed out to remind customers. Every time a video is over due a letter of reminder needs to be carried out so user needs to be prepared to print out copies.
- The most important output is a printer:
- Ink jet printer
- Laser printers
- LED/LCD printers
- Impact (Dot-matrix) printers
- Solid Ink printers
- Portable printers
- Dye Sublimation printers
- Plotters
- Network printer
Monitor
Can be seen
- Is the main form of output
Proposed output
The output that I will be using will be a monitor to show the user what data they are entering and I will be using a printer to print out reports. This output is quick and efficient and this will benefit the video shop as it doesn’t take a long time.
Backup
Backup can be used in case any information is misplaced or lost. Losing data can be a serious consequence if you don’t have any back up, and can take a very long time to get all information back. The way I will create back up will be by saving the database on a USB and the video shops computer. A USB is best for saving data as it has the least disadvantages. Below are the reasons of why I did not choose the following.
CD- Disadvantages
- Once CD rom is created information cannot be changed.
- Slow upgrade
- Limited access
Disk- Disadvantages
- too much disk space usage can slow down your computer
- Can only store a certain amount
Floppy disk-Disadvantages
- Time consuming
- Out of fashion
- Limited capacity
- Not suitable for backing up data from other programs such as: Microsoft Excel, Word etc.
Security
Security is very important, if any files are misplaced or lost it will be very long to find and all the details will have to be reinstalled into the system. This will have a great effect on the customers as all the details of the over due videos will no longer be on the file, the running of the business will become corrupted. There will be a need for securing the system and there are a couple of ways to secure the system:
- Using passwords to avoid anyone except from the people who work there to have access.
- Using Anti-virus will stop computers clashing, virus from getting in and slowing the system down.
- Using back-ups will be a safe thing to do if you are worried of losing confidential, important information.
- Using locked cells.
- CCTV
- Lock on the door
