IS1S451 Information Systems Analysis and Design 1 Assignment | USW

IS1S451 Assessment Cover Sheet and Feedback Form 2025/26

Section A: Record of Submission

Record of Submission and Plagiarism Declaration

I declare that this assignment is my own work and that the sources of information and material I have used (including the internet) have been fully identified and properly acknowledged as required in the referencing guidelines provided.

Fit to Sit Policy

The University operates a Fit to Sit policy whereby all students, in submitting or presenting themselves for any assessment, are declaring that they are fit to sit the assessment.  Students cannot subsequently claim that their performance in that assessment was affected by extenuating circumstances.

 You are required to acknowledge that you have read the above statements by writing your student number(s) above. 

Details of Submission

Note that all work handed in after the submission date and within 5 working days will be capped at 40%.  No marks will be awarded if the assignment is submitted after the late submission date unless extenuating circumstances are applied for and accepted.

• IT IS YOUR RESPONSIBILITY TO KEEP A RECORD OF ALL WORK SUBMITTED.
• An electronic copy of your work should be submitted along with a paper version.
• Work should also be submitted to the member of academic staff responsible for setting your work.

Work not submitted to the lecturer responsible may, exceptionally, be submitted (on the submission date) to the SA of the Faculty, which is in the SA’s Office of Coleg Gwent.

Extenuating Circumstances

if there are any exceptional circumstances that may have affected your ability to undertake or submit this assignment, make sure you contact the Course Coordinator on 01633 466052 (B307).

Section B : Marking and Assessment

Learning Outcomes

This assignment addresses the following learning outcome(s) of the module:

LO1: Analyse the requirements for an information system and produce a design that satisfies these requirements

Assessment Criteria

Section C : Marker’s Feedback

Detailed Requirements

This coursework has three distinct parts.  Please ensure that you read the requirements clearly and submit the appropriate documentation for each.

You have been tasked with developing an Information System for analysing and querying crime data for South Wales.  (This is a global objective which is common to all three courseworks, but considers different aspects).  This first coursework considers different user views of a Crime Information System and the requirements or functionality of such a system; and the Class Model (Entity-Relationship Model) of a proposed Crime Information System.

Part 1: User Views of an Information System (30%)

In order to gain some background knowledge to the problem and to see a Crime Information System in action, you should spend some time exploring www.police.uk.  Type in your postcode or some geographic locations and study the output data produced (crime maps, types of crime, outcomes, quantity of crimes, and variation in crimes through time, by month).

In Weeks 1 and 2 of the Course we looked at different views of a system depending upon the user, stakeholder or hierarchical level of an organisation.  For a Crime Information System, different users or stakeholders will require different types of information from such a system.  For example, users may be members of the public (the intended audience for www.police.uk visitors), police officers, the Chief Constable, the local authority, the local community council, the National Assembly, the local MP and/or AM, and of course your neighbourhood burglar or drug dealer.

Consider 5 different stakeholders, and for each, consider three different queries (or useful knowledge / information) which they would benefit from by using a Crime Information System.  (The system is hypothetical, so can consider functionality far beyond what is available from www.police.uk).  For example, a Chief Constable might want to know where best to deploy any spare police officers based on the crime data; a parent might want to know if the local school is in a drug-dealing area; while a burglar might want to know if the number of solved burglaries in Pontypridd is increasing month-on-month.  The list of queries is completely open-ended and is intended for you to think about what different user groups can get out of such a system.  Don’t use the 3 examples above and try to be diverse and imaginative in your answers, i.e. don’t repeat the same query for different users, nor repeat the query say for a different crime type.  You can go far beyond the functionality of the www.police.uk information system if you so wish. Submit your Queries or required Information for each stakeholder / user as a simple list:

User 1:

Q1

Q2

Q3

User 2

Q1

Q2

Q3

etc.

User 5

Q1

Q2

Q3

You May Find It Easier to Consider These Queries AFTER Studying the Requirements for Part 2.

