Murdoch UniversityICT 285ICT285 2020 Assignment 1 2020 Databases September Trimester, 2020

Document Content and Description Below

ICT285 Databases September Trimester, 2020 Assignment 1 Individual Assignment (20% of the final mark for the unit) Submission Instructions: Please submit a single word document using the link in ... Moodle. The due date is on LMS. 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. From the Unit Information Guide: - It is your responsibility to keep a copy of any assignment handed in for assessment. Make sure you keep a copy of the final (submitted) version as well as the backups you make as you create the assignment. It is recommended that you also keep a hard copy of any written assignments. - It is especially important to maintain regular backups of all your practical work. You should ensure you keep a separate backup on a thumb drive, cloud or similar. It is recommended that you keep both a hard copy and an electronic copy. - Late submission will be penalised at a rate of five percent of the total marks available for the assignment per day (or part thereof). The deadline for submission will be specified in LMS and on the assignment. Each assignment will have a final date by which the assignment will be accepted for marking. Assignments not received by the final date WILL NOT BE MARKED and will be recorded as a 0. - Under exceptional circumstances an extension can be provided. Extensions for assignment submissions can only be granted if requested in advance of the due date for submission, and with a good reason. Applications for extensions should be made to the Unit Coordinator, not to the student's lecturer/tutor who is unable to grant extensions. If an extension is granted, the Unit Coordinator will tell you at the time of granting it whether any penalty in marks will apply to the submitted work. - This unit uses software called Urkund when viewing work that you submit. Urkund is a pattern-matching system designed to compare work submitted by students with other sources from the internet, journals/periodicals, and previous submissions. Its primary purpose is to detect any submitted work that is not original and provide a thorough comparison between the submitted document and the original sources. - More information about how to avoid plagiarism is contained within the Murdoch Academic Passport (MAP) unit https://moodleprod.murdoch.edu.au/course/view.php?id=2684 University policies on academic integrity can be accessed here: http://our.murdoch.edu.au/Educational-technologies/What-you-need-to-know/This assignment requires you to answer a number of questions on relational database principles and SQL, and to design a database based on a case study. The assignment addresses the following learning outcomes for the unit: LO 2. Demonstrate an understanding of relational database principles and theory LO 3. Demonstrate practical skills in using SQL LO 4. Demonstrate practical skills in data modelling using entity-relationship modelling LO 5. Demonstrate practical skills in normalisation and convert a conceptual database design to a logical design in 3NF (partly) Marks are distributed as follows: Question 1: Relational algebra 20 Question 2: SQL Select queries 20 Question 3: Further SQL 15 Question 4: Normalisation 20 Question 5: Conceptual design 25 Total 100 [Show More]

Last updated: 3 years ago

Preview 1 out of 12 pages