Structured Query
Language (SQL)
Due Week 7 and worth 75
points
Refer to the database
design crested in Lab 2: Modifying a Database Design to complete this
Lab.
Perform the following
steps in MySQL:
1.
Create the tables and
relationships from the database design discussed in Lab 2.
2.
Add at least five (5)
records into each table (Note: You must determine the field values).
3.
Create a query with
all fields from the student table, where the student’s last name is
“Smith”.
4.
Create a query that
includes students’ first names, last names, and phone numbers.
5.
Create a query that
includes instructors’ first names, last names, and courses they teach.
Include the following
screen shots in a Microsoft Word document to show the completion of the steps
above:
·
Screen shot depicting
the tables created within MySQL.
·
Screen shots depicting
the records added into each table.
·
Screen shots depicting
the SQL code and the query results from each of the queries created.
Your assignment must
follow these formatting requirements:
·
Submit the lab as a
Microsoft Word document.
·
Include a cover page
containing the title of the assignment, the student’s name, the professor’s
name, the course title, and the date. The cover page is not included in the
required assignment page length.
The specific course
learning outcomes associated with this assignment are:
·
Prepare database
design documents using the data definition, data manipulation, and data control
language components of the SQL language.
