Due Week 7 [11/19/14] and worth 75 points;Refer to the database design crested in Lab 2: Modifying a Database Design in;Visio 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;na me, the professor?s name, the course title, and the date. The cover;page is not included in the required assignment page length.
Paper#64148 | Written in 18-Jul-2015Price : $27