Project work and Databases - Task Description:
Project:
A local supermarket is open seven days a week and employs 21 people on a full-time or part-time basis. It has a POS system and EFTPOS facilities. The supermarket is having problems with stock records and needs a new information system. The supermarket maintains its prices are lower than the competitors'. Develop a solution for the supermarket.
It must store fictitious data for each item, such as name, product description, price, brand, quantity and universal product code.
- Create a logo, slogan and banner for the supermarket.
- Set up a database for the employees, suppliers and products using DBMS.
- Create relevant queries, forms, reports and switchboard for the database.
- Investigate the prices of a range of goods in your local community.
- Create a flyer for the local supermarket to promote its lower prices.
Attachment:- Assignment File.rar