Question: Write a SQL ALTER TABLE statement that adds a classroom_id column to the college.students table. This new column should be an INTEGER data type with

Write a SQL ALTER TABLE statement that adds a classroom_id column to the college.students table. This new column should be an INTEGER data type with a max. size of 3 digits, UNSIGNED, it can be NULL and it should work as a FOREIGN KEY that uses as a reference the id column of the college.classrooms table.

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!

MySQL 11. 3. Challenge Altering the comments table A mysql prompt has been opened for you. Using the blog database (use either a single-line or a multi-line SQL statement): 1 - Write a SQL ALTER...

Requesting a Membership database file I can open up to view in reference to the following exercise part 1 - 6 ... I can use with my SQL Server 2016 I recently downloaded. Create a new database named...

1 . Create a new database named Membership. 2 . Write the CREATE TABLE statements needed to implement the following design in the Membership database. Include foreign key constraints. Define...

Book (ISBN, title, author, edition, year) BookCopy (copyNo, ISBN, available) Borrower (borrowerNo, borrowerName, borrowerAddress) BookLoan (copyNo, dateOut, dateDue, borrowerNo) where Book contains...

The scenario is that you are working for a company and they are creating a website that allows users to download manuals and software updates for products they have purchased. They want to track all...

In these activities, youll use SQL Server Management Studio to enter SQL statements and run them against the MyGuitarShop database. 1.Write a script that adds an index to the MyGuitarShop database...

Use the following tables and sample data for your answers to the questions in this assignment. (Please note that the tables have already been normalized.) Use MS SQL Server Management Studio to write...

SQL Homework: exercise 2: CREATE TABLE users ( user_id int Primary key NOT NULL, email_address VARCHAR(20), first_name VARCHAR(20), last_name VARCHAR(20) ); CREATE TABLE downloads ( download_id int...

Using the data presented in P10-21, prepare a worksheet to develop a consolidated statement of cash flows using the direct method for computing cash flows from operations. In p10-21, WEATHERBEE...

The Wechsler IQ test is designed so that the mean is 100 and the standard deviation is 15 for the population of normal adults. Find the sample size necessary to estimate the mean IQ score of...

3 What advice would you give to someone who wanted to make a biological drawing?

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

1. Organize and support your main points

3. Move smoothly from point to point

5. Develop a strong introduction, a crucial part of all speeches