115.107 Management Information Systems

115.107
Management Information Systems
Assignment
The assignment is marked out of 100 marks, distributed as noted below, and is worth 25% of your
final grade
Due on Monday, 10 September 5pm NZ time
Deliverables
1. Submit 2 files via Stream assignment upload link
An assignment report (documentation) for parts 1 to 4 using either Microsoft Word or
Open Office Writer.
The assignment report is a “paper trail” of what you have done while working on the
assignment. It will include a contents page, and many screen shots of your progress.
A suggested template will be available on Stream.
Make sure that the report is well presented. To fully appreciate your work, markers
need to be able to find your answers, and to understand everything you did. How to
style and format your report is explained in part 5 of this document. Marks are awarded
for the correct use of word processing features and overall presentation.
A database file for parts 2 and 3 using either Microsoft Access or Open Office Base
You are given a partially completed database, Microsoft Access or Open Office Base
which you will download from Stream. In parts 2 and 3 you will add database tables, add
data and create queries / reports on data. This takes place within the given database.
Note: How to submit assignment files via Stream is covered in Module 1 exercises.
When assigning marks, markers will rely both on your report, and on the database. If a
feature that should be both in the database and in the report is present in only one of them
(for example, a database query present in the database, but not documented in the report),
you may lose marks for that feature
2. Completed Wiki pages (Part 5) on Stream
You are required to create a few Wiki pages and add some content to these pages via
Assignment Part 5 Wiki on Stream. Markers will be able to access your pages and mark your
work.
Note: within this document the terms
report, database and spreadsheet are
used.
These terms correspond respectively
to Word or Writer, Access or Base,
Excel or Calc, depending upon
whether you are using Microsoft
Office, or Open Office
2
Overview of this document
How to Approach this assignment
Part 1 – Data modelling a business scenario with Entity Relationship (ER) diagram
Part 2 – Implement the relational model in a database
Part 3 – Query data and report within the database
Part 4 – Export data to a spreadsheet, analyse and display information graphically
Part 5 and on-going – maintain a wiki
How to approach this assignment
The main aim of this assignment is to test the knowledge and skills you gain by completing software
exercises in modules 1 to 6 of this paper (over weeks 1 to 6). In the exercises you learn new concepts
and develop hands-on technology skills. You are expected to be working on the software exercises
and on the assignment more or less simultaneously: acquire skills by doing software exercises and
immediately apply them by completing the relevant parts of the assignment.
In addition, the assignment involves a small number of tasks not covered by the exercises, to offer
you an experience in resolving IT problems by relying on using software help systems and the
Internet as sources of technical information.
Carefully complete the exercises
It is impossible to fully understand what is required in the assignment (let alone, complete it) unless
you carefully complete the exercises first. Before attempting Part 1 of the assignment, complete the
relevant software exercises. Once you have attempted Part 1, complete the exercises relevant to
Part 2. And so on.
There is just one exception from this recommended sequential approach: it is recommended that
you briefly take a look at Part 5 from the very start, even before you start working on Part 1.
The Wiki pages you are going to create in Part 5 are devoted to various aspects of your experiences
in working on the assignment, so you might want to note your experiences as you proceed.
Take sufficient time (about 5 weeks)
Skills acquisition takes time and practice. You do need about 5 weeks to complete the exercises and
the assignment. Needless to say, attempts to cram 5 weeks’ work into one week are unlikely to
result in good outcomes.
Expect to do and re-do most of the artefacts
It is highly likely that you will revisit most of the assignment deliverables more than once.
For example, as you work on the rest of the assignment, you are likely to gain a better understanding
of both the meaning of ER notation and of the exact requirements for the ER diagram you complete
in Part 1. Therefore, you would go back to Part 1, and adjust the ER diagram to reflect your better
level of understanding. Expect to go over several versions of each artefact you create. Do not expect
to “get everything right” on the first attempt.
3
Part 1: ER diagram (25 marks)
Complete Module 3 Exercises before you start working on this part of the assignment.
A Simple Property Management System – Original Scenario

Britton Real Estate offers services to owners who want to lease their properties as dwellings.
Such properties include, for example, houses and apartments, but do not include industrial buildings,
nor offices.
Britton’s legal team draws up leases that need to be signed by one property tenant only, who then
takes responsibility for the rental, or monthly lease, and the on-going physical condition of the
property. This tenant is the lessee and there is only one tenant who can take this role, even if there
are multiple individuals residing at the same property, such as students renting a house or
apartment.
The lease placed on a property has a start and end date. Any property may have many leases
associated with it over time.
Britton’s property manager is responsible for properties under Britton’s management, arranging
tasks such as garden maintenance, window washing, electrical and plumbing repairs. Properties are
serviced by various service providers according to the service required.
A property is always serviced by at least one service provider.

We are the Best!

course-preview

275 words per page

You essay will be 275 words per page. Tell your writer how many words you need, or the pages.


12 pt Times New Roman

Unless otherwise stated, we use 12pt Arial/Times New Roman as the font for your paper.


Double line spacing

Your essay will have double spaced text. View our sample essays.


Any citation style

APA, MLA, Chicago/Turabian, Harvard, our writers are experts at formatting.


We Accept

Secure Payment
Image 3