Please prove the detail answer for all the questioins blew, thank you so much.

Part 1:

(1) ( Data Modeling )

Given the following group of tables, 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

(2) ( Data Analytics / Predictive Analytics: The Standard Deviation )

In Oracle and SQL the standard deviation is used as an aggregate group function as well as an analytical function. The following data illustrates company sales for the first half of the year. For the data below, compute both the population standard deviation and the sample standard deviation.

tblValues Table
index	month	values
1	January	$20
2	February	$26
3	March	$28
4	April	$31
5	May	$33
6	June	$30

Hints: examine the MS Access SQL statements given below or use equivalent Oracle statements.

Sample Standard Deviation

SELECT STDEV(values) FROM tblValues;

Population Standard Deviation

SELECT STDEVP(values) FROM tblValues;

Part 2 Data Design Concepts - Advanced Topics in Data Management

(1) ( Database Models )

Compare and contrast the hierarchical and network database models.

Which of these database models was historically implemented first?

List some advantages and disadvantages of each of these models.

Provide some examples of types of enterprises that would favor hierarchical database models as well as some types of enterprises that are best suited for network database models.

(2) ( Data Models and eCommerce )

Design a Data Model for a database application on behalf of an Office Administrative Services enterprise. This type of enterprise forms the backbone of business operations across a variety of industries, such as

physicians offices, rental equipment firms, food services by providing them the day - to - day administrative services including record keeping, financial planning and billing.