Structured Query Language (SQL) Due Week 7 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: Create the tables and relationships from the database design discussed in Lab 2. Add at least five (5) records into each table (Note: You must determine the field values). Create a query with all fields from the student table, where the student's last name is "Smith". Create a query that includes students first names, last names, and phone numbers. 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. MODIFYING A DATABASE DESIGN IN VISIO Katina Howard May 3, 2015 Intro to Relate Database Mgmt. System Prof. REUVEN COHEN Lab 2 week 4: Modifying a Database Design in Visio MODIFYING A DATABASE DESIGN IN VISIO The Business rules are, A student can take one or more courses. A course can be offered more than one time during a year and by different (or same) instructor each time. A student will have grades for the courses they take. A student and an instructor can have more than one email and phone numbers. In the database design for the college, there are various entity sets and relationship sets among those entity sets. There are 3 primary entity sets. Those are, Student, Course and Instructor. Each of these entity set has its own attributes describing various information about the entity set. Phone Number and Email are multivalued attribute for entity sets Student and Instructor. So, those are separated. The primary key of the Student and Instructor has been introduced as primary key for the respective PhoneNumber and Email entity sets. The references between the primary entity sets and their PhoneNumber and Email entity sets have been represented by foreign keys in those entity sets from the primary entity sets. \"A ternary relationship is when three entities participate in the relationship\". There is a ternary relationship set called StudentCourseInstructor, in this design. It represents which student is taking what course under which Instructor. The primary keys from Student, Instructor and Course are combined and serves as composite primary key for this relationship set. MODIFYING A DATABASE DESIGN IN VISIO MODIFYING A DATABASE DESIGN IN VISIO REFERENCES https:/ationalvetcontent.edu.au/.../er_model_relnshps.htm