Study schedule (next page) The anticipated study schedule is shown on the next page; however, you should always check LMS for up to date details. The 12 unit topics fall into six groups of two related topics, corresponding with the six main delivery sessions over the teaching period. Session 1: Introduction and overview; the relational model Session 2: SQL and normalisation Session 3: Conceptual and logical database design Session 4: Physical database design and database security Session 5: Transaction management and database architectures Session 6: Databases for business intelligence; non-relational databases
Murdoch University 11Study schedule Session Topic Workshop Assessment 1 Topic 1: Introduction to databases Lab 1 –Introduction to Oracle and SQL Quiz 1 2 Topic 2: The relational model Lab 2 –SQL: the SELECT statement; the Oracle data dictionary Quiz 2 3 Topic 3: SQL Lab 3 –SQL: more on the SELECT statement Quiz 3 4 Topic 4: Normalisation Lab 4 –SQL: INSERT, DELETE, UPDATE; data definition Quiz 4 5 Topic 5: Conceptual database design Lab 5 –Entity-relationship modelling Quiz 5 6 Topic 6: Logical database design Lab 6 –Converting an entity- relationship model to tables Quiz 6 Assignment 1 7 Topic 7: Physical database design and security Lab 7–Physical design Quiz 78 Topic 8: Tuning the physical design Lab 8 –Query processing Quiz 8 9 Topic 9: Transaction management Lab 9 –Transactions and concurrency Quiz 9 10 Topic 10: Database architectures and database programming Lab 10 –PL/SQL Quiz 1011 Topic 11: Databases for Business Intelligence Lab 11 –Oracle’s analytic functions Quiz 11 12 Topic 12: Non-relational databases Lab 12 –Non-relational databases Quiz 12 Assignment 2 UNIT REVISION
Murdoch University 12Assessment Assessment for this unit is conducted in accordance with the Assessment Policy. Schedule of assessment items Internal and external students will be assessed on the basis of two assignments, weekly quizzes, and a final examination. AssessmentDescription Value Learning outcomes addressed Indicative Due Date* Assignment 1 SQL, normalisation, relational algebra and conceptual design 20% LO 1,3,4,5 End of session 3 Assignment 2 Database implementation 20% LO 5,6,7 End of session 6 Online quizzes Related to the week’s lecture and lab work 10% LO 1-11 Fortnightly during teaching weeks Final Examination Short and longer answer questions 50% LO 1-5,7-11 Assessment period *Always check the LMS for definitive due dates. Assessment details Detailed instructions for assessment items, including the due date and time, and the assessment criteria, will be included with each of the assessment items. A brief summary is given below. All of the assessment is individual. Written feedback will be provided for the assignments. •Assignment 1: requires you to answer a number of short questions on relational database principles and SQL, and to design a database based on a given case study.