Question
This project is in continuation to the previous task. You need to use the database of sales forecast for Express internet cafe created in the
This project is in continuation to the previous task. You need to use the database of sales forecast for "Express internet cafe" created in the previous task. You are required to add information to the existing database 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 database by developing additional tables for the 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 tables, create primary key for each table, use the software functions and formulae to perform the following tasks:
a.Prepare the sales forecast for the second quarter, considering the following
i.2% increase in sales (compared to march) of each item in the month of April.
ii.3% increase in sales (compared to April) of each item, in the month of May
iii.3% increase in sales (compared to May) of each item, in the month of June
iv.2.5% increase in expenses (compared to march) of each component in the month of April
v.Same expenses as April for the month of May and June
b.Average monthly sale of each item/component as per the new quarterly details.
c.Total quarterly sale of each item/component as per the new quarterly details.
d.Monthwise total sales
e.Total quarterly sales
f.Average monthly sales considering all items sold in that month
g.Average monthly expenses of each component as per the new quarterly details
h.Total quarterly expenses of each component as per the new quarterly details.
i.Monthwise total expenses
j.Total quarterly expenses
k.Average quarterly expenses of each component as per the new quarterly details
l.Net profit for each individual month
m.Total profit for the quarter
n.Average profit for the quarter
o.Percentage profit for each month
p.Average profit percentage for the month
q.Combine the reports of first quarter and second quarter to make a consolidated half yearly sales forecast for " Express internet caf".
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 databse 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started