Part 2: Class Model for a Crime Information System (55%)

At www.police.uk, the queries and analysis is mainly based upon one table (Crime Class) with the following attributes: CrimeID (Primary Key), Year and Month, Police Authority, a Geographic Location (Lat/Long or Easting and Northing / x,y coordinate), a Geographic Location Description, and the Crime Type.

Using this as the starting point, you are required to develop a Class Diagram (Entity Relationship Model) based on the following information gained from a meeting of key stakeholders (Police, Councillors, Community Leaders, etc.).  The Crime Class can be extended to consider other attributes as identified below.

• Each crime location falls inside one geographic area. (For the purpose of this Exercise, a Geographic Area is defined generically as being a police beat or census area or postcode, i.e. they all cover the exact same area).
• Police Officers are usually assigned to two or three geographic areas; Police Specials (Volunteers) and Community Officers are assigned to one geographic area; while Traffic Police are assigned to many geographic areas.
• Each crime will be assigned to a police officer in charge of the case; usually, more than one officer will investigate a case.
• Each geographic area has associated demographic and lifestyle data associated with them. These would include population, employment and unemployment data, number of retired people, type and size of households, number of single parent households, number of students, car ownership, etc. together with dozens of other attributes.  (Read up on the UK Census for more information on data captured and the attributes you believe should be represented within this class).  Many of these data values are best presented as a normalised variable, e.g. Percentage Unemployed, % Retired, % Students, or a lifestyle indicator such as Deprivation Index (Poverty descriptor).
• A Crime is committed by one or more Offenders.
• An Offender will have a home address in one geographic area.
• A Gang is usually composed of two or more Offenders.
• A Gang will operate in more than one geographic area.
• The Police also record “Outcomes” of each Crime which presents the results of their investigations, the current status of the case, and the sentence handed out to the offender(s). (See the Outcomes section of police.uk for further information).  This data is presented independently of the Crime Records on the web site, but should be directly represented within this Class Diagram.
• Each crime will usually have one or more Victims. Each Victim will have a home address in One geographic area, but the crime (e.g. car crime, theft, GBH) may have taken place somewhere else (as noted in the corresponding Crime record).  Each Victim will be issued with a Crime Number to easily identify the case.

From this information, produce the corresponding Class Diagram.  The Class Diagram should contain the classes that make up your system; the relationships between those classes; and the nature of the relationships (multiplicity and optionality).  You are also required to label the relationships appropriately.

From the class diagram, you are also required to produce a small data dictionary that lists the attributes that make up each class.  Given the attributes for each class you are then required to identify both the primary and foreign keys for each class.  You are advised to adhere to the style/format of the Class Diagrams as presented in lectures.  The data dictionary (attributes) should also list the appropriate data type for representing that field (e.g. string, percentage, date).

Part 3: Extended Class Model (15%)

In Part 1, you have identified some queries or information which would be useful to derive from a Crime Information System.  Hopefully, most of these queries can be answered from the eventual system you’ve designed in Part 2.

Identify one of your queries which you believe can not be answered from the proposed IS (due to missing class(es) and/or relationships).  Document how you would extend your Class Model to consider this additional information.

If you believe all of your queries in Part 1 are covered by your Entity relationship model, then consider an additional query to extend the model further.

SUBMISSION:

You must submit ONE document in either DOC / DOCX / PDF format entitled 16123456.doc (or .docx .pdf) where “16123456” is YOUR enrolment number to your course tutor on or before 16^th January 2017. Alternatively, your tutor will advise you on whether submission can be made by paper copy; and where / when to submit it.

*** PLEASE CHECK the formatting of your document before Submission (i.e. group your figures together, as Word can move your figures – or parts of them around).  If you save your document as a PDF, then the format will remain fixed. ***

The post IS1S451 Information Systems Analysis and Design 1 Assignment | USW appeared first on Students Assignment Help UK.