Get Cheapest Assignment in Australia, UK, US, UAE, Canada and NZ Order Now

Get FIT5195 S1 2022 Take Home Test by Punjab Assignment Help

0 Comments

Are you worried about your FIT5195 S1 2022 Take Home Test that you need to submit to the professor but cannot present due to some issues like time and complications in the assignment? So now you no need to worry about your assessment with Punjab Assignment Help.

Due date: Week 5 – Tuesday, 29 March 2022, 11:55 pm (AEDT)

G9 Education Case Study

Get FIT5195 S1 2022 Take Home Test by Punjab Assignment Help
Get FIT5195 S1 2022 Take Home Test by Punjab Assignment Help

G9 Education is a private Australian provider of quality early childhood education and care. They recently implemented a simple database system. The system includes information about their daycare centres, teachers, and children who attend the centre. The simple database system consists of the following tables and attributes:

Due to an increasing number of incidents happening in the daycare centres, the manager of G9 Education requires a data warehouse for analysis purposes. The analysis is needed for identifying the incident type that occurs with the highest frequency, the total cost per incident type, etc.

You are required to design a small data warehouse to keep track of the statistics. The manager is particularly interested in analysing the number of incidents and total incident cost by incident type, month (e.g., Jan, Feb), daycare centre, teacher, course, and age group points of view.

For the age group, the manager wants to be able to drill down based on two different age groups: pre-kinder (between 1 and 2 years old), and kinder (between 3 and 5 years old).

The operational database tables from G9 Education can be accessed through the MonChild

account. You can, for example, execute the following query:

select * from MonChild.<table_name>;

Tasks in FIT5195 S1 2022

[1]. Develop a G9 Education star schema. Identify the fact table, dimensions and attributes required to support the schema. The result of this task is a star schema diagram. If you are using a bridge table, make sure to include weight factors and list aggregate attributes.

You can use any drawing tool, such as Lucidchart, to draw the star schema.

[2]. Validate your star schema using the two-column table methodology. You are required to illustrate the two-column tables for all fact measures and dimensions in your star schema design.

[3]. Write the SQL commands to create the fact and dimension tables. You need to create a script file containing the appropriate SQL commands to create the fact and dimension tables. Each dimension must have an ID or a surrogate key. The operational database tables are accessible through the MonChild account.

The result of this task is the SQL commands. You will also need to show SQL commands and the contents of the tables that you have created.

[4]. Write the SQL commands to answer the following queries, and show the results:

  1. Show the total number of incidents and total incident costs by age group.
  2. Show the total number of incidents and total incident costs for the teachers whose roles are Early childhood teacher, and show the course they took previously as well.
  3. Show the total number of incidents and total incident costs by incident type in March.
  4. Show the total number of incidents and total incident costs by daycare center.
  5. Show all information of the teacher who has the smallest number of incidents.

Submission checklist:

  1. One pdf file containing:
    • The star schema diagram – Task 1
    • The Two-Column Table Methodology illustration – Task 2
    • The SQL commands to create all dimension and fact tables, as well as the contents of these tables (the contents can be in the form of screenshots) – Task 3
    • The SQL commands to answer the queries in Task 4 and the query results. You can take screenshots of the results.
  • Two .sql file containing:
    • The SQL commands to create the data warehouse.
    • The SQL commands to answer the queries in Task 4.

(Note: The marker will run the .sql file. You need to ensure that the SQL commands are written correctly and clearly with proper comments in the .sql file and runnable without errors).

  • Name    your pdf file containing all tasks listed in [A] in this format: THT_ Yourname_StudentID.
  • One ZIP folder:
    • Save all .sql file from [B] and in one folder.
    • Name the folder THT_SQL_StudentID.
    • ZIP the folder to THT_ SQL_StudentID.zip. This must be a ZIP file and not other types of compressed folder. The zip file should contain the prescribed files as listed in the Submission Checklist.

Submission Method:

  • The assignment submission must be made through Moodle by the due date:Tuesday, 29 March 2022, 11:55 PM (AEDT).
  • The submission of this assignment must be in the form of a single PDF file AND a single ZIP file. No other forms will be accepted.
  • Penalty for late submission: 10% deduction for each day, including the weekends.

Submission Cut-off time: Tuesday, 5 April 2022, 11:55 PM(Submission link will be unavailable after the cut-off date).

What Are the Reasons You Should Take Experts’ Help for FIT5195 S1 2022 Take Home Test help From Punjab Assignment Help?

If you are looking forward to taking help from the experts of Punjab Assignment Help for including FIT5195 S1 2022 Take Home Test help, and are looking for the reason why you should do so, then here are some points:

  1. When you lack subject knowledge, you should seek our services to clear the concepts through assignments.
  2. When you lack a flair for writing, seek help from experts who possess exemplary writing skills to impress your professor easily.
  3. When you lack time, use our help and deliver your document before the deadline.

We hope you got some solid reasons to order with us for your assignment. And remember! You can contact us at any hour of the day via call, text, or mail, and we will be there to help you through it! So, reach us now!