Advanced Database Concepts DL (ADCON.DL) U22389Semester 1, 2018-19 assessmentThe first few pages of this document set out important guidelines and other information relating to this assessment. The remaining pages consist of the actual assessment.1 Information relating to this assessment1.1IntroductionThe assessment for this unitThe assessment for Advanced Database Concepts DL consists of a single piece of individual coursework, which is worth 100% of the marks for this unit. The unit specification states the following:Assessment will be via a single coursework, attempted individually, worth 100% of the marks for the unit. The work will be unsupervised, tutor assessed, and cover all of the learning outcomes. The deliverable will be a single report submitted at the end of the unit. The report will cover analysing a chosen case study, designing and implementing a relational database based on that case study, answering questions based on topics from the unit syllabus, and reflecting on their work.Students will be able to submit draft copies of parts of their assessment to the tutor at specific times during the unit, for formative feedback.Learning outcomesThe learning outcomes for this unit, which this assessment relates to, and as per the unit specification, are as follows:1 Review the theoretical underpinning of the relational model, and apply that to building a relational database for a small business application, from given user requirements.2 Optimise a database design for commercial operation, taking into account dataindependence, transaction scheduling and recovery procedures.3 Critically discuss and explore the advantages, disadvantages and issues that relate to DDBMSs, web-based databases, and new database technologies to accommodate big data (structured and unstructured data).In tandem with the above, this assessment on the following page therefore consists of:●a case study (Students choose ONE from case studies provided)●questions relating to that case study, which also will include a question askingyou to reflect on your work.1.2Anonymity of work1
All work must be submitted anonymously. You should therefore ensure that you do not include your name anywhere on your work, either in the main body of your report, the appendix, or in any headers or footers.1.3Plagiarism and poor scholarshipWhere relevant, extracting sections from the internet or other sources, including them in your assignment, and passing them off as your own work is not acceptable, and will be penalised with a fail result. Copying the work of your fellow students is also not acceptable.Use respected websites for your information gathering. To avoid plagiarism rewrite using your own words, but where you have used the ideas of others do acknowledge the source within the text and provide the full sourcein the references at the end of the document (using Harvard APA 6 format). The majority of your document will need be referenced, unless the idea is an original one of your own. If you are not sure how to reference, use the information provided by the Library (see moodle section).1.4Submission InstructionsDropbox: about a week before the scheduled submission date, a ‘dropbox’; will be created in the Moodle unit for ADCON.DL, which you will use to upload your Coursework assignment.Work handed in after that date and time, will incur a LATE penalty (see 20-day rule in Unit handbook)Your work will still be marked, but marks will be capped to 40%.You should submit a report consisting of:●Main body of report: your coursework answers●Appendix to your report: your SQL code for the Create Tables statement, insert statements and creation of primary and foreign key statements as well as your SQL queries.Formatting and presentation of your report:The word limit (depending on case study) is 4000-5000 words +/- 10%, but should only be used as a guide as your personal interpretation of an in-depth analysis of thecase study will determine the length of your final report.●Add page numbers to each page●Adhere to word count specified for a question2
●Clearly label each question according to coursework question numbers●Keep your work anonymous (only student number)●Check your work for plagiarism●Reference work used to support theory discussions1.5Submitting draft copies for guidance and formative feedbackYou can submit draft work during the week(s) 3 December - 12 December 2018, if you want me to give you some guidance and formative feedback by 14 December (last day of term).Please note that the coursework is the only assessment for this unit and it is therefore longer and more comprehensive than coursework where the unit hasmultiple assessments.2.ADCON DL –Assessment Case study and QuestionsYour answers should specifically relate to the case study. Be cautious to not just provide generic answers!Choose ONE of the following two case studies for your coursework analysis.2.1CASE STUDY A3
OPC (Olympics Preparation Committee)OPC is challenged with the daunting task to administer all activities related to the preparation phases for the Olympics 2020.They need your help to design a centralized database to manage data and generate reports to support the administrative planning and functions for the “Preparation Phase” prior to the main Olympics. This database will integrate with a number of other systems which falls beyond the scope of this task.OPC members are currently based in Tokyo (full-time) but have representatives in allmajor world cities as well as mobile agents travelling between cities and sport venues.The Olympics is less than two years away and all over the globe, teams and managers are starting to prepare. OPC needs to keep track of all preparation phase activities, the teams (detail on country, athletes, sport...), managers (personal detail), coaches, type of sport, venues, bookings for training sessions and venues, media coverage, marketing, health and safety, security, athlete health data, performance tracking data and more.OPC accumulated a list of approved venues (indoor and outdoor) that will be used by teams for preparation.All athletes will take part in a global health tracking initiative and will wear tracking devices during the preparation and training phases prior to the main events. OPC is responsible to provide data structures to manage performance and health data generated via the tracking devices.4
End of preview
Want to access all the pages? Upload your documents or become a member.
COMP1686- Web Database Applications Contributionlg...
COMP1635 Professionalism in the ITlg...
COMP1551 Application & Web Development: Assignmentlg...
COMP1632 Systems Development Projectlg...
Data Analysis and Design: Assignmentlg...
MATI3006 Numeracy 1 Coursework Brief Spring 2018lg...