Cis/336 Ilab 2 of 7 - Sql Course Essay example

1462 Words Sep 30th, 2014 6 Pages
HELPIDO.COM

-----------------------------------------------------
Follow this link to get the tutorial

www.helpido.com/cis336ilab2/

-------------------------------------------------------

CIS/336 iLab 2 of 7 - SQL Course
________________________________________
L A B O V E R V I E W

Scenario/Summary

Lab two introduces the next step in creating a data model, the Entity Relationship Diagram (ERD). You will be given a business scenario for a company named Clapham Specialty Store, which is a small specialist grocery and delicatessen. The business specifications will outline a number of things about the business, some of which will apply directly to the database you are being asked to model. There is a table
…show more content…
The products arrive and their details (cost, quantity, SKU number, package size, purchase date) are recorded in the back room before they are displayed. The new owner wants to know which products the store sells most of and which are the most profitable.

The following is some general information about the company and its current processes.
The store has 3 cash registers.
Between 3 and 7 employees will work at any given time, depending on the time of day and how busy they are.
An employee logs in to the register at the start of a shift and logs out at the end.
The name, address, Social Security number and other information is recorded for every employee.
All employees are paid weekly against an hourly rate which varies depending on their job description.
Each sale is identified by a Receipt No. and a timestamp (date and time) and consists of sale items with a quantity and price recorded for each product.

As a convenience for known customers, they offer a local delivery service. Deliveries are only made to customers who are registered at the store; walk-ins must record their name, address, and phone number before a delivery can be made to them.

John can find the cost of the goods from the accounts system. What John would like to have is a point of sale system (POS) that records what has been sold to whom, by whom, for how much, and when. Also, he needs to be able to record the delivery trips that are made, who makes the

Related Documents