Create tables according to the mapping. For this part, submit a description of the tables created....

Transcribed Image Text:

Create tables according to the mapping. For this part, submit a description of the tables created. • Add at least five records. Submit a copy of all the records inserted. • Write and answer some (at least five) "reasonable" queries for your database. When I say reasonable queries - I mean 3-4 table joins to use most of the tables or group of tables in your database. You should not have tables that are of no use. For this part, first, write the queries in English - that is, telling me what you are finding in the queries. Then, present the query and finally present the output of the query (as you do for your homework assignments). Note this part is not done in actual Oracle student database. Create tables according to the mapping. For this part, submit a description of the tables created. • Add at least five records. Submit a copy of all the records inserted. • Write and answer some (at least five) "reasonable" queries for your database. When I say reasonable queries - I mean 3-4 table joins to use most of the tables or group of tables in your database. You should not have tables that are of no use. For this part, first, write the queries in English - that is, telling me what you are finding in the queries. Then, present the query and finally present the output of the query (as you do for your homework assignments). Note this part is not done in actual Oracle student database.

Answer rating: 100% (QA)

Answer The code is as follow Table Wars CREATE TABLE Wars warid INT PRIMARY KEY AUTOIN... View the full answer