Analytical thinking has always been an important skill, but nowadays, it has become an even…
Help me with my ITECH 5006 Database Management System Assignment
Help me with my ITECH 5006 Database Management System Assignment
Assignment Description
Get the best assignment help from MakeMyAssignments.com
Assignment Help Australia
ITECH 1006 / 5006 Database Management Systems School of Science, Information Technology and Engineering CRICOS Provider No. 00103D Assignment 1 Specification – Semester 3 2013 – 201327 Page 1 of 5 Assignment 1 – Development of an ER Diagram and Database Implementation Course Objectives: This assessment task focuses on the following course objective: use entity‐relationship diagrams to design a relational database. Due Date: Thursday of Week 6 at 17:00 (see Course Description for further dates and times). Project Specification AS Adventure Sports (ASAS) is a business that organises outdoor activities e.g. rock climbing, abseiling, mountain biking and surfing for individuals and organisations. You have been asked by Peter, its managing director to design a database to assist them with managing their booking, customer and equipment provider information. You are only required to provide the design of the database at this time. ASAS would like to store information regarding their customers. Customers can either be individuals or group customers. Group customers may include corporate, government, school or religious groups. For individual customers they would like to store the contact name, address details (including their location, postal and delivery address details), email address and phone numbers (mobile, home, work). For group customers they would like to store the business name, a contact name, address details (including their location, postal and delivery address details), email address, website URL, and phone numbers (mobile, work). Additionally, for their corporate customers they would like to store the business name, business type (markets in which they operate) and number of employees. For government customers they would also like to store the department name, level of government (local, state, federal) and number of employees. For school groups they would also like to store the type of school (private, public,religious) and number of students and for religious groups, the denomination. ASAS provides equipment for their outdoor activities. They would like to record both the detail of the equipment available and also record what has been used (and the quantity) for each activity. The equipment provided is quite varied in type and size but may include complete items for example mountain bikes, surfboards or climbing equipment or smaller items for example ropes, carabiners, connectors or harnesses that make up those larger items. Sometimes in the case of group items e.g. climbing gear, the group item is used and in other cases individual pieces are used for the activity. All available pieces of equipment should be recorded in the one table with the relationship between group and individual items included. The equipment is hired from equipment providers. One piece of equipment may be available for hire from more than one provider and a provider might hire out one or many pieces of equipment. So in addition to recording the equipment available for hire, ASAS would like to record what provider has this equipment ITECH 1006 / 5006 Database Management Systems School of Science, Information Technology and Engineering CRICOS Provider No. 00103D Assignment 1 Specification – Semester 3 2013 – 201327 Page 2 of 5 available and also keep a register of their providers, including such details as provider identifier, name, contact name, address details (location, postal) and phone numbers (mobile, home, work). As well as providing equipment for the activity, ASAS provides trainers to assist with the activity and records these details. The trainers are provided by hiring them from trainer providers and an activity may have trainers assigned from one or more trainer providers. ASAS would like to keep a record of these trainer providers and the names and details of the trainers available for hire. For trainer providers the information recorded should include provider identifier, name, contact name, address details (location, postal) and phone numbers (mobile, home, work). For the trainers the information recorded should include trainer provider, identifier, christian name, surname and mobile phone. It is a competitive field so a trainer may be hired out by more than one trainer provider. A trainer may have certain skills that make them more attractive for some events than others. These skills e.g. ‘abseiling’, ‘wind surfing’, ‘biking’, ‘lifesaving’ should be recorded separately as desirable skills and then be available for assigning to trainers as details of the trainer are entered/changed. For each activity ASAS would like to store details such as where the activity is to be held, the customer who they are organising the activity for, the date and time of the activity, where the activity will be held, the type of activity and how many people will be at the activity. As already mentioned, details are also recorded of the equipment used (and quantity) for the activity as well as the trainers used. Each activity will have one trainer who takes on the role of activity manager. ASAS understands that they may not have provided you with sufficient information. If you need to make assumptions about their organisation please ensure that you record these. Assignment Submission You should produce a single pdf file, created using Word, containing all of the requirements as specified within this document. Your lecturer will provide details of how the file is to be submitted within lectures. The design document should contain: 1. A completed copy of the SITE Assignment Coversheet. 2. An appropriate title page that includes an acknowledgement of all students you have spoken to about the assignment. 3. A table of contents and automatically generated page numbers. 4. An entity relation diagram that models the problem which includes: a. all entities, relationships (including names) and attributes; b. primary (underlined) and foreign (italic) keys identified; c. cardinality and participation (optional / mandatory) symbols; and d. assumptions you have made, e.g. how you arrived at the cardinality / participation for those not mentioned or clear in the business description, etc. The E‐R should be completed using the standards of this course (crow’s feet). 5. Relational data structures that translates your E‐R diagram which includes: a. relation names; b. attribute names; c. primary and foreign keys identified; and ITECH 1006 / 5006 Database Management Systems School of Science, Information Technology and Engineering CRICOS Provider No. 00103D Assignment 1 Specification – Semester 3 2013 – 201327 Page 3 of 5 d. for each relation the level of Normalisation achieved, and for any not to Third Normal Form, explain why. e. The data structures should be shown using the standards of this course. 6. A relational database schema that translates your relational data structures which includes: a. table names, b. column names and field types c. primary and foreign keys identified 7. A bibliography, in APA format, containing all re
sources used to complete the assignment. If no resources have been used please indicate this appropriately. Your assignment should be completed according to the University of Ballarat General Guide for the Presentation of Academic Work. This is available online at the following web address: http://www.ballarat.edu.au/generalguide ITECH 1006 / 5006 Database Management Systems School of Science, Information Technology and Engineering CRICOS Provider No. 00103D Assignment 1 Specification – Semester 3 2013 – 201327 Page 4 of 5 Example of submission Example: A student can borrow many books from library and a book can be borrowed by many students. 1. An entity relation diagram that models the problem which includes: 2. Relational data structures that translates your ER diagram STUDENT(StudentID, FirstName, Surname, StreetName, Suburb, Postcode) BOOK(BookID, Title, Author, Publisher, Edition, ISBN, Price, YearPublished) BOOKLOAN(StudentID, BookID, LoanDate, Due) Notes: STUDENT is in 2NF. There is a transitive functional dependency among StudentId, Suburb and PostCode. Suburb doesn’t introduce big? redundancy (only one attribute and there is no potential redundancy), there is no need to decompose this table into two. The relational data structure of BOOK and BOOKLOAN is in 3NF. Assumptions: A student can borrow many books but some students may not borrow any book A book can be borrowed by many readers but may never be borrowed 3. A relational database schema Table Name Field Type Description Student StudentID Number Primary key FirstName text(30) Surname text(30) BookLoan StudentID Number Primary key; foreign key reference to Student.StudentID borrowed by borrows Involved in involves STUDENT StudentID FirstName Surname StreetName Suburb Postcode BOOK BookID Title Author Publisher Edition ISBN Price YearPublished BOOKLOAN StudentID BookID LoanDate Due ITECH 1006 / 5006 Database Management Systems School of Science, Information Technology and Engineering CRICOS Provider No. 00103D Assignment 1 Specification – Semester 3 2013 – 201327 Page 5 of 5 BookID Number Primary key; foreign key reference to Book.BookID LoanDate Date Primary key Format: dd/mm/yyyy Assessment Criteria 1. How clear and well presented your submission is. 2. E‐R diagram: adherence to our standard, assumptions made, inclusion of correct primary and foreign keys, appropriate entities, relationships, and attributes. 3. Normalisation: appropriate interpretation of each normal form, arguments for leaving the schema in the normal form you consider optimal. 4. Conversion of E‐R diagram to relational schema: schema is a correct translation of the E‐R submitted with appropriate tables, columns, and primary keys. Assignment 1 – Marking Overview ER Diagram / 21 Relational Structure / 7 Relational Schema /7 Documentation /5 Total/ 40 (worth 20% overall)
Related Posts
Balancing multiple responsibilities is a hallmark of Japanese culture, with education and work often taking…
Picture this: a sun-soaked afternoon, your friends are gearing up for an epic game of…