database design
you are tasked with creating a logical database design that will
be used later...
database design
you are tasked with creating a logical database design that will
be used later to implement the physical database named
State_Capitals. The first step of creating a logical database
design is normalization.
States of the United States
Country
Region
States
United
States
Midwest
Iowa
(IA), Illinois (IL), Indiana (IN), Kansas (KS), Michigan (MI),
Minnesota (MN), Missouri (MO), North Dakota (ND), Nebraska (NE),
Ohio (OH), South Dakota (SD), Wisconsin (WI)
United
States
Northeast
Connecticut (CT), Delaware (DE), Massachusetts (MA),...
Census data was collected on the 50 states and Washington, D.C.
We are interested in determining...
Census data was collected on the 50 states and Washington, D.C.
We are interested in determining whether average lifespan (LIFE) is
related to the ratio of males to females in percent (MALE), birth
rate per 1,000 people (BIRTH), divorce rate per 1,000 people
(DIVO), number of hospital beds per 100,000 people (BEDS),
percentage of population 25 years or older having completed 16
years of school (EDUC) and per capita income (INCO).
"STATE" "MALE" "BIRTH" "DIVO" "BEDS" "EDUC" "INCO" "LIFE"
AK...
Census data was collected on the 50 states and Washington, D.C.
We are interested in determining...
Census data was collected on the 50 states and Washington, D.C.
We are interested in determining whether average lifespan (LIFE) is
related to the ratio of males to females in percent (MALE), birth
rate per 1,000 people (BIRTH), divorce rate per 1,000 people
(DIVO), number of hospital beds per 100,000 people (BEDS),
percentage of population 25 years or older having completed 16
years of school (EDUC) and per capita income (INCO), with LIFE (y)
as the response variable, and MALE...
CREATE TABLE Orders
(Order# NUMBER(4),
Customer# NUMBER(4),
OrderDate DATE NOT NULL,
ShipDate DATE,
ShipStreet VARCHAR2(18),
ShipCity...
CREATE TABLE Orders
(Order# NUMBER(4),
Customer# NUMBER(4),
OrderDate DATE NOT NULL,
ShipDate DATE,
ShipStreet VARCHAR2(18),
ShipCity VARCHAR2(15),
ShipState VARCHAR2(2),
ShipZip VARCHAR2(5),
ShipCost NUMBER(4,2),
CONSTRAINT orders_order#_pk PRIMARY KEY(order#),
CONSTRAINT orders_customer#_fk FOREIGN KEY (customer#)
REFERENCES customers(customer#));
INSERT INTO ORDERS
VALUES
(1000,1005,TO_DATE('31-MAR-09','DD-MON-YY'),TO_DATE('02-APR-09','DD-MON-YY'),'1201
ORANGE AVE', 'SEATTLE', 'WA', '98114' , 2.00);
INSERT INTO ORDERS
VALUES
(1001,1010,TO_DATE('31-MAR-09','DD-MON-YY'),TO_DATE('01-APR-09','DD-MON-YY'),
'114 EAST SAVANNAH', 'ATLANTA', 'GA', '30314', 3.00);
INSERT INTO ORDERS
VALUES
(1002,1011,TO_DATE('31-MAR-09','DD-MON-YY'),TO_DATE('01-APR-09','DD-MON-YY'),'58
TILA CIRCLE', 'CHICAGO', 'IL', '60605', 3.00);
INSERT INTO ORDERS
VALUES
(1003,1001,TO_DATE('01-APR-09','DD-MON-YY'),TO_DATE('01-APR-09','DD-MON-YY'),'958
MAGNOLIA LANE', 'EASTPOINT', 'FL', '32328', 4.00);...