Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please complete query activity Methods and Tools in SW Development There are two parts to this assignment - each part has tables associated with it.
please complete query activity
Methods and Tools in SW Development There are two parts to this assignment - each part has tables associated with it. There are: - Insert queries provided for part one - (a create table query isn't provided as that is part of the assignment) - Create table/insert queries for part two You must use these queries as is. You are not allowed to change the queries in any way. These queries should be able to be copy/pasted into the SQL window in your GUI of choice and run through there in one bulk run once you have everything set up. Hints for part two: I'm not very strict on this. As I have told students before: I have queries in mind for these prompts, but if you come up with a query that provides the results (and follows the rules stated), Ill more than likely give you credit. If unsure, feel free to ask me. You are not allowed to just select the ISBNs or Titles of the books you see. Part One: Take the beginning table: You must provide: - A create table query that will create the table Insert queries have been provided to use to form the base table after creation. You CANNOT alter the insert queries given to you. - All subsequent queries to take that table and form it into the following table: Base INSERT queries: INSERT INTO games (Name, Publisher, Genre, Year, Console, MainCharacter) VALUES ('Spyro the Dragon', 'Sony', 'Platformer', '1998', 'PlayStation', 'Spyro'); INSERT INTO games (Name, Publisher, Genre, Year, Console, MainCharacter) VALUES ('Super Mario Bros', 'Nintendo', 'Platformer', '1985', 'NES', 'Mario'); INSERT INTO games (Name, Publisher, Genre, Year, Console, MainCharacter) VALUES ('Super Mario 64', 'Nintendo', 'Platformer', '1996', 'Nintendo 64', 'Mario'); INSERT INTO games (Name, Publisher, Genre, Year, Console, MainCharacter) VALUES ("The Legend of Zelda: Majora's Mask", 'Nintendo', 'Action-adventure", '2000', 'Nintendo 64 ', 'Link'); INSERT INTO games (Name, Publisher, Genre, Year, Console, MainCharacter) ValuES ('Halo: Combat Evolved', 'Xbox Game Studios', 'First-person shooter', '2001', 'Xbox', 'Master (hief'); You should be able to copy and run all of these in one go to create your initial table data after table creation. Part Two: Take the two following tables as a basis for the following prompts. Queries to create these tables can be found on the following page (after the prompts). Part Two: Take the two following tables as a basis for the following prompts. Queries to create these tables can be found on the following page (after the prompts). Prompts: PROMPTS MUST BE ANSWERED BE A SINGLE QUERY. MULTIPLE SELECT QUERIES TIED TOGETHER WILL NOT BE ACCEPTED. Assume prompts 1 and 2 must interact with both tables to work properly. 1) Provide TWO distinct queries that would yield this result: ("* queries must be entirely distinct - as in, for example, you CANNOT use the same query type and then add aliasing to make them 'different' queries) 2) Provide a query that would yield this result: assume year must ve greater unan tyou) 3) Provide a query that would yield this result: we year mas mommy tu u0 wn ums query) Table creation queries: CREATE TABLE pulitzer ( ISBN varchar(14) NOT NULL, Year int (4), PRIMARY KEY(ISBN) ); CREATE TABLE books ( ISBN varchar(14) NOT NULL, Title varchar(50), Author varchar(50), Year int(4), Genre varchar(50), PRIMARY KEY(ISBN) ); INSERT INTO pulitzer (ISBN, Year) VALUES ('978-8446310789', '1961'); INSERT INTO pulitzer (ISBN, Year) VALUES ('978-0156028356', '1983'); INSERT INTO pulitzer (ISBN, Year) VALUES ('978-1400033416', '1988'); INSERT INTO pulitzer (ISBN, Year) VALUES ('978-0312424464', '2005'); INSERT INTO books (ISBN, Title, Author, Year, Genre) VALUES ('978-0451524935', '1984', 'George Orwe11', '1949', 'Dystopian'); INSERT INTO books (ISBN, Title, Author, Year, Genre) VALUES ('978-0446310789', 'To Kill a Mockingbird', 'Harper Lee', '1960', 'Southern Gothic'); INSERT INTO books (ISBN, Title, Author, Year, Genre) VALUES ('978-0156028356', 'The Color Purple', 'Alice Walker', '1982', 'Epistolary'); INSERT INTO books (ISBN, Title, Author, Year, Genre) VALUES ('978-1400033416', 'Beloved', 'Toni Morrison', '1987', 'American Literature '); INSERT INTO books (ISBN, Title, Author, Year, Genre) VALUES ('978-1501156748', 'Misery', 'Stephen King', '1987', 'Psychological Horror'); INSERT INTO books (ISBN, Title, Author, Year, Genre) VALUES ('978-0312424464', 'Gilead', 'Marilynne Robinson', '2004', 'Novel'); INSERT INTO books (ISBN, Title, Author, Year, Genre) VALUES ('978-0307265432', 'The Road', 'Cormac McCarthy', '2006', 'Post apocalyptic fiction') Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started