ICT285 2018 TSA Assignment 2.pdf - ICT285 Databases TSA...

This preview shows page 1 - 3 out of 5 pages.

ICT285 Databases TSA 2018 Assignment 2 Worth: 20% of your final grade. Due: Sunday 25 November 2018 11:55PM Submit to: LMS, via the Assignments tool. Submit Parts 1 and 2, Part 3 sample data and Part 4 CREATE VIEW statements as a SINGLE Word document. Parts 3 and 4 should be completed in Oracle on arion. Ensure you complete the declaration that is part of the submission process. You do not need to include a separate cover sheet but you should include your name and student number as part of your document filename. Your name and student number should also be included within in the assignment document. Late assignmentsthat do not have an extension will be penalised at the rate of 5% per day. This is an INDIVIDUALassignment. This assignment requires you to implement the database you designed to address some of the requirements of the GardenSwap case study in Assignment 1. You will need to incorporate any changes to your original design required as a result of the feedback on Assignment 1 both individually and as a class (e.g. on the online forum), and to address the additional/amended requirements listed in this document. The assignment addresses the following learning outcomes for the unit: 3. Demonstrate practical skills in using SQL 5. Demonstrate practical skills in normalisation and convert a conceptual database design to a logical design in 3NF 6. Create a database from a given design using a DBMS and implement specified constraints using appropriate tools and approaches 7. Explain and implement security as it applies in the database environment. Marks are distributed as follows: Part 1: Revised ERD and schema 10 Part 2: Data dictionary 20 Part 3: Implementation 30 Part 4: Views 40 Total 100
Case study Re-read the description of the GardenSwap case study in Assignment 1 Q5 if you need to refresh your memory. Also view any additional material that has been posted about hints and partial solutions. Astrid Winterblossom is pleased with your work so far and has asked you to go on to implement your design. However, like so many clients, she wants to make some changes to the requirements. As it turns out, people were not very keen on formalising the swapping part of their activities, although they would still like to view the various skills that other members have and are prepared to help others with. The swaps themselves will probably continue informally, but will NOT be recorded as part of the database at this stage. However, the event advertising part of Astrid’sgarden community has proved to be very popular, and she would like you to develop this part as a priority, with the resultant system renamed GardenFriends. She has a revised set of requirements based on feedback from the community. Astrid’srevised requirements are as follows: As before, all people who host or attend an event must be registered on the GardenFriends database, with the same requirements for registration information as stated previously. This includes a list of the services/skills they are prepared to offer. There are three categories of events: Open Gardens, where attendees are taken round a member’s garden where features of particular interest are pointed out; Skills and Techniques, where attendees learn skills such as composting or chainsaw maintenance; and Know Your Plants, which focuses on the cultivation of a particular species or group, such as roses or Banksias. Every event has an organiser, as well as an event leader who presents the event on the day (these may or may not be the same person). Some events also include additional helpers

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture