FIT2094-FIT3171 Databases 2021 Semester 2
Assignment 1B - Full Database Model and Implementation
Monash Movement (MM)
FIT2094 Learning Outcomes: 2, 4, 5, 7 (see Unit Preview)
FIT3171 Learning Outcomes: 2, 4, 6, 8 (see Unit Preview)
Assignment weighting 15%
Assignment marked out of 100 and released as a grade out of 15
This task continues the work you have started in assignment 1A by refining/extending the model y
developed and implementing it as a set of tables under your Monash Oracle database account.​

Researchers measured the data speeds for a particular smartphone carrier at 50 airports. the highest speed measured was 78.1 mbps. the complete list of 50 data speeds has a mean of x overbarequals16.11 mbps and a standard deviation of sequals18.65 mbps. a. what is the difference between carrier's highest data speed and the mean of all 50 data speeds? b. how many standard deviations is that [the difference found in part (a)]? c. convert the carrier's highest data speed to a z score. d. if we consider data speeds that convert to z scores between minus2 and 2 to be neither significantly low nor significantly high, is the carrier's highest data speed significant? a. the difference is nothing mbps.

Where can page numbers appear? check all that apply. in the header inside tables in the footer at the bottom of columns at the top of columns

Use a software program or a graphing utility with matrix capabilities to solve the system of linear equations using an inverse matrix. x1 + 2x2 − x3 + 3x4 − x5 = 6 x1 − 3x2 + x3 + 2x4 − x5 = −6 2x1 + x2 + x3 − 3x4 + x5 = 3 x1 − x2 + 2x3 + x4 − x5 = −3 2x1 + x2 − x3 + 2x4 + x5 = 5