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, 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
Get step-by-step solutions from verified subject matter experts
