Category | Assignment | Subject | Computer Science |
---|---|---|---|
University | Murdoch University (MU) | Module Title | ICT581 - Information Systems Principles and Practice |
Due date: | Sunday, 1 June 2025, 11:55 PM |
Worth: | 25% of your final grade (10% individual assessment + 15% group assessment) |
Assignment no.: | 2 |
The following question is based upon the BIRD relation below, which lists information about the birds of the USA1 . You can assume the data is representative. Note that scientific names are generally used worldwide for plants and animals to eliminate ambiguity, as common names can vary between countries.
You have been asked to design a relational database based on this design. You know that there are problems with the current design and that it will need to be modified in order to work effectively.
Answer the following questions. Each question is worth 5 marks. Make sure you answer all parts of each question.
Are You Looking for Answer of ICT581 Assignment 2
Order Non Plagiarized AssignmentUse the case study description and list of requirements below to create an entity-relationship diagram showing the data requirements of the All You Need Are Toys Library database. Your ERD should be able to be implemented in a relational DBMS.
Toy libraries operate in a manner similar to book libraries, with members able to borrow a toy for a number of weeks then return it. As with book libraries, toy libraries enable families to have access to a wider range of toys than they might otherwise have, and to avoid spending money on toys that might be outgrown quickly or never played with2
Chester Merrythought has always remained a child at heart, so when she inherited a house in Fremantle she decided to use it to house a toy library. She began with her own old toys and those donated by some like-minded friends, and others sourced from op shops and garage sales. She has advertised her venture as the All You Need Are Toys Library, and it has grown rapidly. The house is small but has two rooms on the ground floor and three more on the first floor, up a flight of stairs. (There is also an attic room, which is not used at present.) Chester stores the toys in the four largest rooms, and uses the front room on the ground floor as her office where people can do the actual borrowing and returning of toys.
Each of the rooms houses a different category (or categories) of toy: games and puzzles; softies and dolls; arts and crafts; construction; and sports and activities. "Sports and activities" tends to include large heavy items such as basketball hoops and swings, and so this category is kept in one of the ground floor rooms, while more portable items such as jigsaws can be stored upstairs. Chester has fitted the rooms out with shelving, which is numbered so that an individual toy can easily be located according to shelf within a room (e.g. room 1, shelf 12).
Each toy in the library is described thoroughly. As well as the broad category (already mentioned), each toy is given a unique identifier, a descriptive name, a longer description, the age range it is suitable for; whether it needs batteries (and how many of which size); the material it is made of, and its general condition. Chester also keeps a record of who the toy was donated by.
It is free to join the library, and there is no age limit, but all members need to register before they can borrow any toys. Their name, address, contact phone number and email are recorded and they are given a membership number. Each ordinary member is able to borrow a total of 3 toys at a time, for a maximum period of 2 weeks. A member who has also donated a toy or toys to the library can borrow up to 4 toys at a time.
Chester also has plans to use the library to hold themed events (in nearby locations such as parks). Her idea is that members would bring appropriate toys or wear costumes for themes such as Harry Potter, Hallowe'en, or a teddy bears' picnic. Members wouldsign up for the event (there would be a maximum number of attendees for an event) and could also borrow a toy just for the event. Chester began by using a combination of paper records and an Excel spreadsheet to keep track of things, but has very quickly realised that there was a great demand for the toy library, and that she needs to put her recordkeeping on a more formal basis.
The specific areas she needs first are registering members and donors, creating an inventory of the toys, and keeping a record of what is on loan. She also wants to keep a record of the themed events: as well as when, where, and the theme, who attended and which toys were borrowed for the event.
Below are several queries and reports that the All You Need Are Toys Library database must be able to support. There may well be many others as Chester analyses her venture and plans for the future; therefore, you should design for flexibility as well as ensuring your ERD could answer these questions.
Achieve Higher Grades ICT581 Assignment 2
Order Non Plagiarized AssignmentAre you looking for the best online assignment help for your ICT581 - Information Systems Principles and Practice Assignment 2? You don't have to stress anymore. So get expert guidance and free assignment samples to help you prepare high-quality answers. We are ready to assist you. Our Computer Science Assignment Help ensures accuracy, clarity, and strong reasoning. If you are wondering, "Who can help me with my assignment?"—you are at the right place. Get started today and submit with full confidence. Your success in criminal law starts here!
Let's Book Your Work with Our Expert and Get High-Quality Content