Question: Objective: To get a hands-on learning experience with SQL DDL. Note: This assignment could be completed on either MySQL Workbench or PhpMyAdmin. Again, make sure

 Objective: To get a hands-on learning experience with SQL DDL. Note:This assignment could be completed on either MySQL Workbench or PhpMyAdmin. Again,

Objective: To get a hands-on learning experience with SQL DDL. Note: This assignment could be completed on either MySQL Workbench or PhpMyAdmin. Again, make sure you start XAMPP servers before working with either of those programs. This assignment accounts for 20 points; 2 points for each part, except for part 1 which counts for 8 points. Assume you have the following relations. 1. Write the SQL DDL to create the above relations with the sample data inside them keeping into account the foreign key constraints. Assume the following data types. 2. Add an attribute Class to the Student table, then drop it 3. Create a new Dummy table, then remove it 4. Change the FacultyName field from 25 characters to 40 characters 5. Create two different forms of the INSERT command to add a student with a student ID of 65798 and last name Lopez to the Student table. 6. Now write a command that will remove Lopez from the Student table. 7. Create an SQL command that will modify the name of course ISM 4212 from Database to Introduction to Relational Databases

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!