prepare the following in a single Microsoft Word document and submit it to your facilitator for your
Question:
prepare the following in a single Microsoft Word document and submit it to your facilitator for your assignment:
First you will write some SQL queries that require you to join two tables.
- create a SQL SELECT command that displays the course code, course title, and instructor for all courses in the course list table.
Type the SQL command in your Word document and insert a screenshot of phpMyAdmin showing the successful execution of the command including the results.Insert one or more screenshots as necessary to show everything.
This instruction is the same for all of the following questions.
2. create SQL Select command that displays the course code, instructor, term start and end dates from the course list and term tables.
Now let's add another table
3.make a SQL CREATE TABLE command to prepare a table for "Classroom" that identifies the classrooms for each Classroom code.This is a new table, not defined above.Include the following attributes:
- ClassroomCode
- Location
- Room
- Campus
Identify an appropriate primary key and write the CONSTRAINT clause as part of the CREATE TABLE script to define it as a primary key.
4. Write the SQL INSERT commands to add the following data into your new table.Afterwards perform a SELECT to show all the data in the table and include a screen shot of the results.
ClassroomCode. Location Room Campus
1 Corporate Education Center 112. Tewksbury
2 755 Commonwealth Ave 437 Charles River
3 Boulevard du Triomphe, 174, Triomflaan, 203 Brussels
5.should any changes need to be made to the tables you defined in the previous assignment in order to accommodate the new table "Classroom"?If so, what are they?
6. put a SELECT command that displays the course code, term, instructor, campus, location and room for all courses in the course list table.
7.create a SQL command to add a new column to the Classoom table called Equipment.
8.create SQL command to delete all the records from the Classroom table for Brussels campus.What error did you get when you ran this command in MySQL?What does the error mean?
9.create SQL command to update the ClassroomCode for all courses in the Course_List table currently with a ClassroomCode of 3 so they will now have a ClassroomCode of 1.Perform a SELECT of all the data in the table before you make the update and include a screen shot, and then again after you have made the update.
10. Run your SQL statement from instruction 8 again and provide a screenshot of its successful execution.Why did it work now?
11.write a relationship diagram showing all four tables.The diagram at the top of Assignment 3 is an example of a relationship diagram.
Business and Administrative Communication
ISBN: 978-0073403182
10th edition
Authors: Kitty o. locker, Donna s. kienzler