Information system
CSE1IS – Assignment 2

1/3

CSE1IS – Information Systems Assignment 2, Semester 2 2020

System Design and Implementation

Due Date: 10.00 am – Monday, 12th October 2020

Objective To apply theoretical concepts of System Design and System Implementation in a case study.

This is an INDIVIDUAL assignment. You are not permitted to work in a group when writing

this assignment.

Copying, Plagiarism: This is an individual assignment. Students are not permitted to work in a group when writing this

assignment. Plagiarism is the submission of another person’s work in a manner that gives the

impression that the work is your own. La Trobe University treats plagiarism seriously. When

detected, penalties are strictly imposed.

Further information can be found on http://www.latrobe.edu.au/plagiarism/plagiarism.html

Submission Guidelines: • Your assignment submission should be typed, not written/drawn by hand. Use CASE tool

or any software to draw figures in your assignment.

• Submit the electronic copy of your assignment through subject LMS. The submission facilities will be setup 5 days before the assignment is due.

• Submission after the deadline will incur a penalty of 5% of the final assignment mark per day. If you have encountered difficulties that lead to late submission or no submission, you

should apply for special consideration. No assignment is accepted after 4 days’ delay.

http://www.latrobe.edu.au/plagiarism/plagiarism.html
CSE1IS – Assignment 2

2/3

Problem Description

“Our Pound” is an organisation that rescues surrendered animals, lost animals, and on-death-row

animals from other pounds. The organisation specializes in saving cats and dogs. Since their

establishment, they maintained their administration using paper-based system. They keep

information about all the cats and dogs they have been cared for. They also keep information

about their clients, who have adopted their animals.

Some clients adopt cats and dogs more than once. And unfortunately, few cats and dogs have to

go through the pound more than once for several reasons, such as the client was becoming

unavailable, the animal “clashed” with other family members, to name a few.

This year Victorian government introduced an excellent regulation to remove the holding time of

animals in pounds. Even though it is an excellent movement, the regulation creates problems

since the number of animals has exceeded the capacity of several big pounds such as RSPCA,

Lost Dogs Home, etc. Many animals have now been transferred to smaller pounds such as “Our

Pound”. They cannot manage the administration using a simple paper-based system anymore.

They want a simple database that can maintain this simple task.

Your job is to design and implement a small information system, which will help the pound to

store information of their current and past animals in their care. It includes the information about

the name, breed, type (Small Size Dog (SSD), Medium Size Dog (MSD), Large Size Dog (LSD),

Shorthair Cat (SHC), and Longhair Cat (LHC)), description, color, weight, and the date they are

brought into “Our Pound”. The system should also keep the information about the clients who

have adopted animals from the pound. For every adoption transaction, the adoption date should

also be recorded.

In addition, your other job is to design a summary annual report for adoption. The report should

list the number of animals adopted in each municipality and suburb, ordered alphabetically by

the municipality and suburb name. The animals listed should be grouped based on 5 types of

animals stored in your database. For each municipality, the total number of adopted animals for

each type should be shown. Finally, at the bottom of the report should be the same statistics for

the whole Victoria.

Assumptions

• Assume that if an animal is returned to the pound by a client, the system will not generate a new animal ID, instead it uses the old animal id.

• Assume at the moment you can only deal with clients living in Victoria. • Any other assumptions should be stated clearly.

CSE1IS – Assignment 2

3/3

Your Tasks:

PART I – SYSTEM DESIGN

1. Prepare an ER diagram for the database. Follow the correct notations for the diagram. All relationships must be labelled with cardinality information. [8 Marks]

2. Create a schema for each table. Ensure that all fields/attributes are listed and the primary key is clearly underlined. Identify foreign keys where applicable. Below is a template of the schema.

Please follow the example below:

TableName(PrimaryKey ?attribute1, attribute2, …, attributeM, refAttribute1, … refAttributeN)

where refAttribute1, …, refAttributeN are foreign keys [7 Marks]

3. Draw paper design for the summary report. The design should clearly identify the report header/footer, page header/footer, identifying fields, totals, etc. You should follow good output design

principles. [20 Marks].

PART II – SYSTEM IMPLEMENTATION

4. Use MS Access to create the tables for the Our Pound Pet Adoption systems. For the submission, you need to provide screen captures that clearly shows the tables and their

attributes, as well as the relationship. Please see example below from your lab works. [15

Marks].

5. Use MS Access to create the input screen that can be used as entry point for animals and clients details to the database. For the submission, you need to provide screen captures that clearly shows the

input form [15 Marks].

6. Use MS Access to create the report following the design in task 3. You need to use the data stored in your tables (not hard-coded!). For the submission, one generated report should be provided.

[35 Marks].

NOTE: You need to populate the tables with at least 20 rows/tuples each. It will ensure your

reports show some interesting data for the next task.