ASSESSMENT 2 BRIEF
Subject Code and Title MIS201 Database Fundamentals
Assessment Presentation
Individual/Group Individual
Length 10 minutes
Learning Outcomes The Subject Learning Outcomes demonstrated by successful completion of the task below include:
a) Analyse specific organisational needs that can be addressed by collection, storage and management of organisational data.
d) Apply and communicate the database solutions for specialists and non-specialist stakeholders.
Submission Due by 11:55pm AEST Sunday end of Module 4.1 (Week 7)
Weighting 35%
Total Marks 100 marks
Task Summary
In this assessment, you are required to perform database table normalisation and present your solutions in a PowerPoint presentation. In doing so, you are required to demonstrate your work and solution through a series of normal forms. You need to first normalise the database tables to the first normal form (1NF), then the second normal form (2NF), and finally the third normal form (3NF).
Context
In the first two modules, you learnt data models and relational data modelling. Next, you were introduced to the database table normalisation process in Module 3.1, which is aimed to enhance the quality of database tables. Normalisation plays a significant role in ensuring database tables are well structured so that both data redundancies and the likelihood of data anomalies can be minimised.
By completing this assessment, you will demonstrate your understanding of the following:
(1) the database table normalisation process and
(2) the criteria for database tables to be in 1NF, 2NF and 3NF as well as your ability to:
(1) comprehend business rules and logic to determine data dependencies,
(2) perform database table normalisation process and normalise database tables up to 3NF and
(3) articulate your solutions and the rationale to an audience.
Task Instructions
1. Examine the following STUDENT table, which is used for a student record management system in an Australian university.
Attribute name Sample value Sample value Sample value Sample value
STU_NAME (Primary
Key) Rhys Pickering Mandeep Kaur Manpreet Singh Xiao Zhang
STU_PHONENUMBER 0406465234, 03
9654 3316 0406475234, 03
9654 3336 0406467334, 03
9654 3318 0406469034, 03
9654 3319
STU_DOB 3/12/1997 4/8/1998 8/4/1997 5/6/2000
STU_HOMECOUNTRY Australia India India China
STU_CONTINENT Oceania Asia Asia Asia
STU_GENDER Male Female Male Female
STU_SCHOOL Business IT and
Engineering IT and
Engineering Business
STU_MAJOR Accounting Software Development Information Systems Finance
SCHOOL_HEAD Andrew Yue Suzanne Pita Suzanne Pita Andrew Yue
SCHOOL_PHONE 9054 1321 9067 1835 9067 1835 9054 1321
STU_SUBJECT Accounting
Principles,
Business Law,
Quantitative
Method Introduction to
Programming, Database
Fundamentals Introduction to
Programming,
Introduction to
Information
Systems Introduction to
Microeconomics,
Principles of
Finance
SUBJECT_LECTURER James,
Terry,
Wei Andrew,
Peter Andrew,
John June,
Fariza
SUBJECT_CODE ACCT1001,
BLAW1002,
QUAN1003 BIT1001,
BIT1002 BIT1001,
BIT1003 FINC1001,
FINC1002
SUBJECT_CREDITPOINT 6, 6, 6 12, 6 12, 6 6, 6
STU_SUBJECTMARK 60, 70, 80 50, 60 70, 80 70, 70
STU_AVERAGEMARK 70 55 75 70
STU_SUBJECTGRADE P, C, D P, P C, D C, C
2. Please complete the following tasks and deliver a 5-minute presentation to communicate your answers/solutions to an audience.
Task 1 (15 marks)
Draw and present a dependency diagram for the table above, including transitive dependencies. In your oral presentation, you need to explain each dependency.
Task 2 (5 marks)
If the table above is not in the first normal form, normalise it so that it is in the first normal form without creating any more tables. You may create an additional attribute or attributes. Orally present your solution and the reason why it was not in the first normal form, and what changes were made to make it in the first normal form. If the table above is in the first normal form, explain why it is in first normal form.
Task 3 (15 marks)
If the resulting table from the previous task is not in the second normal form, normalise it so that it is in the second normal form without creating any more tables. You may create an additional attribute or attributes. Orally present your solution and the reason why it was not in the second normal form, as well as the changes that were made to turn it to the second normal form. If the resulting table from the previous task is already in the second normal form, explain why it is in the second normal form.
Task 4 (30 marks)
If the resulting table from the previous task is not in the third normal form, normalise it so that it is in the third normal form. You may create additional tables. Orally present your solution and the reason why it was not in the third normal form, as well as the changes that were made to turn it to the third normal form. If the resulting table from the previous task is already in the third normal form, explain why it is in the third normal form.
Task 5 (15 marks)
Based on the resulting table from the previous task, draw and present an ERD to the audience. Please use LucidChart or an equivalent professional diagramming software application to draw the
ERD.
3. When completing this assessment, you are required to make reasonable assumptions based on common sense. For example, the following are considered as common sense or reasonable assumptions:
• Two persons may have the same name, that is, the same first name AND same last name.
• Two persons who were born on the same day may have the same name.
• A student will undertake more than one subject at a university.
• More than one subject may be taught by one lecturer.
• Each subject has only one subject name.
• Each School only has one Head of School.
Length and Layout of the Presentation
• The total presentation should be no more than 10 minutes. This includes a 5-minute question-and-answer session.
• Please prepare your presentation using Microsoft PowerPoint.
Submission Instructions
Please submit ONE PowerPoint Presentation (.ppt or .pptx) via the Assessment 2 section found in the main navigation menu of the subject’s Blackboard site. The Learning Facilitator will provide feedback via the Grade Centre in the LMS portal. Feedback can be viewed in My Grades.
Academic Integrity Declaration
Individual assessment tasks:
I declare that except where I have referenced, the work I am submitting for this assessment task is my own work. I have read and am aware of Torrens University Australia Academic Integrity Policy and Procedure viewable online at http://www.torrens.edu.au/policies-and-forms
I am aware that I need to keep a copy of all submitted material and their drafts, and I will do so accordingly.
Assessment Rubric
Marking Criteria F P C D HD
Subject Learning Outcome:
a) Analyse specific organisational needs that can be addressed by collection, storage and management of organisational data.
Task 1
? Draw and present a dependency diagram including transitive dependencies.
? Explain each dependency in the presentation.
15%
Subject Learning Outcome:
a) Analyse specific organisational needs that can be addressed by collection, storage and management of organisational data. Task 2
? Normalise the table to be in the first normal form, if it is not already in the first normal form.
? Discuss the solution and explain the reasons as to why the table was not in the first normal form, and what changes were made to turn it into the first normal form in the oral presentation.
? If the table is in the first normal form, explain why it is in the first normal form. 5%
Subject Learning Outcome:
a) Analyse specific organisational needs that can be addressed by collection, storage and management of organisational data.
Task 3
? Normalise the table to be in the second normal form, if it is not already in the second normal form.
? Discuss the solution and explain the reasons as to why the table was not in the second normal form, and what changes were made to turn it into the second normal form in the oral presentation.
? If the table is in the first normal form, explain why it is in the first normal form. 15%
a) organisa
Task 4
? Subject Learning Outcome:
Analyse specific organisational needs that can be addressed by collection, storage and management of tional data.
Normalise the table to be in the third normal form, if it is not already in the third normal form.
? Discuss the solution and explain the reasons as to why the table was not in the third normal form, and what changes were made to turn it into the third normal form in the oral presentation.
?
30% If the table is in the third normal form, explain why it is in the third normal form.
Subject Learning Outcome:
a) Analyse specific organisational needs that can be addressed by collection, storage and management of organisational data.
Task 5
? Draw and present an ERD base to the audience.
? Use LucidChart or an equivalent professional diagramming software application to draw the ERD 15%
Subject Learning Outcome:
d) Apply and communicate the database solutions for specialist and non-specialist stakeholders.
Effective Communication
? Ability to engage the audience.
? Clarity, pace and fluency.
? Clear and logical structure of the oral presentation.
20%
Fail (Unacceptable)
0-49% Fail grade will be awarded if a student is unable to demonstrate a satisfactory academic performance in the subject or has failed to complete the required assessment points in accordance with the subject’s required assessment points.
Pass
(Functional)
50-64% Pass is awarded for work showing a satisfactory achievement of all learning outcomes, and an adequate understanding of theory and application of skills. A consistent academic referencing system is used and sources are appropriately acknowledged.
Credit
(Proficient)
65-74% Credit is awarded for work showing a more than satisfactory achievement of all learning outcomes, and a more than adequate understanding of theory and application of skills. A consistent academic referencing system is used and sources are appropriately acknowledged.
Distinction
(Advanced)
75 -84% Distinction is awarded for work of superior quality in achieving all learning outcomes, and a superior integration and understanding of theory and application of skills. Evidence of in-depth research, reading, analysis and evaluation is demonstrated. A consistent academic referencing system is used and sources are appropriately acknowledged.
High Distinction
(Exceptional)
85-100% High Distinction is awarded for work of outstanding quality in achieving all learning outcomes, together with outstanding integration and understanding of theory and application of skills. Evidence of in-depth research, reading, analysis, and original and creative thought is demonstrated. A consistent academic referencing system is used and sources are appropriately acknowledged.