unit 33 assign 1 final

Unit 33 Data Analysis and Design (Final Submission)

By

Priscilla WilsonDue Date: 15/05/15Data No: 895070

1

Priscilla Wilson Date: 15/05/15 Data No: 895070

TABLE OF CONTENTS

LEARNING OBJECTIVE 2

INTRODUCTION2.1 DESIGN A RELATIONAL DATABASE SYSTEM TO MEET A GIVEN REQUIREMENT2.2 BUILD A RELATIONAL DATABASE SYSTEM BASED ON A PREPARED DESIGN2.3 APPLY A RANGE OF DATABASE TOOLS AND TECHNIQUES TO ENHANCE THE USER INTERFACE


3.1 EXPLAIN THE BENEFITS OF USING THE MANIPULATION AND QUERY TOOLS IN A RELATIONAL DATABASE TOOL3.2 IMPLEMENT A QUERY LANGUAGE INTO THE RELATIONAL DATABASE3.3 CRTICALLY EVALUATE HOW MEANINGFUL DATA HAS BEEN EXTRACTED THROUGH THE USE OF QUERY TOOLS


4.1 CRITICALLY REVIEW AND TEST A RELATIONAL DATABASE SYSTEM4.2 CREATE DOCUMENTATION TO SUPPORT THE IMPLEMENTATION AND TESTING OF A RELATIONAL DATABASE SYSTEM4.3 CREATE USER DOCUMENTATION FOR A DEVELOPED RELATIONAL DATABASE SYSTEM4.4 EXPLAIN HOW VERIFICATION AND VALIDATION HAS ADDRESSED4.5 EXPLAIN HOW CONTROL MECHANISMS HAVE BEEN USED

2


INTRODUCTION

Below shows the organization which I will be designing a relational database. This organization supplies party and wedding supplies such as balloons, personalized products i.e. mugs and wallets, table decorations etc. White wedding and party supplies is based in the UK and ships its products worldwide. Whites wedding supplies have their products displayed in four currencies which are for the following countries/continents; America, United Kingdom, Europe and New Zealand since they trade internationally. The four products they display their currency in are the following listed below;

US Dollar British Pound Euro New Zealand Dollar

Whites wedding supplies has commissioned me to design a relational database.

2.1 DESIGN A RELATIONAL DATABASE TO MEET A GIVEN REQUIREMENT

Below shows the different types of requirements for my relational database. This includes transaction requirements and data requirements.

Data RequirementsBranch/s White wedding supplies is based in United Kingdom but trades across the following continents and countries; New Zealand, United Kingdom United States and Europe. For customers based in the UK they can order online and collect at the Warehouse in Sheffield, in addition to that any products which contain alcohol can only be delivered and purchase in the UK for UK residents. The Sheffield warehouse includes a unique branch number, address (street, city, and postcode), telephone number, name of the member of staff who currently manages the warehouse and no of employees. For international deliveries there are no warehouses where customers cannot pick up their goods; in this case it will be delivered to their resident. Staff Members of staff with the role of Supervisor are responsible for the day-to-day activities of an allocated group of staff called Assistants. The data stored on each member of staff includes staff number, name, address, position, salary, date hired, email address, mobile no, telephone no and contract hours. The staff number is unique across the warehouse of White Wedding’s and Party Supplies.

3


Clients White’s Wedding and Party Supplies refers to members of the public interested in purchasing party supplies as clients. To become a client, a person must first register online at the White’s Wedding and Party Supplies. The data stored on clients includes client number (generated automatically), name, telephone number and email. There are additional fields which include country, postcode, bank/building society name, credit/debit card, issue Date, expiry date, billing address, billing city, billing postcode, order no and billing country. The client number is unique across the warehouse in Sheffield.Transaction RequirementsData Entry

• Enter the details of a new member of staff at the warehouse (such as Becky Bedford at S001).

Update/deletion• Update/delete the details of the warehouse. • Update/delete the details of a member of staff at the

warehouse. Data queries

• List the name, position, and salary of staff at the warehouse, ordered by staff name.

• List the names of staff supervised by a named supervisor.• Identify the total number of orders in each city. • Identify the total number of orders assigned to each member

of staff at the warehouse.• List the number, name, and telephone number of clients and

their order preferences.

2.2 BUILD A RELATIONAL DATABASE BASED ON A PREPARED DESIGN

Based on the research which I conducted about White Wedding and party supply I found the following entities which are branch, staff, client, order and product. Below shows the attributes for the above entities;

4


2.2 BUILD A RELATIONAL DATABASE BASED ON A PREPARED DESIGN

5


2.3 APPLY A RANGE OF DATABASE TOOLS AND TECHNIQUES TO ENHANCE THE USER INTERFACE

To enhance the look of the user interface I have used forms. The reason I have used these is that they are more user friendly and it is easier to navigate around them. Below shows an example of forms which I have produced in my database. I have added buttons so users can edit, add and remove data in addition to that I have added a hyperlink to the company website so that users can refer to things

6


7


3.1 EXPLAIN THE BENEFITS OF USING THE MANIPULATION AND QUERY TOOLS IN A RELATIONAL DATABASE TOOLS

8


3.2 IMPLEMENT A QUERY LANGUAGE INTO THE RELATIONAL DATABASE

3.3 CRITICALLY EVALUATE HOW MEANINGFUL DATA HAS BEEN EXTRACTED THE THROUGH THE USE OF QUERY TOOLS

9


4.1 CRITICALLY REVIEW AND TEST A RELATIONAL DATABASE SYSTEM

4.2 CREATE DOCUMENTATION TO SUPPORT THE IMPLEMENTATION AND TESTING OF A RELATIONAL DATABASE SYSTEM

10


If we refer back to 3.3 we created a number of queries which gave specific information. The purpose of queries is to give us specific information which we require quickly; we used the product, client and staff tables to create queries.

The information which we extracted from the queries are proven to be very useful as because we can use the information we got from the client table to retain customers, we can use the information we got from the staff table to show immigration officers that we hired employees according to immigration law and finally we can use the information we got from the product table to see which products are low on stock. In addition that if we compare the product table to the order table we can find which products are popular amongst our clients.

4.3 CREATE USER DOCUMENTATION FOR A DEVELOPED RELATIONAL DATABASE SYSTEM

11


12


4.4 EXPLAIN HOW VERIFICATION AND VALIDATION HAS ADDRESSED

13


4.5 EXPLAIN HOW CONTROL MECHANISMS HAVE BEEN USED?

unit 33 assign 1 final

Documents