Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started