|
|
|
|
|
Major It Assignment (PES)(YEAR 12)
|
|
|
Major It Assignment Introduction As a part of year 12 subject Information Technology we had to create an electronic database, we were given a question sheet and we had to follow it. We were given our choice of making a database on anything we wish as long as we meet all requirements. We also had to do a write up for our database, once the database is created we will assume that it is actually being used by our client and my client is Befit Sales and Hire Pvt. Ltd. Befit Sales and Hire Pvt. Ltd. Are a Gym equipments shop which consists of customers and gym equipments hiring e.g. Benches etc. My client who would be using this system is a shop Befit Sales And Hire Pvt. Ltd. (Fitness Equipment Shop). My role is to create an electronic database which will help my client in renting electronic items to the customers (eg. Dual action Bike, Fitness Walker, Wilma Belt Massager, etc). Problem Definition The purpose of this database is to be used by an electronic shop that sells and allows renting of electronic items such as for eg (Radio Rentals). Where people can rent items or they may even buy them. The client who would be using this system is any staff member who is working at the Electronic Rentals at any particular time. I have been specified for the role of creating the system electronically on computer that using a special program that is Microsoft Access (any version) in order for the record keepings to keep clean, written quicker and is easy to navigate or search. This database relates to information technology in the fact that is being used with the help of a computer to find record neat, effective and is useful to find information quickly as commands can be entered and results are displayed on the screen which should be easy to follow. 1) Objectives Recording information of customers/members, staff details, hiring of each accessory etc. It will also record about when a particular item was hired and who hire it and when is it suppose to be due back. It will also record whether that particular item was overdue or not? If it was overdue then who hire it and how much fine do they have to pay? This database will also keep the record of the new member and will also keep the record of the current members. 2) Elements All details of customers/members are currently Electronic Rentals in a book or in a folder that is later on kept in a drawer and is locked by a staff member. Every staff member has a key to that locker so they can access it at any time. Each and every item and a member have been given identification in form of number and/or letters. The reason why they have been given identification is so they can easily be identified and for eg if someone walks into the Electronic Rentals who is a member of the Electronic Rentals without having some sort of identification how is the staff member going to find out that the customer is really a member? So if identification has been given to the member they can easily figure out there details. At present all the information about customers/members, loans and items is recorded on a piece of paper and all the information is written by hand and then later on is kept in the locker for future use. For eg a staff member will record details of a customer who hired laptop for 4 weeks. The staff member will write that details of a customer who hired laptop for 4 weeks. The staff member writes that on a piece of paper and will keep it in a safe place.
|
|
|
|
Still Can't Find What Your Looking For? Then Try a Essay Search!
|
