Assignment 02
.docx
keyboard_arrow_up
School
Wayne State University *
*We aren’t endorsed by this school
Course
5800
Subject
Statistics
Date
Feb 20, 2024
Type
docx
Pages
7
Uploaded by MagistrateAtomFox29
Assignment 02
Terry Paul Hd9796
Part 1. Keys
Use the database shown below to answer the following questions:
Question 1.1
For each table, identify the primary key and the foreign key(s). If a table does not have a foreign
key, write None in the space provided.
Primary
Foreign
Truck: TRUCK_NUM
BASE_CODE, TYPE_CODE BASE: BASE_CODE
NONE
TYPE: TYPE_CODE
NONE
Question 1.2
Do the tables exhibit entity integrity? Answer yes or no.
YES ALL PRIMARY KETS ONLY APPEAR ONCE
Question 1.3
Do the tables exhibit referential integrity? Answer yes or no. Write NA (Not Applicable) if the table does not have a foreign key.
YES FOR TRUCK table that has a foreign key has a value associated with it. Na FOR THE REST AS THEY HAVE NO FOREIGN KEYS TO USE AS REFEENCE
Question 1.4
Identify the TRUCK table’s candidate key(s).
TRUCK_NUM, TRUCK_SERIAL_NUM
Question 1.5
For each table, identify a superkey.
TRUCK: TRUCK_NUM WITH OR WITHOUT ANY OTHER ATTRIBUTE
BASE: BASE_CODE WITH OR WITHOUT ANY OTHER ATTRIBUTE
TYPE: TYPE CODE WITH OR WITHOUT ANY OTHER ATTRIBUTE
Question 1.6
Create the relational diagram for this database.
Part 2. Operators
The subject table below is an adaptation of the Pima Indians Diabetes Database. The subject_id
and city_id columns were added to the original dataset (table).
Also, subjects_old, subjects_temp, cities, and values tables were also added so we can apply some operations to them.
To know the meaning of each column in the original dataset, please see number 7 in the Pima Indians Diabetes Database documentation
. subjects
subject_id
city_id preg
plas
pres skin insu
mass pedi
age
class
1
2
6
148
72
35
0
33.6
0.627
50 tested_positive
2
3
1
85
66
29
0
26.6
0.351
31 tested_negative
3
2
8
183
64
0
0
23.3
0.672
32 tested_positive
4
NULL
1
89
66
23
94
28.1
0.167
21 tested_negative
5
3
0
137
40
35
168
43.1
2.288
33 tested_positive
6
2
5
116
74
0
0
25.6
0.201
30 tested_negative
7
NULL
3
78
50
32
88
31
0.248
26 tested_positive
8
3
10
115
0
0
0
35.3
0.134
29 tested_negative
9
1
2
197
70
45
543
30.5
0.158
53 tested_positive
10
1
8
125
96
0
0
0
0.232
54 tested_positive
11
0
4
110
92
0
0
37.6
0.191
30 tested_negative
12
3
10
168
74
0
0
38
0.537
34 tested_positive
13
2
10
139
80
0
0
27.1
1.441
57 tested_negative
14
NULL
1
189
60
23
846
30.1
0.398
59 tested_positive
15
2
5
166
72
19
175
25.8
0.587
51 tested_positive
subjects_old
subject_id
city_id
preg
plas
pres
skin insu
mass
pedi
age
class
16
2
7
100
0
0
0
30 0.484
32 tested_positive
17
0
0
118
84
47
230
45.8
0.551
31 tested_positive
18
1
7
107
74
0
0
29.6
0.254
31 tested_positive
19
NULL
1
103
30
38
83
43.3
0.183
33 tested_negative
20
3
1
115
70
30
96
34.6
0.529
32 tested_positive
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
PLEASE TYPE ONLY***
Exercise 5.3.3: Counting license plate numbers.
License plate numbers in a certain state consists of seven characters. The first character is a digit (0 through 9). The next four characters are capital letters (A through Z) and the last two characters are digits. Therefore, a license plate number in this state can be any string of the form:
Digit-Letter-Letter-Letter-Letter-Digit-Digit
(b)
How many license plate numbers are possible if no digit appears more than once?
(c)
How many license plate numbers are possible if no digit or letter appears more than once
arrow_forward
No calculator. Please show all work.
arrow_forward
Encrypt the message " HALT " by translating the letters into numbers
(via A = 0, B = 1, C = 2, D = 3, E = 4, F = 5, G = 6, H = 7, I = 8,
J = 9, K = 10, L = 11, M = 12, N = 13, O = 14, P = 15, Q = 16, R = 17,
S = 18, T = 19, U = 20, V = 21, W = 22, X = 23, Y = 24, Z = 25 )
%3D
and then applying the encryption function given, and then translating the numbers
back into letters.
(a) f(p) = (p+ 5) mod 26
(b) †(p) = (p + 10) mod 26
(c) f(p)
(р + 7) mod 26
arrow_forward
Encrypt the message " HALT " by
translating the letters into numbers
(via
A = 0, B = 1, C = 2, D = 3, E = 4, F = 5, G = 6, H = 7,1 = 8,
J = 9, K = 10, L = 11, M = 12, N = 13,0 = 14, P = 15, Q = 16, R = 17,
S = 18, T = 19, U = 20, V = 21, W = 22, X = 23, Y = 24, Z = 25
%3D
%3D
%3D
%3D
and then applying the encryption function given, and
then translating the numbers back into letters.
(a) f(p) = (p + 4) mod 26
(b) f(p) = (p + 10) mod 26
(c) f(p) = (p + 3) mod 26
arrow_forward
Help
arrow_forward
a paint manufacturer dis
arrow_forward
A realtor has 20 residential listings under contract. The following table shows the number of days each of those 20 houses has been on the market as of today. Use the data to complete parts d through e.
***Type an integer or a decimal***
arrow_forward
Define grouping symbols.
arrow_forward
Here are the numbers of children in 12 elementary school classes.
20
,
20
,
17
,
17
,
19
,
18
,
20
,
19
,
19
,
18
,
18
,
16
Send data to calculator
Find the modes of this data set.
If there is more than one mode, write them separated by commas.If there is no mode, click on "No mode."
arrow_forward
Put the following into the set builder notation:
{2, 4, 6, 8, 10}
{2, 3, 5, 7, 11}
{1, 4, 9, 16, 25}
arrow_forward
Assignment 2
Q.1\ Suppose that I want to purchase a tablet computer. I can choose either a large or small
screen; a 64GB, 128GB, or 256GB storage capacity, and black or white cover. How many
different options do I have.
Q.2\ I need to choose a password for a computer account. The rule is that the password must
consist of two lowercase letter (a to z) followed by one capital letter (A to Z) followed by
four digits (0,1,.,9) for example, the following is a valid password: rgM2808. Find the total
number of possible passwords, N.
Q.3\ Shuffle a deck of 52 cards. How many outcomes are possible? (In other words, how
many different ways can you order 52 distinct cards?)
Q.4| I choose 3 cards from the standard deck of cards. What is the probability that these cards
contain at least one ace?
Q.5\ How many distinct sequence can we make using 3 letters "A"s and 5 letters "B"s?
(АААВВВВB, ААВBBBBA, etc.)
Q.6\ Suppose that I have a coin for which P(H)-p and P(T)=1-p. I toss the coin 5 times.
a)…
arrow_forward
:Show how you will code the dummy variables in this model, in other words fill in 13 rows with your dummy variables in the table below. (the first column, Month, tells you what month it is).
Month
Jan
Feb
Mar
Apr
May
Jun
July
Aug
Sept
Oct
Nov
Dec…
arrow_forward
CAN IT BE TYPE, OR WRITTEN. MORE CLEARLY
arrow_forward
A lock uses the letters A through H on the first dial and the digits 0 through 9 on the second and third dials.
Prompts
How many possible codes are there for this lock?
How many possible codes are there if the same number
is not used twice?
arrow_forward
Users of the online system for a Bank are required to set a password that is 10 character-long. Each character can be a letter, a 1-digit number, or a symbol from the list: !, @, #, &, %
How many passwords are possible if there is no distinction between upper case and lower case letters? (Not Case-sensitive)
How many passwords are possible if the first and last digits have to be numbers?
arrow_forward
thank you
arrow_forward
Define interset.
arrow_forward
UOu9Lx4VyFM4RZrTQxDYme
Walmart Credit Car..
Log in to Blackboar.
14 Friv : ONLY THE VE.
Teaching Vocabula..
O ePortfolio System L.
About the 5
ctivity @
D Present
Tools Add-ons Help
Last edit was 5 minutes ago
Background
Layout-
Theme
Transition
USE THE TYPING TOOL TO TYPE AN "X" IN ANY COLUMN THAT CORRECTLY
CLASSIFIES THE GIVEN VALUE IN THE ROW.
NATURAL
WHOLE
INTEGER
RATIONAL
IRRATIONAL
REAL
25
77
-1.75
V16
EManerngha Mdda LLC, 219
CLASSIFYING REAL NUMBERS
arrow_forward
What pages will be favored for the following search terms:
Chevrolet AND Corvette
Pages that include Chevrolet Corvette
Pages that include Chevrolet and pages that include Corvette plus pages about both
Pages about Chevrolet, pages about OR plus pages about Corvette
Pages about Chevrolet and pages about Corvette
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Algebra for College Students
Algebra
ISBN:9781285195780
Author:Jerome E. Kaufmann, Karen L. Schwitters
Publisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
Related Questions
- PLEASE TYPE ONLY*** Exercise 5.3.3: Counting license plate numbers. License plate numbers in a certain state consists of seven characters. The first character is a digit (0 through 9). The next four characters are capital letters (A through Z) and the last two characters are digits. Therefore, a license plate number in this state can be any string of the form: Digit-Letter-Letter-Letter-Letter-Digit-Digit (b) How many license plate numbers are possible if no digit appears more than once? (c) How many license plate numbers are possible if no digit or letter appears more than oncearrow_forwardNo calculator. Please show all work.arrow_forwardEncrypt the message " HALT " by translating the letters into numbers (via A = 0, B = 1, C = 2, D = 3, E = 4, F = 5, G = 6, H = 7, I = 8, J = 9, K = 10, L = 11, M = 12, N = 13, O = 14, P = 15, Q = 16, R = 17, S = 18, T = 19, U = 20, V = 21, W = 22, X = 23, Y = 24, Z = 25 ) %3D and then applying the encryption function given, and then translating the numbers back into letters. (a) f(p) = (p+ 5) mod 26 (b) †(p) = (p + 10) mod 26 (c) f(p) (р + 7) mod 26arrow_forward
- Encrypt the message " HALT " by translating the letters into numbers (via A = 0, B = 1, C = 2, D = 3, E = 4, F = 5, G = 6, H = 7,1 = 8, J = 9, K = 10, L = 11, M = 12, N = 13,0 = 14, P = 15, Q = 16, R = 17, S = 18, T = 19, U = 20, V = 21, W = 22, X = 23, Y = 24, Z = 25 %3D %3D %3D %3D and then applying the encryption function given, and then translating the numbers back into letters. (a) f(p) = (p + 4) mod 26 (b) f(p) = (p + 10) mod 26 (c) f(p) = (p + 3) mod 26arrow_forwardHelparrow_forwarda paint manufacturer disarrow_forward
- A realtor has 20 residential listings under contract. The following table shows the number of days each of those 20 houses has been on the market as of today. Use the data to complete parts d through e. ***Type an integer or a decimal***arrow_forwardDefine grouping symbols.arrow_forwardHere are the numbers of children in 12 elementary school classes. 20 , 20 , 17 , 17 , 19 , 18 , 20 , 19 , 19 , 18 , 18 , 16 Send data to calculator Find the modes of this data set. If there is more than one mode, write them separated by commas.If there is no mode, click on "No mode."arrow_forward
- Put the following into the set builder notation: {2, 4, 6, 8, 10} {2, 3, 5, 7, 11} {1, 4, 9, 16, 25}arrow_forwardAssignment 2 Q.1\ Suppose that I want to purchase a tablet computer. I can choose either a large or small screen; a 64GB, 128GB, or 256GB storage capacity, and black or white cover. How many different options do I have. Q.2\ I need to choose a password for a computer account. The rule is that the password must consist of two lowercase letter (a to z) followed by one capital letter (A to Z) followed by four digits (0,1,.,9) for example, the following is a valid password: rgM2808. Find the total number of possible passwords, N. Q.3\ Shuffle a deck of 52 cards. How many outcomes are possible? (In other words, how many different ways can you order 52 distinct cards?) Q.4| I choose 3 cards from the standard deck of cards. What is the probability that these cards contain at least one ace? Q.5\ How many distinct sequence can we make using 3 letters "A"s and 5 letters "B"s? (АААВВВВB, ААВBBBBA, etc.) Q.6\ Suppose that I have a coin for which P(H)-p and P(T)=1-p. I toss the coin 5 times. a)…arrow_forward:Show how you will code the dummy variables in this model, in other words fill in 13 rows with your dummy variables in the table below. (the first column, Month, tells you what month it is). Month Jan Feb Mar Apr May Jun July Aug Sept Oct Nov Dec…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage LearningAlgebra for College StudentsAlgebraISBN:9781285195780Author:Jerome E. Kaufmann, Karen L. SchwittersPublisher:Cengage LearningHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
- Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Algebra for College Students
Algebra
ISBN:9781285195780
Author:Jerome E. Kaufmann, Karen L. Schwitters
Publisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell