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