Title: SIT103 Assignment 1 Group:☐ Individual:☒ Graded out of: 100 Weight: 15% Due date: Week 5 Wednesday 5pm 25 Nov 2020 Submission: Online:☒ Hardcopy:☐ Instructions: • Students submit using the submission drop box located in the Assessment Information section. • Use proper citation for each question, and list all references in the reference section of the report. • Use credible sources to get the related information and answer the questions in your own words. • Label your answers properly, e.g. Q1(a), Q1(b), Q1(c) and so on • Submit a copy of your answers in a single document (PDF format only – A penalty of 5 marks will be applied for any other formats), electronically by the due date. Summary: Research on the topics listed in the questions; student findings are then presented in a report. All reference must be properly cited. Key Criteria • Topics have been researched and addressed • Answers reflect a good understanding of underlying key concepts • Number of words in assignment is within the prescribed limit • Clarity of writing and quality of presentation • Proper citations of findings Relevant Content Weeks & ULOs ☒ Week 1 ☒ Week 2 ☒ Week 3 ☐ Week 4 ☐ Week 5 ☐ Week 6 ☐ Week 7 ☒ Week 8 ☒ Week 9 ☐ Week 10 ☒ Week 11 ☒ Week 12 ☒ ULO1 ☒ ULO2 ☐ ULO3 Describe the techniques used in storing and retrieving data. Evaluate data models and apply data modelling techniques to capture the data aspects of real- world situations Design and develop relational databases by using SQL and a database management system Please read the full assignment details that follow. Assessment Summary Late Submission and Extension Policy • All students should submit an assignment by the due date, whether it is completed or not. • A student, who has a just cause, may email the unit coordinator and apply for an extension before the due date (unless they are hospitalised or other extenuating circumstances that prevent this – please refer to special considerations procedure in the unit outline). All applications must be accompanied by evidence of the disadvantage. • Note: Late Assignments will attract a penalty of 5% of the total marks for each day that you are late. After one working week, your assignment will not be accepted. Instructions • This is an individual task that requires students to prepare a report of 1000 words, plus or minus 10%. • Research on the topics listed in the questions below and create a report presenting your findings. • Write the answer to each questions in your own words • Label your answers properly, e.g. Q1(a), Q1(b), Q1(c) and so on. • Use proper citation for your answer to each question, and list all references in the reference section of the report. Use Harvard referencing only. • Cover page (include: student number, name and a signed statement that mentioned all the work is your own work.). Failing to include one will attract a penalty of 5 marks. • Submit your answers as a single document in PDF format only. All submission must be made electronically via the submission portal (in the Assessment Information section), which will open in week 5 prior to the due date. Question 1 (20 marks) a) What is Big Data? (5 marks) b) Name and discuss the three V’s used to define Big Data. (15 marks) Question 2 (20 marks) a) Define following database models: (5 marks) i. Conceptual ii. Internal b) Outline the key considerations and steps taken to map an E-R model into a relational model. (15 marks) Question 3 (20 marks) a) Compare and contrast Blockchain with traditional networks. Tabulate (format as shown below) and discuss three differences. (15 marks) Blockchain Traditional networks Discussion … … … b) Identify and briefly explain two underpinning technologies that power the Blockchain to guarantee its integrity and trustworthiness. (5 marks) Question 4 (15 marks) a) What is SQL? What is its primary purpose? (3 marks) b) Identify its three key language components. Briefly explain each with an example of how each is used. (12 marks) Question 5 (20 marks) a) Identify and briefly explain the three data anomalies found in a database design. (9 marks) b) What is normalisation? Name the three normal forms and their associated rules. (9 marks) c) In resolving data anomalies, what exactly has normalisation achieved in a database design? (2 marks) References (5 marks) Use proper citation for each question. List all references in the reference section of the report.
欢迎咨询51作业君