i had attached the files
Event Organiser Database CSE1IS – Information Systems Assignment 2, Semester 2 2020 System Design and Implementation Due Date: 10.00 am - Wednesday, 7th 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. ( CSE1IS – Assignment 2 ) ( 1 /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. 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.