Stationary Shop Database Case Study

PROJECT 1 – Stationary Shop Database

Unit Question:
How can a business or an organization modernize its records information using technology?

Global Context:
Fairness and Development
The project is linked to fairness and development because it aids with the development of society. By developing our technology we are making it easier for people to do basic things, which required a lot of effort before. With the help of development is becomes much easier and more fair for people to complete tasks.

Approaches to Learning: o Organization o Thinking o Information Literacy

Inquiring and Analysing

Explain and Justify the Need for a Solution

In EISJ there is a store manager to help provide for the stationary requirements in the school.
Abdulla with his problem. I think that a good database is something that keeps all of the recorded data together in one place so that none of the information gets misplaced or lost, the problem with spreadsheets is that if lost it could cause for orders being placed by the teachers to be lost and the teachers will find themselves without the materials they need to conduct their class. I would also have to install a security system so that the information stored in the database can’t be accessed by just anyone, to avoid this problem I would be adding user system so that any teacher who accesses the database will have to log on to their user and access it from there as I think this will help us know if any data is deleted and can also keep track of which user/teacher has placed an order and what the teacher needs. Mr. Abdulla will also have to have a contact page where teachers can send him any special requests for the materials they order. I will also be adding a page that shows what the suppliers have in stock so that the teachers will know what they can order, it will also include a notifying system where as if a teacher needs a piece of equipment or any other material and it is out of stock, the system will automatically send a notification to the teacher telling him/her when the supplier receives the stock. The database will also alert Mr. Abdulla when a teacher places an order for something so that he knows what needs to be brought in, this system will also prevent any excess equipment being paid for as sometimes if there are more materials that have been sent and the school needs to pay more for things they didn’t order, Mr. Abdulla can prevent this as he would know what the order is and how much of it has been ordered. I also found the databases that I had researched helping me in this situation as they gave me ideas as to what I can add to improve my database even