Title of Assignment: Design and Implement A Solution for a GIS problem.
Module Learning Outcomes for This Assignment
|
||||
Part 1
Assignment Information – Read This.
(a) This assignment is weighted at 50%.
(b) The assignment must be completed on an individual basis.
(c) You must implement in Oracle 11g or higher (or similar database) (or an agreed database with the module leader)
(d) The assessment allows you to demonstrate your skills in database design, development and tuning. It does not consider user interface and there are no marks for interface design and development in the assignment. You are strongly advised to use the simplest possible interface that will allow you to demonstrate your work.
(e) You must include all the scripts used for the assignment. We must be able to recreate the database if necessary
v:* {behavior:url(#default#VML);}
o:* {behavior:url(#default#VML);}
w:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
96
800×600
Normal
0
false
false
false
EN-GB
X-NONE
X-NONE
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:”Table Normal”;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:””;
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:”Times New Roman”,serif;}
The Problem
A retail business is trying to establish the best layout for its shop.
Unfortunately, the shop is in the basement of a department store and the escalator is positioned in the centre of floor layout [at (0,0) in the above diagram].
The common-sense approach of the owner is that a significant portion of the customers visit the bargain bin section and they are trying to work out where to locate it. Their vision is that it should be in the quietest section of the shop.
The business is open 9 to 5, Monday to Saturday.
The owners require that the date, day, time, location and value of each individual purchase made by a customer is recorded. The location maps to the 10 by 10 grid shown about.
They do not need to know any personal details about the customers, just how much is paid for each item rated as low, medium and high, and where those goods are located in the shop.
MILESTONE ONE
Your first task is to establish the requirements for the system.
You tutor will act as the primary user of this system over the couple of weeks and will clarify the scope of the project (if needed).
(The initial requirements list should be based on the queries required – refer to section 2-2)
You will then produce a requirements list and a physical database design.
MILESTONE TWO
You will implement your design, incorporating your individual set of test data and will demonstrate via the creation of a user manual.
MILESTONE ONE DESIGN (20% of total marks for part 1)
(a) Establish requirements – 5%
Produce a list of requirements based on the information provided. You may also need to produce an assumptions list.
(b) Data Modeling (15%)
Develop a physical design for the whole scenario. This may include an Entity Relationship Diagram which shows entities, attributes, primary and foreign keys etc. Data must be in 3NF or higher. You may use any consistent notation you wish.
You are not required to create CD, DFDs or normalize.
You have to create a complete picture of the data structures – column names, data types, sizes, default values etc
MILESTONE TWO IMPLEMENTATION
(2.1) Implement the design. (20 % of total marks for part 1)
You should demonstrate use of all the following and may include any other appropriate elements that you wish.
Tables
Sufficient test data to support the queries
Appropriate constraints
Potential Automatic entry of PK values (perhaps using sequences and a trigger)
(2.2) Queries (40 % of total marks for part 1)
Create the following queries/features. All queries must be commented and show skills like sorting, ordering, functions etc.
Please include the SQL script or a screen dump of the script along with proof that the query works.
a) What day of the week is the quietest.
b) What hour of the day is the busiest.
c) Which grid location generates the most income.
d) A report on how many items are bought in the 3 price ranges (low, medium and high)
e) A follow on report showing a breakdown by hour of purchases in the price ranges.
f) Which grid location(s) generates no income.
Queries a to d are each worth 5 marks
Queries e to f are each worth 10 marks
(2.3) Reflection (20% of total marks for part 1)
Reflect on the solution you have provided and comment on how accuracy could be improved.
What could be changed to improve the decision making processes for the shop owner.
Part 2 Theory
Assignment Information – Read This.
(a) This assignment is weighted at 50%.
(b) The assignment must be completed on an individual basis
|
1. CRITICALLY EVALUATE THE ROLE OF GRAPHICAL AND GEOGRAPHICAL INFORMATION SYSTEMS IN THE WORK PLACE. |
Enquiry |
|
Knowledge & Understanding |
|
|
Reflection |
Part 1 of the assignment was to develop a basic Management Information System.
The word count for this section is 1,500 words. There is no direct penalty for going over this limit, but you are expected to be professional.
The second part of the assignment is to compare and contrast the Management Information System (MIS) that was developed in part 1 with the requirements of a Graphical Information System (GIS).
It is expect that the report will focus on the role of GIS in the your profession but could report on associated disciplines.
It is expected that you will define what MIS and GIS are, and these definitions will not count towards the word count.
The focus is to be on what GIS offers your role and how databases support GIS.
Marking Scheme
Notes:
A simply note dump based on the lectures / web material / books will result in a mark of no more than 50% and depending on referencing will be a lower.
It is expected that you will research outside of the domain of the material covered on the course.
Using reference sources like Wikipedia will result in a mark being limited to 20%.
Your mark will be limited to 25%, if your assignment falls into any of the following categories:
a) You have used overlong quotes.
b) You have not mapped your findings to the scenario.
c) You have not referenced correctly (using Harvard referencing style)