Using MySQL 8.xx create a database with the following characteristics. .

A. Your design MUST meet the requirements for Third Normal Form

B. Create a database (you will need multiple tables) to store employee information. This information will include:

Employee Number, First Name, Last Name, Date of birth, Address, city, state, zip, department, job title, supervisor, health insurance number, health insurance provider, dental insurance number, dental insurance provider, spouse/partner, children, children's ages.

C. Populate the table with multiple records which will cover all possible relations.

Note: Determine which fields are required and which fields are optional. Determine the correct data types and sizes for each field. Include the 'relationships' between the tables. Hint: You will need some secondary key fields to link tables together.

What to turn in:

Screen shots (only)

1. Database table metadata showing table names, column names, data types and sizes.

2. Map of relations between tables (tables with arrows between them).

3. Contents of each table with related data.

Design a database through the EER diagram to keep track of the teams and games of a sport league. Assume that the following requirements are collected (the English description of cardinal ration and partial/complete participate is NOT required, but you still need to provide the total/partial and cardino ration in your EER diagram) :

The database has a collection of TEAM. Each Team has a unique name, players, and owner.

The database also keeps the records of PLAYERS. Each player has the attributes of SSN, player_name, and team to indicate which team they belong to. PLAYERS are SPECIALIZED into either MAJOR_LEAGUE or MINOR_LEAGUE. Information captured about objects in the MAJOR_LEAGUE includes salary; Information captured about objects in the MINOR_LEAGUE includes level (such as 1A, 2A, or 3A)

GAME stores the attributes of the following: a unique game number, date, time, filed and MAJOR_LEAGUE players who participate the game. It is categorized into HOME and GUEST; Home stores the TEAM which plays in the home game and GUEST stores the team which plays as the guest TEAM. Information captured about objects in the HOME includes ticket_income. GAME also stores a calculated attribute called total_player_participate.   

Year

               Technology          Energy

2000:          -24.31            30.47

2001:          -38.55           -12.49

2002:          -36.89           -11.61

2003:           68.59            27.84

2004:         -9.98            35.94

2005:          17.81             70.70

2006:          3.79               -2.12

2007:          -3.13              29.30

2008:        -42.51           -48.25

2009:        79.03              40.13

2010:        45.03           34.25

2011:         -12.21          -8.76

what I have to find. There are 2 data FUNDS in the file: Technology and Energy.

1) For each fund, compute using Excel: the Average, Median, Mode, the first percentile, the third percentile.

2) Graph the Box-Plot for each fund (called Box and Whisker in Excel).

3) For each fund, compute using Excel: the Range, Mean Absolute Deviation, the variance, the standard deviation and the coefficient of variation.

4) Using Excel, compute the Sharpe-Ratio for each fund using the risk free return of 3%. 5) Using Excel, compute the correlation between both funds.

asses US economy from 2000-2020

My philosophy of nursing essay. 2000 words

Please complete the following code in challenge.c. The code for main.c and challenge.h is below that. (Don't edit main.c or challenge.h, only edit challenge.c) The instructions are in the comments. Hint: the_person is declared in main, so you need to define it in challenge.c using extern

challenge.c

#include "challenge.h"

//return: struct

//param: (struct person p1, struct person p2)

//TODO: create a function that returns the person who has a higher GPA.

// 1. if GPAs are equal, then return the first person (the first parameter).

// Hint: this function can only be called in the file where it is declared, so You might need to put a key word before the function declaration.

struct person compareTo(struct person p1, struct person p2) {

return null;

}

//return: void

//param: (struct person persons[], int len)

//TODO: create a function that assign the person who has the highest GPA to the variable the_person defined in main.c.

// 1. use compareTo() function to find the person who has the highest GPA.

// 2. update the value of the_person in main function to the person.

// Hint: this function can only be called in the file where it is declared, so You might need to put a key word before the function declaration.

void find_the_person(struct person persons[], int len) {

}

main.c

#include "challenge.h"

struct person the_person;

// return the person who is older.

struct person compareTo(struct person p1, struct person p2){

if (p1.age >= p2.age){

return p1;

}

return p2;

}

// return the oldest person.

// update the value of the_person to the oldest person.

void find_the_person(struct person persons[], int len){

if (len <= 0) return;

the_person = persons[0];

for(int i = 1; i < len; i++){

the_person = compareTo(the_person, persons[i]);

}

}

// main function for non-test code

// This exists solely for the benefit of the students to test their own code

int main()

{

printf("Hello, World\n");

}

challenge.h

#include <stdio.h>

#ifndef CH_HEAD

#define CH_HEAD

struct person {

char name[20];

int age;

double GPA;

};

#endif

According to the empirical evidence the quantity theory of money is

There are numerous empirical studies that provide evidence that the birth of children influences both a mother’s and father’s labor force participation. Use the theory of labor force participation of individuals to explain this relationship. Do you think that the birth of a child will have a positive or negative effect on the mother’s labor force participation? What about on the father’s labor force participation?

The morphology-density relation is an empirical law that suggests that the higher the density of galaxies is the higher the fraction of ellipticals becomes in galaxy clusters/groups. In these clusters and groups of galaxies, all member galaxies appear to be bound by gravity that is caused by the presence of all these galaxies, that is, by their masses.

Question: Given that the galaxy groups/clusters are bound by gravity, explain why the morphology-density relation makes sense. Of course you are required to make a physically sound argument.

Use the Empirical Rule. The mean speed of a sample of vehicles along a stretch of highway is 71 miles per​ hour, with a standard deviation of 4 miles per hour. Estimate the percent of vehicles whose speeds are between 63 miles per hour and 79 miles per hour.​ (Assume the data set has a​ bell-shaped distribution.) Approximately what ​% of vehicles travel between 63 miles per hour and 79 miles per hour.