ICT285 Databases
Assignment 1
Individual Assignment (20% of the final mark for the unit)
Please check the LMS for the due date
Submission Instructions:
Please submit a SINGLE Word/PDF document using the link in Moodle. The due date is on
the LMS. You MUST include your student number as part of your document. Your name and
student number MUST also be included within 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.
• The deadline for submission will be specified in LMS. Murdoch University’s new
Assessment Policy states that any submission received after the specified due date (i.e. is
submitted late), will not be marked, and will instead, receive a grade of 0 (zero). The only
exception will be if an extension has been requested prior to the due date stated.
• 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.
• This unit uses software called Ouriginal when viewing work that you submit. TurnItIn 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.
• The University takes academic integrity very seriously. Instances of academic misconduct
include Submitting work that has been produced by someone else or in part of whole using
Artificial Intelligence tools. More information about academic integrity is contained within
the Murdoch Academic Passport (MAP) unit
https://www.murdoch.edu.au/mymurdoch/support-advice/learning-study/murdoch-
academic-passport
This assignment requires you to answer several 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:
, 1. Apply your knowledge of relational database principles and theory to create effective
and efficient database designs.
2. Define, create, and manage relational database systems using SQL.
You will need to ensure that your materials reflect a high professional standard*. The marks
allocated for the Assignment will be allotted in terms of the percentages shown in the
following table.
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
*Formatting and presenting your assignment appropriately are important, and the
assignment includes marks for the overall organisation and presentation of the document
(up to 5 marks). This includes marks for things such as:
• Standard Font Size and Colour i.e., Arial/12.
• Formatting and layout: double line spacing, page number, separate sections
(Headings/Subheadings), aligning paragraphs.
• Includes a title page and table of contents. Correct use of equations, footers, and
headers.
• Good technical style, avoiding excessive jargon, grammar, and spelling errors.
Before you submit your assignment, make sure to check the formatting and overall
presentation of your document. Make sure the file type is a single MS word document. If
you're not sure about what’s required contact your teaching staff or UC.
Assignment 1
Individual Assignment (20% of the final mark for the unit)
Please check the LMS for the due date
Submission Instructions:
Please submit a SINGLE Word/PDF document using the link in Moodle. The due date is on
the LMS. You MUST include your student number as part of your document. Your name and
student number MUST also be included within 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.
• The deadline for submission will be specified in LMS. Murdoch University’s new
Assessment Policy states that any submission received after the specified due date (i.e. is
submitted late), will not be marked, and will instead, receive a grade of 0 (zero). The only
exception will be if an extension has been requested prior to the due date stated.
• 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.
• This unit uses software called Ouriginal when viewing work that you submit. TurnItIn 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.
• The University takes academic integrity very seriously. Instances of academic misconduct
include Submitting work that has been produced by someone else or in part of whole using
Artificial Intelligence tools. More information about academic integrity is contained within
the Murdoch Academic Passport (MAP) unit
https://www.murdoch.edu.au/mymurdoch/support-advice/learning-study/murdoch-
academic-passport
This assignment requires you to answer several 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:
, 1. Apply your knowledge of relational database principles and theory to create effective
and efficient database designs.
2. Define, create, and manage relational database systems using SQL.
You will need to ensure that your materials reflect a high professional standard*. The marks
allocated for the Assignment will be allotted in terms of the percentages shown in the
following table.
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
*Formatting and presenting your assignment appropriately are important, and the
assignment includes marks for the overall organisation and presentation of the document
(up to 5 marks). This includes marks for things such as:
• Standard Font Size and Colour i.e., Arial/12.
• Formatting and layout: double line spacing, page number, separate sections
(Headings/Subheadings), aligning paragraphs.
• Includes a title page and table of contents. Correct use of equations, footers, and
headers.
• Good technical style, avoiding excessive jargon, grammar, and spelling errors.
Before you submit your assignment, make sure to check the formatting and overall
presentation of your document. Make sure the file type is a single MS word document. If
you're not sure about what’s required contact your teaching staff or UC.
