FdSc in ICT Module 107
Herefordshire College of Technology and
The University of Gloucestershire
Assignment front sheet
Assessor: Bob HiggieCourse: FdSc in ICT
Module: 107 Systems Analysis and Database Design
Title: Top down and bottom up modelling
Internal Verification of assignment: Len Shand
Date: 18th September 2013
Issued: 18th September 2013
Due date: 8th November 2013
Outcome and Principal Objective(s):
Describe the systems development life cycle and the role of the systems analyst
Analyse the components of a business system (partial)
Describe the relational model and normalization (partial)
Build efficient and effective databases (partial)
Task / 1 / 2 / 3 / 4 / 5 / 6 / 7
Mark / 15 / 10 / 5 / 20 / 20 / 10 / 20
Submission and feedback:
This assignment is to be submitted on Turnitin, where it will be marked and you will be able to see your lecturer’s feedback
Conditions:
The submission of this assignment on Turnitin certifies that the work is your own.
This assignment tests your understanding of:
· The systems development life cycle
· Creating simple requirements statements from a brief
· Creating a top down model (ERD)
· Creating a bottom up model (normalisation)
· The relational model
· Constructing a simple relational database
Task 1 (15%):
You have been hired to develop a mobile application for a company producing pharmaceutical products.
The app has to show the full range of products, their descriptions and their prices, using a database held on a central server. It has to be able to input orders to the server, which will generate confirmation e-mails.
It must be simple to use for the sales force, highly reliable and have an offline mode for when cellular connection is not available.
It has to be operational within 9 months.
Propose two suitable development methodologies that could be used, giving your reasons.
Then choose one, again justifying your decision.
This should be no more than 1 side of A4.
Task 2 (10%):
Create a requirements document from the coal merchant’s brief below. This should be no more than 1 side of A4.
Task 3 (5%):
Describe which requirements you will implement in a relational database and why.
This should be no more than 200 words.
Task 4 (20%):
Create an ERD diagram for the database. Draw a diagram for each step you take and clearly identify how you have resolved any many to many relationships. Complete the diagram by adding the attributes associated with each entity.
Task 5 (20%):
Identify the attributes for a bottom up model.
Normalise the database to third normal form.
Task 6 (10%):
Describe and explain any differences between the two models from task 3 and 4. Decide which model or combination you will implement and discuss your decision. This should be no more than 200 words
Task 7 (20%):
Implement the tables in MySql. Produce a data dictionary and explain your choices of data types. This should be no more than 200 words (excluding the dictionary). Present a screen shot or print out of the table structure as evidence.
Coal merchant’s brief
They want a new web site. The current one only has your contact details and some product information. The orders are done on paper.
It must match the existing corporate branding in design
It must allow their customers to:
· Add or edit their details
· Place orders
· Schedule a delivery from a regular schedule of “rounds” (eg West Hereford is Monday)
· See what products there are
· Permit a search of a knowledge base of appliances and the correct fuels
The web site must be up and running before Christmas
All the existing customer records are to be added to the new web site
Coal Merchant’s Paper Records
Customer / Address / Delivery Round / Delivery PersonMrs Williams / 4 High Street, Ledbury / 3 Wednesday / Matt
21/10/2010
Fuel / Amount / Price / Total
Anthracite / 10 bags / 9.70 / 97.00
House coal / 5 bags / 7.96 / 39.80
Total / 136.80
VAT 5% / 6.84
Amount due / 143.64
Make / Type / Fuel
Aga / Cooker / Phurnacite, Anthracite
Stovax / Stove / Coal, wood
Esse / Range stove / Wood
2010Module102Assignment1.doc 18/09/13 Bob Higgie