• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12

The following report clearly outlines and illustrates several design documents and implemented programs for the systems in question

Extracts from this document...

Introduction

Table of Contents Table of Contents 1 1.0 Introduction 2 2.0 Entity and Attribute Analysis 2 2.1 Assumptions 2 2.2 Identified Entities and Attributes 3 2.2.1 ER Diagram for the Frothy Coffee System 3 2.3 SQL Scripts For Creating Tables 5 2.4 SQL Scripts Used to Insert Values in the Tables 7 2.5 SQL Scripts for Several Queries 8 2.6 Form One Showing List of Employees Working in a Particular Shop 10 Database Systems Assignment 1 1.0 Introduction The following report clearly outlines and illustrates several design documents and implemented programs for the systems in question (Coffee Shop System) these are: * The whole design of the system as stated by the user * ER-model for the data structure in question (relational database) * Entity and attributes analysis * Business constraints incorporated in the design * The implemented system as required by user o Documented reports that will be produced by the system o Appropriate and fully documented SQL programs used to develop the database * Test data and test cases used in testing system in question Firstly the system has been designed and implemented to produce the best possible administrational reports as required by the executives of the company. ...read more.

Middle

All the shops are listed here including their opening date and size Attribute Shop ID Shop Name Address Opening Date countryID Primary Key Shop ID Foreign Key Entity Description Table/Entity Name: Country Description: Contains information about the location of shops within the country. Attribute Country Id Country Name Address location Primary Key Country ID Foreign Key Entity Description Table/Entity Name: Employees Description: Contains information about all the employees working in different shops and in different countries Attribute Employee Id Employee Name Address Joining Date Rank Salary shopID Primary Key Employee ID Foreign Key Shop ID Entity Description Table/Entity Name: Products Description: Contains the information about all the products sold in all the shops Attribute Product ID Product Name Origin Price Type quantity Primary Key Product ID Foreign Key Shop ID Supplier ID Entity Description Table/Entity Name: Supplier Description: Contains Information about all the suppliers supplying products to shops Attribute Supplier ID Supplier Name Supplier Address Telephone number Speciality Primary Key Supplier ID Foreign Key Entity Description Table/Entity Name: Reports Description: Contains all the produced reports generated by the system Attribute Report ID Currency Exchange rates Date Primary Key Report ID Foreign Key Shop ID 2.3 SQL Scripts For Creating Tables Table Country create table country ( country_id number(3) ...read more.

Conclusion

LOCATION --------------- -------------------- --------- clarks malawi air port, Malawi malawi air port, Belgium America America Germany Brazil S.America Zambia Zambia Africa Tanzania S.Africa Africa 6 rows selected. SQL> B. List of Employees Working in a Particular Shop SQL> select 2 employee_name 3 from employees, shops 4 where 5 shops.shop_id = 1; EMPLOYEE_NAME --------------- kadzombe Andy Hurry Nedson Anderson (Limited to one shop. A & can be used to prompt several entries) C. Total number of Shops in Each Country SQL> select shop_name 2 from shops, country 3 where country.country_id = shops.country_id; SHOP_NAME --------------- clarks Malawi Belgium Germany Zambia Tanzania 6 rows selected. SQL> D. List of Employees Working for the Company for more that 12 Months SQL> select employee_name 2 from employees 3 where employee_joining_date - sysdate >= EMPLOYEE_NAME --------------- kadzombe Hurry Nedson Anderson SQL> F. Average Taking of a given shop on a given day Totol_sales is a calculate field in the database so that it always has a value depending on the sales. SQL> SELECT TOTAL_SALES FROM SHOPS, PRODUCT 2 WHERE SHOPS.SHOP_ID = PRODUCT.SHOP_ID; TOTAL_SALES ----------- 5000 800 2000 800 5000 2.6 Form One Showing List of Employees Working in a Particular Shop 2.7 Report One Showing All Shops in Each Country. 4 1 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Human Geography section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE Human Geography essays

  1. Research Question - The Developments of The London Docklands have changed the characteristics ...

    For this I used convenience sampling - I took the nearest main road from the DLR Station and recorded the data. To make it more accurate we took the same amount of time (5 minutes at each road). I used the tally chart because it was a simple yet effective

  2. Farming Systems

    seeds, improved breeds * Organic farming- avoids the use of artificial fertiliser and pesticides and using animal manure and compost instead * Subsidies and grants- many British farmers are only able to grow certain crops and keep certain animals because of successive governments have provided subsidies and grants * Changes

  1. Overstrand report

    However the local residents can easily move homes to somewhere where it is safer for them to live, but that will not be possible as no will want to buy a house which is going to erode with the cliffs in the next few years.

  2. Aid and Development Report

    This is good because that part of Egypt can have more trade with other countries as boats can travel down the Nile. The Aswan High Dam has made the Nile more navigable. This means that boats can use the river for sailing.

  1. The aim of my coursework, investigating shopping patterns in Brent, is based on answering ...

    complex as the vast amounts of vehicle and noise pollution being produced in the surrounding area may discourage some asthma sufferers as well as other people from visiting the location which can be seen in the various methods of data collection I used at this particular site.

  2. Geography Course Work - St. Albans

    An example of this is shown below: Interpretation and Analysis. In a group of four, we studied eight grid squares, B1-4 and C1-4. Seven out of these eight squares had 0% CBD functions and the remaining one had 80% CBD functions.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work