Please prove the detailly answer for all the questions blew, thank you so much.
ID: 3750882 • Letter: P
Question
Please prove the detailly answer for all the questions blew, thank you so much.
Question 1:
list FIVE written business rules that are reflected in the tables and their contents.
Artists
ArtistNum
LName
FName
MI
100
Jennings
Joyce
D
101
Matthews
Shruti
F
102
Sims
Silas
103
Dean
Daisy
H
Galleries
GalleryNum
GalleryName
ZipCode
22
Lawrence ArtWorks
60625
25
Cragin Corners
60651
27
Bronzeville Galleries
60616
28
Harlem HangUps
60634
Paintings
PaintNum
Title
ArtistNum
GalleryNum
100
Morning
100
22
101
Outer Space
100
25
102
The Poet
101
28
103
Jane
102
28
Question 2.
For the data below, compute both the population standard deviation and the sample standard deviation. Then prove the Query statement in detail.
tblValues Table
index
month
values
1
January
$20
2
February
$26
3
March
$28
4
April
$31
5
May
$33
6
June
$30
.
ArtistNum
LName
FName
MI
100
Jennings
Joyce
D
101
Matthews
Shruti
F
102
Sims
Silas
103
Dean
Daisy
H
Explanation / Answer
In artists table artistnum, lname, fname are unique and not null. Artistnum is the primary key. Mi is null.In galleries table gallerynum, alleryname and zipcode are unique. Artists and Gallery are master tables. Paintings is a transaction table. The values in the transaction table should exist in master table.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.