The Primary Key of the table recording this information is SheepID+WeighingDate. The table has not been...
The Primary Key of the table recording this information is SheepID+WeighingDate. The table has not been normalized beyond First Normal Form. That is, there are no ‘repeating groups’, but there may be Partial and Transitive Dependencies.
|
SheepID |
Owner |
Birthdate |
WeighingDate |
Vet |
Weight |
VetPhoneNum |
|
K3922 |
McNab013 |
2013-05-12 |
2013-08-14 |
M330 |
22 |
7633088852 |
|
K3922 |
McNab013 |
2013-05-12 |
2014-06-02 |
S929 |
34 |
7609865463 |
|
K3922 |
McNab013 |
2013-05-12 |
2015-08-02 |
M330 |
43 |
7633088852 |
|
K3922 |
McNab013 |
2013-05-12 |
2016-07-30 |
P301 |
53 |
7682907965 |
|
K3922 |
McNab013 |
2013-05-12 |
2017-08-12 |
P301 |
52 |
7682907965 |
|
K3922 |
McNab013 |
2013-05-12 |
2018-07-22 |
S929 |
51 |
7609865463 |
|
T8832 |
McNab013 |
2012-03-26 |
2012-08-14 |
K339 |
19 |
7602907550 |
|
T8832 |
McNab013 |
2012-03-26 |
2013-09-01 |
S929 |
26 |
7609865463 |
|
T8832 |
McNab013 |
2012-03-26 |
2014-08-15 |
K339 |
32 |
7602907550 |
|
T8832 |
McNab013 |
2012-03-26 |
2015-07-28 |
K339 |
40 |
7602907550 |
|
T8832 |
McNab013 |
2012-03-26 |
2016-08-11 |
T975 |
42 |
7646746741 |
|
P9742 |
Smith002 |
2014-05-10 |
2014-09-11 |
K339 |
14 |
7602907550 |
|
P9742 |
Smith002 |
2014-05-10 |
2015-08-10 |
S300 |
25 |
7629920821 |
|
P9742 |
Smith002 |
2014-05-10 |
2016-08-29 |
K339 |
35 |
7602907550 |
|
P9742 |
Smith002 |
2014-05-10 |
2017-09-01 |
S929 |
44 |
7609865463 |
|
P9742 |
Smith002 |
2014-05-10 |
2018-08-22 |
S929 |
51 |
7609865463 |
|
M3110 |
Smith002 |
2015-05-12 |
2015-09-12 |
S300 |
15 |
7629920821 |
|
M3110 |
Smith002 |
2015-05-12 |
2016-09-10 |
S300 |
26 |
7629920821 |
|
M3110 |
Smith002 |
2015-05-12 |
2017-08-17 |
K339 |
34 |
760290755 |
Question 1
Identify the Functional Dependencies in this table. Your answer should conform to the following format: If, taken together, attributes A and B determine C, show it this way:
A + B → C
Homework Answers
SheepId -->Owner, Birthdate
Owner -->SheepId, Birthdate
Birthdate -->SheepId, Owner
SheepId+WeighingDate --> Vet,Weight,VetPhoneNum,Owner,Birthdate
Vet -->VetPhoneNum
SheepId+Owner+WeighingDate --> Vet,VetPhoneNum,Weight
SheepId+Owner+Birthdate+WeighingDate -->Vet,Weight,VetPhoneNum
WeighingDate+Vet -->VetPhoneNum, Weight, SheepId,Owner, Birthdate
WeighingDate+Weight --> Vet, VetPhoneNum, SheepId,Owner,Birthdate
WeighingDate+Vet+Weight --> VetPhoneNum,SheepId,Owner,Birthdate
WeighingDate+Weight+VetPhoneNum --> Vet,Sheepid,Owner,Birthdate
WeighingDate+VetPhoneNum+Vet --> Weight,Owner,SheepId,Birthdate
SheepId+Vet --> VetPhoneNum
SheepId+Owner+BirthDate+Vet --> VetPhoneNum
SheepId+Weight --> VetPhoneNum
SheepId+Owner -->VetPhoneNum
Sheepid+Owner+BirthDate --> VetPhoneNum, Weight
SheepId+WeighingDate --> Owner,BirthDate,Vet,Weight,VetPhoneNum
WeighingDate --> Owner,BirthDate,SheepId,Weight,Vet,VetPhoneNum
WeighingDate+Owner --> SheepId,BirthDate,Weight,Vet,VetPhoneNum
Add Answer to:
The Primary Key of the table recording this information is
SheepID+WeighingDate. The table has not been...
Need help with C++ assignment Assignment 1 and .txt files are provided at the bottom. PART...
Need help with C++ assignment
Assignment 1 and .txt files are provided at the
bottom.
PART A
PART B
Assignment
1
#include <iostream>
#include <string>
#include <fstream>
#include <iomanip>
#include <stdio.h>
#include <ctype.h>
#include <string.h>
#include <algorithm>
using namespace std;
/**
This structure is to store the date and it has three integer
fields
**/
struct Date{
int day;
int month;
int year;
};
/**
This structure is to store the size of the box and it...
Need help writing a program that meets pseudocode and criteria . Txt File below input.txt file...
Need help writing a program that meets pseudocode and criteria .
Txt File below
input.txt file data
05 11/30/16
03 12/07/16
05 12/07/16
05 12/08/16
01 12/10/16
07 12/11/16
07 12/14/16
06 12/15/16
02 12/21/16
05 12/21/16
06 12/22/16
07 12/22/16
08 12/23/16
07 12/23/16
07 12/23/16
07 12/23/16
08 12/24/16
08 12/24/16
07 12/24/16
03 12/26/16
05 12/26/16
07 12/28/16
04 12/29/16
07 01/01/17
06 01/03/17
07 01/03/17
08 01/05/17
05 01/10/17
04 01/17/17
08 01/17/17
07 01/18/17
07...
DROP TABLE IF EXISTS customers; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS order_details; DROP...
DROP TABLE IF EXISTS customers; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS order_details; DROP TABLE IF EXISTS items; DROP TABLE IF EXISTS artists; DROP TABLE IF EXISTS employees; -- create tables CREATE TABLE customers ( customer_id INT , customer_first_name VARCHAR(20), customer_last_name VARCHAR(20) NOT NULL, customer_address VARCHAR(50) NOT NULL, customer_city VARCHAR(20) NOT NULL, customer_state CHAR(2) NOT NULL, customer_zip CHAR(5) NOT NULL, customer_phone CHAR(10) NOT NULL, customer_fax CHAR(10), CONSTRAINT customers_pk...
The code should work exactly the same as given example. The files: ---------------------------------------------------...
The code should work exactly the same as given example.
The files:
----------------------------------------------------------------------------------------------------
-------- FILE NAME -------
album0
---------- FILE -------
<album>
323
Licensed to Ill
Beastie Boys
25.0
</album>
<album>
70
Enter the Wu_Tang: 36 Cham...
Wu Tang Clan
25.99
</album>
turning to Alice, she went on, `What's your name, child?'
and there stood the Queen in front of them, with her arms
folded,
<album>
115
Daydream Nation
Sonic Youth
5.0
</album>
<album>
414
52nd Street
Billy Joel
25.75...
The data set below are the unemployment rates from April 2016 through March 2018. The mean...
The data set below are the unemployment rates from April 2016 through March 2018. The mean unemployment rate is 4.5, the median unemployment rate is 4.5, and the standard deviation of 0.33. Describe the data set using these statistics. Does the data appear to be consistent on a monthly basis? Year/Month Unemployment rate 2016-04 5.0 2016-05 2016-06 2016-07 2016-08 2016-09 2016-10 2016-11 2016-12 2017-01 2017-02 2017-03 2017-04 MacBook Pro 2017-05 4.3 2017-06 4 2017-07 4.3 2017-08 4.4 2017-09 4.2 2017-10...
2. The Vice President of Marketing for your firm wants the firm’s sales representatives to be...
2. The Vice President of Marketing for your firm wants the firm’s sales representatives to be able to directly view and edit customer details, but only for the state to which a particular sales representative is assigned. You have suggested that this need can be addressed with a view. For example, a view could be created for one particular state, and user account permissions for accessing that view granted only to sales representatives from that state. The VP has asked...
You are an analyst fir a mutual fund that wanrs to include a home inprovement store...
You
are an analyst fir a mutual fund that wanrs to include a home
inprovement store in its portfolio. Given that Home Depot and Lowes
are the dominant olayers in the industry, which firm would you
recommend buying? Explain
C D F N M N O P Q R 5 T 1 LOWE's HOME DEPOT 2010-01 2001-01 2012-01 2011-01 2014-01 2005-2006-01 2017-01 220 48.835 50,208 50 52 54 56.223 52 2010-2011-01 2012-01 2013-08 2014-01 2015-2016-01 2017-01 3.112 3.560 277 73...
Describe the type(s) of relationship(s) between EMPLOYEE and JOB. MP-104 103 18 101 13 103 15...
Describe the type(s) of relationship(s) between EMPLOYEE and
JOB.
MP-104 103 18 101 13 103 15 101 05 02 04 01 14 11 14 12 104 103 05 08 15 18 15 22 15 25 25 15 15 22 15 25 22 25 18 18 18 15 22 25 0 559 78 87 95-55 36 35 96 10 84 67 55 26 45 48 34 18 500 001 900 004 500 $10 03 04 05 06 07 08 09 10...
Date Gasoline Crude Oil Jan 01, 2010 2.031 79.07 Jan 08, 2010 2.124 82.34 Jan 15,...
Date Gasoline Crude Oil
Jan 01, 2010 2.031 79.07
Jan 08, 2010 2.124 82.34
Jan 15, 2010 2.079 80.06
Jan 22, 2010 2.010 76.62
Jan 29, 2010 1.942 73.94
Feb 05, 2010 1.885 74.57
Feb 12, 2010 1.908 73.88
Feb 19, 2010 2.031 78.25
Feb 26, 2010 2.042 79.22
Mar 05, 2010 2.127 80.19
Mar 12, 2010 2.154 81.76
Mar 19, 2010 2.150 81.44
Mar 26, 2010 2.118 80.65
Apr 02, 2010 2.191 83.01
Apr 09, 2010 2.238 85.66
Apr...
python find the maximum amount of rainfall on days where the maximum temperature was above 35...
python find the maximum amount of rainfall on days where the maximum temperature was above 35 degrees Celsius. This time, should incoporate pandas in program. Provided dataset is a file called climate_data_2017.csv. The maximum temperature record is in the third column (index 2) and the rainfall is in the fourth column (index 3). Result: Maximum amount of rainfall on hot days: 3.8 mm data file: Date,Minimum temperature (C),Maximum temperature (C),Rainfall (mm),Evaporation (mm),Sunshine (hours),Direction of maximum wind gust,Speed of maximum wind...
Need help with C++ assignment
Assignment 1 and .txt files are provided at the
bottom.
PART A
PART B
Assignment
1
#include <iostream>
#include <string>
#include <fstream>
#include <iomanip>
#include <stdio.h>
#include <ctype.h>
#include <string.h>
#include <algorithm>
using namespace std;
/**
This structure is to store the date and it has three integer
fields
**/
struct Date{
int day;
int month;
int year;
};
/**
This structure is to store the size of the box and it...
Need help writing a program that meets pseudocode and criteria .
Txt File below
input.txt file data
05 11/30/16
03 12/07/16
05 12/07/16
05 12/08/16
01 12/10/16
07 12/11/16
07 12/14/16
06 12/15/16
02 12/21/16
05 12/21/16
06 12/22/16
07 12/22/16
08 12/23/16
07 12/23/16
07 12/23/16
07 12/23/16
08 12/24/16
08 12/24/16
07 12/24/16
03 12/26/16
05 12/26/16
07 12/28/16
04 12/29/16
07 01/01/17
06 01/03/17
07 01/03/17
08 01/05/17
05 01/10/17
04 01/17/17
08 01/17/17
07 01/18/17
07...
The code should work exactly the same as given example.
The files:
----------------------------------------------------------------------------------------------------
-------- FILE NAME -------
album0
---------- FILE -------
<album>
323
Licensed to Ill
Beastie Boys
25.0
</album>
<album>
70
Enter the Wu_Tang: 36 Cham...
Wu Tang Clan
25.99
</album>
turning to Alice, she went on, `What's your name, child?'
and there stood the Queen in front of them, with her arms
folded,
<album>
115
Daydream Nation
Sonic Youth
5.0
</album>
<album>
414
52nd Street
Billy Joel
25.75...
The data set below are the unemployment rates from April 2016 through March 2018. The mean unemployment rate is 4.5, the median unemployment rate is 4.5, and the standard deviation of 0.33. Describe the data set using these statistics. Does the data appear to be consistent on a monthly basis? Year/Month Unemployment rate 2016-04 5.0 2016-05 2016-06 2016-07 2016-08 2016-09 2016-10 2016-11 2016-12 2017-01 2017-02 2017-03 2017-04 MacBook Pro 2017-05 4.3 2017-06 4 2017-07 4.3 2017-08 4.4 2017-09 4.2 2017-10...
You
are an analyst fir a mutual fund that wanrs to include a home
inprovement store in its portfolio. Given that Home Depot and Lowes
are the dominant olayers in the industry, which firm would you
recommend buying? Explain
C D F N M N O P Q R 5 T 1 LOWE's HOME DEPOT 2010-01 2001-01 2012-01 2011-01 2014-01 2005-2006-01 2017-01 220 48.835 50,208 50 52 54 56.223 52 2010-2011-01 2012-01 2013-08 2014-01 2015-2016-01 2017-01 3.112 3.560 277 73...
Describe the type(s) of relationship(s) between EMPLOYEE and
JOB.
MP-104 103 18 101 13 103 15 101 05 02 04 01 14 11 14 12 104 103 05 08 15 18 15 22 15 25 25 15 15 22 15 25 22 25 18 18 18 15 22 25 0 559 78 87 95-55 36 35 96 10 84 67 55 26 45 48 34 18 500 001 900 004 500 $10 03 04 05 06 07 08 09 10...
Date Gasoline Crude Oil
Jan 01, 2010 2.031 79.07
Jan 08, 2010 2.124 82.34
Jan 15, 2010 2.079 80.06
Jan 22, 2010 2.010 76.62
Jan 29, 2010 1.942 73.94
Feb 05, 2010 1.885 74.57
Feb 12, 2010 1.908 73.88
Feb 19, 2010 2.031 78.25
Feb 26, 2010 2.042 79.22
Mar 05, 2010 2.127 80.19
Mar 12, 2010 2.154 81.76
Mar 19, 2010 2.150 81.44
Mar 26, 2010 2.118 80.65
Apr 02, 2010 2.191 83.01
Apr 09, 2010 2.238 85.66
Apr...
Most questions answered within 3 hours.
-
Using MARS simulator, write MIPS programs according to
the following scenarios: Receive a positive integer number...
asked 1 hour ago -
An object in front of a concave mirror has a real image that is
11.5 cm...
asked 1 hour ago -
Consider the reaction, C3 H8 + O2 --> CO2 + H2O. How many
moles of O2...
asked 3 hours ago -
You and your opponent both roll a fair die. If you both roll the
same number,...
asked 3 hours ago -
In a study of the accuracy of fast food drive-through orders,
Restaurant A had 257 accurate...
asked 3 hours ago -
Identify and describe in detail the four categories of
institutions that could be included in a...
asked 3 hours ago -
In python
class Customer:
def __init__(self, customer_id, last_name, first_name, phone_number, address):
self._customer_id = int(customer_id)
self._last_name =...
asked 4 hours ago -
What is an example of a limitation in implementing a new
ERP system and how it...
asked 4 hours ago -
In a section of 9.7cm of an artery with a radius of 2.6mm there
is a...
asked 4 hours ago -
the two carboxylic acid groups of aspartic acid have different
acidities with pKa values of 2.1...
asked 4 hours ago -
Would CuCO3 aqueous salt combined with calcium chloride
form a solid precipitate? If so, what would...
asked 4 hours ago -
How do ECM Solutions assist in embedding a culture of continuous
improvement in an organization? (Project...
asked 4 hours ago