You have been given the below data which provides detail of the sales forecast for "Express internet cafe". You are required to prepare a database for the given information and use various software functions and formulae to complete the given tasks.

You must complete the following activities for successfully completing the project on creating and using database:

PRJ1Design and create a simple database by developing two tables for the given information incorporating basic design principles, with fields and attributes according to the database usage in the project

PRJ2Check and amend the entered data and modify table layout and field attributes as required.

PRJ3Create a relationship between the two tables , use the software functions and formulae to calculate the following:

a.Average monthly sale of each item/component as per the given quarterly details.

b.Total quarterly sale of each item/component as per the given quarterly details.

c.Monthwise total sales

d.Total quarterly sales

e.Average monthly sales considering all items sold in that month

f.Average monthly expenses of each component as per the given quarterly details

g.Total quarterly expenses of each component as per the given quarterly details.

h.Monthwise total expenses

i.Total quarterly expenses

j.Average quarterly expenses of each component as per the given quarterly details

k.Net profit for each individual month

l.Total profit for the quarter

m.Average profit for the quarter

n.Percentage profit for each month

o.Average profit percentage for the month

PRJ4Create reports by determining information output, database tables and report layout to meet task requirements.

PRJ5Ensure to group data, search and sort information to meet the task requirements.

PRJ6Verify results and formulae and modify reports to include or exculde additional requirements.

PRJ7List the sources (manuals/ documents/websites) used to overcome problems in database design and production.

PRJ8Ensure that you complete the database preparation as per the timelines given to you.

PRJ9Preview the printout, adjust margins and take printout of your database.

PRJ10Save the spreadsheet by preventing data loss or damage on the desktop and name the spreadsheet as per the below example:

a.If student name: Harry

b.Then file name: Harr_DTBS_PR1

PRJ11Prepare the report and submit the same to your trainer