Project work and Databases

14 Feb



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.






Mark Allocation:
1. Understanding the Problem

2. Planning

3. Designing solutions

4. Implementing

5. Testing Evaluating and Maintaining


6. Social and Ethical Issues

7. Log Book / Journal

8. Files saved correctly using correct software.

9. Group Dynamics






Outcomes assessed

A student:

H2.2 Develops solutions for an identified need which address all of the information


H6.1 Analyses situations, identifies a need and develops solutions.

H6.2 Selects and applies a methodical approach to planning, designing or implementing a


H7.2 Uses methods to thoroughly document the development of individual and/or group




Year 12 IPT Group Project

The following is to be used as a GUIDE in order to appropriately and/or correctly complete the Group Project.


Understanding the problem

·  One (1) A4 page on what the problem is, who are the participants, data, requirements.

·  One (1) A4 page on what P.O.S and EFTPOS systems are.

·  Project plan outlining the overall schedule, subprojects (inc. schedules), people involved, information technology and data/information required by the system. Minimum two (2) A4 pages.

·  Conduct some preliminary investigation on at least 3 different supermarkets to ascertain the following:

– Current Information System in use

– Products sold (Do they only stock brand names?)

– Prices (Are their prices competitive? Who do they cater for?)

– Marketing (How do they get customers into their store?)

– Layout of the store(s).

·  A one (1) A4 page requirements report that outlines the aims and objectives of the new system and how it will help the organization.



·  Suggest three (3) or more possible solutions to the problem. Include for each:

i) Constraints (factors that affects the system and prevents it from achieving the desired objectives) on the system. These could be financial, technical, environmental or personal.

ii) Advantages and disadvantages of each solution.

·  A feasibility study to be carried out on the most appropriate of the proposed solutions. The feasibility study is to include:

i) Economic feasibility

ii) Technical feasibility

iii) Schedule feasibility

iv) Operational feasibility

·  A revised project plan based on the feasibility study.

·  An analysis report investigates the existing system in greater depth to ensure all current operations and problems are understood. This analysis report must include:

i) Needs of the new system

ii) Data to be gathered (via interviews, surveys, observations and measurements)

iii) Recommendations for design, implementation and maintenance.

iv) Design specifications such as hardware configuration of the new system and designs for both input and output.

·         Recommend and justify a suitable system development approach.


Designing solutions

This stage is the transformation of the specifications into appropriate hardware, software and information processes. It involves purchasing hardware, writing or purchasing software, and specifying information processes to make the system operational. In this section you must include:

·  A spreadsheet file that includes the following:

i) Cost of proposed hardware to be used

ii) Cost of proposed software to be used.

iii) General expenditure of the supermarket

iv) Payroll for all of the employees

·  A database file that includes the following:

i) A form for stock that includes 100 fictitious records (Name, product description, price, brand, quantity and universal product code)

ii) A form for employee information (Name, address, post code, phone number, position and employment status)

iii) A form for supplier’s information (Name, address, post code, phone number, and product supplied)

iv) Relevant Queries and Reports

v) Switchboard to open forms, reports and exit application.

·  Two (2) context diagrams on various aspects of the system (Ordering products, Sales at the check-out)

·  One (1) Data Flow Diagram (DFD) on the sales at the check-out system.

·  Two (2) decision trees on various aspects of the system (Ordering products, EFTPOS purchasing)

·  One (1) data dictionary based on the database.



·  An implementation plan (one A4 page minimum) detailing the following aspects:

i) Method of participant training and why.

ii) The conversion method and why.

iii) System testing (Hardware, software and information processes)

·  Create a flyer for the local supermarket to promote its lower prices using Microsoft Word.


Testing, evaluating and maintaining

In this stage, the performance of the system is tested and then evaluated. You must include:

·  Methods of testing conducted and reason why.

·  Evaluation of the new system by comparing it to the initial aims and objectives outlined in the requirement report.

·  Methods of maintaining the system.


Social and ethical issues

·  One (1) A4 page that includes information about the type of system, work environment and systems and ethics.



Logbook / Journal

Each group member is to contribute to a logbook/journal (Who is doing what, when they did it, time taken, how it was done, and problems encountered). This is to be done on a weekly basis.



Group Dynamics

Each group will be called upon at random over the course of the project to show/discuss aspects of the project.








Leave a comment

Posted by on February 14, 2017 in academic writing, Academic Writing



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: