I've attached my SQL from the previous week 

Design and develop the below queries using professional principles and standards:

• A set of SQL Statements that returns all rows and all data for each table in your database.
• Two SQL Statements that return a subset of columns and a subset of rows using the WHERE clause.
• Two SQL Statements that join two or more tables in one query.  Look for primary and foreign keys to help you determine join points. Use the JOIN clause as a part of your queries.

 

-- Artwork Table
CREATE TABLE ARTWORK(
ARTWORK_ID INT PRIMARY KEY,
Size INT NOT NULL,
Genre VARCHAR(40) NOT NULL,
OtherWorks VARCHAR(40) NOT NULL,
Value VARCHAR(40) NOT NULL,
DateCreated DATE NOT NULL
);
-- Artist Table
CREATE TABLE Artist(
ARTIST_ID INT PRIMARY KEY,
ARTWORK_ID INT NOT NULL,
Name VARCHAR(50) NOT NULL,
Address VARCHAR(250) NOT NULL,
HomePhone VARCHAR(12) NOT NULL,
ArtAmount INT NULL,
CONSTRAINT fk_Artist_Art FOREIGN KEY (ARTWORK_ID)
REFERENCES ARTWORK(ARTWORK_ID)
);
-- ArtLocation Table
CREATE TABLE ArtLocation(
ID INT PRIMARY KEY,
Section VARCHAR(50) NOT NULL,
Location VARCHAR(100) NOT NULL,
StartDate DATE NOT NULL,
EndDate DATE NOT NULL,
ARTWORK_ID INT NOT NULL,
CONSTRAINT fk_ArtLoc_Art FOREIGN KEY (ARTWORK_ID)
REFERENCES ARTWORK(ARTWORK_ID)
);
-- Data Insertion Queries
INSERT INTO ARTWORK(ARTWORK_ID, Size, Genre, OtherWorks, Value, DateCreated)
VALUES(1, 50, 'Medival', 'None', 500, TO_DATE('2017/01/01', 'yyyy/mm/dd'));
INSERT INTO ARTWORK(ARTWORK_ID, Size, Genre, OtherWorks, Value, DateCreated)
VALUES(2, 100, 'Adventure', 'None', 540, TO_DATE('2017/01/08', 'yyyy/mm/dd'));
INSERT INTO ARTWORK(ARTWORK_ID, Size, Genre, OtherWorks, Value, DateCreated)
VALUES(3, 20, 'Space', 'None', 250, TO_DATE('2017/01/15', 'yyyy/mm/dd'));
INSERT INTO ARTWORK(ARTWORK_ID, Size, Genre, OtherWorks, Value, DateCreated)
VALUES(4, 85, 'Fiction', 'Author', 350, TO_DATE('2017/01/22', 'yyyy/mm/dd'));
INSERT INTO ARTWORK(ART_ID, Size, Genre, OtherWorks, Value, DateCreated)
VALUES(5, 70, 'Dancing', 'Trainer', 400, TO_DATE('2017/01/29', 'yyyy/mm/dd'));
INSERT INTO ARTWORK(ARTWORK_ID, Size, Genre, OtherWorks, Value, DateCreated)
VALUES(6, 220, 'Suspense', 'Author', 300, TO_DATE('2017/02/05', 'yyyy/mm/dd'));
INSERT INTO ARTWORK(ARTWORK_ID, Size, Genre, OtherWorks, Value, DateCreated)
VALUES(7, 45, 'Science Fiction', 'Author', 200, TO_DATE('2017/02/12',
'yyyy/mm/dd'));
INSERT INTO ARTWORK(ARTWORK_ID, Size, Genre, OtherWorks, Value, DateCreated)
VALUES(8, 80, 'Western Adventure', 'Author', 350, TO_DATE('2017/02/19',
'yyyy/mm/dd'));
INSERT INTO ARTWORK(ARTWORK_ID, Size, Genre, OtherWorks, Value, DateCreated)
VALUES(9, 65, 'Comedy', 'None', 700, TO_DATE('2017/02/26', 'yyyy/mm/dd'));
INSERT INTO ARTWORK(ARTWORK_ID, Size, Genre, OtherWorks, Value, DateCreated)
VALUES(10, 90, 'Non-Fiction', 'Author', 250, TO_DATE('2017/03/05',
'yyyy/mm/dd'));
INSERT INTO Artist(ARTIST_ID, ARTWORK_ID, Name, Address, HomePhone,
ArtAmount)
VALUES(1, 2, 'David Ortiz', '4 Yawkey Way, Boston, MA 02215',
'8777337699', 50);
INSERT INTO Artist(ARTIST_ID, ARTWORK_ID, Name, Address, HomePhone, ArtAmount)
VALUES(2, 1, 'Emmitt Smith', '1 AT&T Way, Arlington, TX 76011',
'8178924000', 150);
INSERT INTO Artist(ARTIST_ID, ARTWORK_ID, Name, Address, HomePhone,
ArtAmount)
VALUES(3, 5, 'Tim Duncan', '1 AT&T Center Parkway, San Antonio, TX 78219',
'2104445000', 200);
INSERT INTO Artist(ARTIST_ID, ARTWORK_ID, Name, Address, HomePhone,
ArtAmount)
VALUES(4, 4, 'James Doolan', '7508 Axis Ct, Charlotte, NC 28273',
'9802300987', 150);
INSERT INTO Artist(ARTIST_ID, ARTWORK_ID, Name, Address, Telephone,
ArtAmount)
VALUES(5, 3, 'Bruce Wayne', '635 Summer Lake Dr, Gotham City, NJ 12004',
'8547755541', 750);
INSERT INTO Artist(ARTIST_ID, ARTWORK_ID, Name, Address, HomePhone,
ArtAmount)
VALUES(6, 8, 'Clark Kent', '2654 Canyon Road, Smallville, KS 24568',
'6352241147', 350);
INSERT INTO Artist(ARTIST_ID, ARTWORK_ID, Name, Address, HomePhone,
ArtAmount)
VALUES(7, 10, 'Steph Curry', '7000 Coliseum Way, Oakland, CA 94621',
'5105692121', 100);
INSERT INTO Artist(ARTIST_ID, ARTWORK_ID, Name, Address, HomePhone,
ArtAmount)
VALUES(8, 7, 'Charles Oakley', '4 Pennsylvania Plaza, New York, NY 10001',
'2124656741', 750);
INSERT INTO Artist(ARTIST_ID, ARTWORK_ID, Name, Address, HomePhone,
ArtAmount)
VALUES(9, 8, 'Julio Jones', '1 Georgia Dome Dr, Atlanta, GA 30313',
'4042239200', 225);
INSERT INTO Artist(ARTIST_ID, ARTWORK_ID, Name, Address, HomePhone,
ArtAmount)
VALUES(10, 2, 'Alex Smith', '1 Arrowhead Dr, Kansas City, MO 64129',
'8169209300', 520);
INSERT INTO ArtLocation(ID, Section, Location, StartDate, EndDate,
ARTWORK_ID)
VALUES(1, 'Front Entrance', 'Location A', TO_DATE('2017/03/12', 'yyyy/mm/dd'),
TO_DATE('2018/03/12', 'yyyy/mm/dd'), 9);
INSERT INTO ArtLocation(ID, Section, Location, StartDate, EndDate,
ARTWORK_ID)
VALUES(2, 'Section A', 'Location A', TO_DATE('2017/03/19', 'yyyy/mm/dd'),
TO_DATE('2018/03/19', 'yyyy/mm/dd'), 10);
INSERT INTO ArtLocation(ID, Section, Location, StartDate, EndDate,
ARTWORK_ID)
VALUES(3, 'Garden', 'Rear Location', TO_DATE('2017/03/26', 'yyyy/mm/dd'),
TO_DATE('2018/03/26', 'yyyy/mm/dd'), 2);
INSERT INTO ArtLocation(ID, Section, Location, StartDate, EndDate,
ARTWORK_ID)
VALUES(4, 'Section B', 'Location A', TO_DATE('2017/04/02', 'yyyy/mm/dd'),
TO_DATE('2018/04/02', 'yyyy/mm/dd'), 8);
INSERT INTO ArtLocation(ID, Section, Location, StartDate, EndDate,
ARTWORK_ID)
VALUES(5, 'Section C', 'Location B', TO_DATE('2017/04/09', 'yyyy/mm/dd'),
TO_DATE('2018/04/09', 'yyyy/mm/dd'), 1);
INSERT INTO ArtLocation(ID, Section, Location, StartDate, EndDate,
ARTWORK_ID)
VALUES(6, 'Upstairs', 'Rear Location', TO_DATE('2017/04/16', 'yyyy/mm/dd'),
TO_DATE('2017/04/16', 'yyyy/mm/dd'), 3);
INSERT INTO ArtLocation(ID, Section, Location, StartDate, EndDate,
ARTWORK_ID)
VALUES(7, 'Balcony A', 'Location C', TO_DATE('2017/04/23', 'yyyy/mm/dd'),
TO_DATE('2018/04/23', 'yyyy/mm/dd'), 6); INSERT INTO ArtLocation(ID, Section, Location, StartDate, EndDate,
ARTWORK_ID)
VALUES(8, 'Balcony B', 'Location C', TO_DATE('2017/04/30', 'yyyy/mm/dd'),
TO_DATE('2018/04/30', 'yyyy/mm/dd'), 4);
INSERT INTO ArtLocation(ID, Section, Location, StartDate, EndDate,
ARTWORK_ID)
VALUES(9, 'Park Section A', 'Location D', TO_DATE('2017/05/17', 'yyyy/mm/dd'),
TO_DATE('2018/05/17', 'yyyy/mm/dd'), 7);
INSERT INTO ArtLocation(ID, Section, Location, StartDate, EndDate,
ARTWORK_ID)
VALUES(10, 'Park Section B', 'Location D', TO_DATE('2017/05/14', 'yyyy/mm/dd'),
TO_DATE('2018/05/14', 'yyyy/mm/dd'), 5);

ComputerScienceExpert

(11)

Status NEW Posted 02 May 2017 08:05 AM My Price 10.00

-----------

Attachments

file 1493714668-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer