Data Modelling and Data Managing



Assessment Details and Submission Guidelines









Unit Code

MN405





Unit Title

Data and Information Management



Assessment
Data Modelling  and Data Managing


Title







Weight

20% of total assessment for the unit



Word limit
No specific word limit




Description of
This assignment consists of three parts:


this

Part A: An online quiz on Moodle, comprising 30 questions.


assignment:
In Week 7 / 8 Lab classes.


This quiz covers basic concepts of the relational data models. Students may have up




to 3 attempts to answer this quiz.  The system will keep the highest score.


Part B:






Question 1 (a) and (b) - Assignment 1 database creation Submit in Week 6.


Question 1 (c)-(d) SQL Queries to extract data from data tables Submit in



Week 8




Question 2 - questions on mapping conceptual data models into relational data



model. Submit in Week 8.




Question 3 - Model organisational information requirements – BI tool to visualise



data. Submit in Week 8.







Part C: Performance demonstration
Only during week 7 or week 8 lab classes


Assignment Description

Part A: Quiz


The quiz will open only in week 7 and week 8 lab classes.

Paste below the summary of your Assignment 1 quiz results from Moodle.

Part B: Data Modelling


Question 1                                                                                       


The snapshot of OlympicGames database structure is given in Figure 1.

Assume that, you are working as an IT specialist in an organisation and are required to extract information from this database by building the database and executing SQL queries according to the instructions given below.

The primary keys and foreign keys are marked and entered in the OlympicGames database, shown in figure1.





a.  First, you need to create the above database in MS Access. Create only four tables Events,Competitors_on_events, Competitors and Venues.                  

b.     Populate those tables with suitable data (at least 3 records per table).

i.   You can use Datasheet view in MS Access or SQL statement (as given below) to enter suitable data records.

INSERT into TableName

VALUES (“..”,”..”,.....)

ii.   Include Proper foreign keys to create relationships in between tables.

Hint: If you want to create a one-to-many relationship in your database, include one side primary key in the many side table as foreign keys.


NB:

You need to create and upload your database on submission link only during the week 6 laboratory class.

This is an individual assignment; it should be your own individual work (You should not copy Ms Access Database). If not, it is considered as cheating and you will get zero marks for the whole assignment.

Write SQL queries for the following questions.

a. Execute the queries on the “OlympicGames” database you created in MS Access. Include screen shots of the outputs and all SQL statements you used to answer following questions:


b.
Prepare a list of all the records in the “Venues” table where Seat_Capacity is greater than 400.

You are required to sort the list in descending order of “Venue_Name”.

c.
Assume that you want to count how many Competitors registered for the event with event_ID

=”T20”. Write a query to find the number.


d. Display Competitors_ID, first_name, Last_name and Gender for all competitors registered for the event with event_ID =”T20”

(Hint: Join Customer table and Booking table)                     
Question 2






Figure 2 shows the ER diagram that captures important information about Students, Courses and classes in MIT.





Figure 2: Data Model for Student course registration

a.  Convert the ER diagram into a relational database schema. Be certain to indicate primary

keys (underline).

Eg. Student (StudentID:text; Student_name:text,…..)







NB: You are required to identify many-to-many relationships in the ER diagram and include Associative / Bridge entities.

Question 3                                                                                       

“NoSQL”, the name was chosen as a Twitter hashtag to simplify coordinating a meeting of developers to discuss ideas about the nonrelational database technologies that were being developed by organizations like Google, Amazon, and Facebook to deal with the problems they were encountering as their data sets reached enormous sizes. There are literally hundreds of products that can be considered as being under the broadly defined term NoSQL

(Reference: Chap 14-3 -Database Systems: Design, Implementation, & Management Ⓒ 2017 ISBN 9781305627482-By Carlos Coronel and Steven Morris)

Answer following questions.
a.   Describe the term “NoSQL databases”.

b.  What are the four basic categories of NoSQL databases? Describe briefly.
c. Create 2 Data visualizations using Tableau. Use data provided in “Resources/ Sample Data

(https://public.tableau.com/en-us/s/resources )” section in the Tableau.





First you need to install Tableau App. Instructions are given below.

Tableau (www.tableau.com) is a data visualization tool. Tableau can help anyone see and understand their data. Connect to almost any database, drag and drop to create visualizations. Install Tableau Public (https://public.tableau.com/s/ ) on your laptop / computer and create any 2 visualization’s.

Follow the following instructions:

i.     First go to Tableau Public https://public.tableau.com/s/ and enter your email address and select “Download the App”





ii.    Then you can download the software and run the .exe file to install.





iii. Now you will get the following starting screen. Here you can upload MS Excel or MS Access file. Watch this video to find more details on “How to”. https://public.tableau.com/en-us/s/resources






iv.   You can use any data set in available in Resource section of Tableau

(https://public.tableau.com/en-us/s/resources) to create 2 visualisations. It should be your own individual work.


Part C:


2.     Performance Evaluation

Demonstrate your progress to your tutor in week 7 or week 8 lab classes.

This will allow students to demonstrate their understandings and skills (to their teacher) as they perform these activities. The teacher evaluates you on the quality of your ability to perform specific tasks and the products you create in the process. Your final mark for this assignment will be calculated based on this evaluation as describe below.      
                    
 To get solution visit our website www.sourceessay.com


Location: Melbourne VIC, Australia

Comments

Post a Comment

Popular posts from this blog

Assignment Help: Add Valuable Factors In Your Learning Skills

Image
The end to end process of acquiring new information and process it to meet requirements is known as the ability to learn. Learning is a combination of various skills that are required by students to process information efficiently. Broadly speaking learning skills can be categorized into four categories- critical thinking, creative thinking, communicating, and collaborating. In this article, we are going to briefly discuss the valuable factors that add essence to the learning skills of students. Critical Thinking - The careful analysis of information for better understanding is known as critical thinking. With the help of critical thinking students can develop the following abilities- Analyzing, Arguing, Classifying, Comparing & Contrasting, Defining, Describing, Evaluating, Explaining, Problem Solving, and Tracking cause and effect. In case a student faces difficulties while implementing these abilities in an assignment they can seek  instant essay help  from SourceEssay  essay
Read more

Language Techniques Every Student Must Know

Image
For every student to write an impressing assignment it is important that the assignment is written in a language that makes it easy for the readers to understand whether the piece of work is an essay, story, poem, novel or a report. The elements that are found everywhere in the piece of work is known as language techniques .  Today we are going to talk about common language techniques that should be known to every student in order to write an engaging assignment. Importance Of Language Techniques In Assignment Writing Language techniques are important because it improves the quality of the assignment as a result students are able to create appealing assignments and score well. Apart from this language techniques help students create an impact with their writing. It helps them craft their work using transactional, creative, and oral presentations. Moreover using language techniques students are able to achieve unit standards that helps them to explore language about transactional, poeti
Read more

The Helpful Essay Writing Guide: Structure, Outline, Tips And Format

Image
Essay writing is an art that involves, skills of writing, technical knowledge, and understanding of the subject. There are various types of essays each involves different structures, tones, techniques, and even the length of it differs. Students face a lot of challenges while writing essays mostly because of language barriers and lack of technical knowledge and writing skills. Students are seen taking external help from professionals to write quality essays to overcome these barriers. This is why  essay Deutsch   has gained immense popularity in Germany among academic students. In this article, we are going to share some tips with students on how to structure, outline, and format an essay. Even though the specifications of essay writing change with the kind of essay the basic structure of the essay remains the same.  Structure Of An Essay   The basic structure of an essay comprises three parts namely the introduction, body, and conclusion. Introduction   The introductio
Read more