Question: Using the attached database Alexamara, please create one fact table and two dimension tables. Submit three screen prints showing the data in each table. Steps
Using the attached database "Alexamara", please create one fact table and two dimension tables. Submit three screen prints showing the "data" in each table.
Steps I would take.
In MySQL I would create a DataWarewhouse database no tables in it
In MySQL I would import the Alexamara database.
Study the Alexamara Data Schema that I have attached and think about what data you want in that table.
Using the hints below import your data into your fact table and your two dimension tables. screen prints please.
txt file below:
HINTs:
# moving into a dimension table
INSERT INTO datawarehouse.marinaslip
SELECT
FROM alexamara.marinaslip;
HINT # Movie into your fact table.
INSERT INTO datawarehouse.servicerequest servicerequest.serviceid servicerequest.categorynum, servicerequest.SLIPID servicerequest.marinanum
SELECT servicerequest.serviceid servicerequest.categorynum, marinaslip.SLIPID marina.marinanum
FROM alexamara.servicerequest, alexamara.marinaslip, alexamara.servicecategory, alexamara.marina
WHERE servicerequest.categorynumservicecategory.CATEGORYNUM
AND marinaslip.marinanummarina.marinanum
AND marinaslip.slipidservicerequest.slipid;
CREATE SCHEMA Alexamara;
USE Alexamara;
CREATE TABLE MARINA
MARINANUM CHAR PRIMARY KEY,
NAME CHAR
ADDRESS CHAR
CITY CHAR
STATE CHAR
ZIP CHAR;
CREATE TABLE MARINASLIP
SLIPID DECIMAL PRIMARY KEY,
MARINANUM CHAR
SLIPNUM CHAR
LENGTH DECIMAL
RENTALFEE DECIMAL
BOATNAME CHAR
BOATTYPE CHAR
OWNERNUM CHAR;
CREATE TABLE OWNER
OWNERNUM CHAR PRIMARY KEY,
LASTNAME CHAR
FIRSTNAME CHAR
ADDRESS CHAR
CITY CHAR
STATE CHAR
ZIP CHAR;
CREATE TABLE SERVICECATEGORY
CATEGORYNUM DECIMAL PRIMARY KEY,
CATEGORYDESCRIPTION CHAR;
CREATE TABLE SERVICEREQUEST
SERVICEID DECIMAL PRIMARY KEY,
SLIPID DECIMAL
CATEGORYNUM DECIMAL
DESCRIPTION CHAR
STATUS CHAR
ESTHOURS DECIMAL
SPENTHOURS DECIMAL
NEXTSERVICEDATE CHAR ;
INSERT INTO MARINA
VALUES
'Alexamara East',nd Ave.'Brinman',FL;
INSERT INTO MARINA
VALUES
'Alexamara Central', Branston',W Brinman',FL;
INSERT INTO MARINASLIP
VALUES
A'Anderson II'Sprite AN;
INSERT INTO MARINASLIP
VALUES
A'Our Toy','Ray EL;
INSERT INTO MARINASLIP
VALUES
A'Escape','Sprite KE;
INSERT INTO MARINASLIP
VALUES
BGypsy'Dolphin JU;
INSERT INTO MARINASLIP
VALUES
B'Anderson III','Sprite AN;
INSERT INTO MARINASLIP
VALUES
'Bravo','Dolphin AD;
INSERT INTO MARINASLIP
VALUES
'Chinook','Dolphin FE;
INSERT INTO MARINASLIP
VALUES
'Listy','Dolphin SM;
INSERT INTO MARINASLIP
VALUES
'Mermaid','Dolphin BL;
INSERT INTO MARINASLIP
VALUES
'Axxon II'Dolphin NO;
INSERT INTO MARINASLIP
VALUES
'Karvel','Ray TR;
INSERT INTO OWNER
VALUES
AD'Adney','Bruce and Jean', Citrus','Bowton',FL;
INSERT INTO OWNER
VALUES
AN'Anderson','Bill', Wilcox','Glander Bay',FL;
INSERT INTO OWNER
VALUES
BL'Blake','Mary', Commodore','Bowton',FL;
INSERT INTO OWNER
VALUES
EL'Elend','Sandy and Bill', Riverside','Rivard',FL;
INSERT INTO OWNER
VALUES
FE'Feenstra','Daniel', Coventry','Kaleva',FL;
INSERT INTO OWNER
VALUES
JU'Juarez','Maria', Oak','Rivard',FL;
INSERT INTO OWNER
VALUES
KE'Kelly','Alyssa', Waters','Bowton',FL;
INSERT INTO OWNER
VALUES
NO'Norton','Peter', Lakewood','Lewiston',FL;
INSERT INTO OWNER
VALUES
SM'Smeltz','Becky and Dave', Garland','Glander Bay',FL;
INSERT INTO OWNER
VALUES
TR'Trent','Ashton', Crest','Bay Shores',FL;
INSERT INTO SERVICECATEGORY
VALUES
'Routine engine maintenance';
INSERT INTO SERVICECATEGORY
VALUES
'Engine repair';
INSERT INTO SERVICECATEGORY
VALUES
'Air conditioning';
INSERT INTO SERVICECATEGORY
VALUES
'Electrical systems';
INSERT INTO SERVICECATEGORY
VALUES
'Fiberglass repair';
INSERT INTO SERVICECATEGORY
VALUES
'Canvas installation';
INSERT INTO SERVICECATEGORY
VALUES
'Canvas repair';
INSERT INTO SERVICECATEGORY
VALUES
'Electronic systems radar GPS autopilots, etc.;
INSERT INTO SERVICEREQUEST
VALUES
'Air conditioner periodically stops with code indicating low coolant level. Diagnose and repair.'Technicia
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help