Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

How is the NDAA used to shape defense policies indirectly?

Answered: 1 week ago