Question: NEED CODE AND SCREENSHOTS OF OUTPUT ALSO IN MY SQL WORKBENCH PLS 1. Modify the department number of an employee having fname as 'Joyce' to

NEED CODE AND SCREENSHOTS OF OUTPUT ALSO IN MY SQL WORKBENCH

NEED CODE AND SCREENSHOTS OF OUTPUT ALSO IN MY SQL WORKBENCH PLS

1. Modify the department number of an employee having fname as 'Joyce' to 5 2. Alter Table department add column DepartmentPhoneNum of NUMBER data type and insert values into this column only. 3. Alter table department to modify the size of DepartmentPhoneNum. 4. Modify the field name DepartmentPhoneNum of departments table to PhNo. 5. Rename Table Department as DEPT

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!

Assignment 2: 1. Modify the department number of an employee having fname as 'Joyce' to 5 2. Alter Table department add column DepartmentPhoneNum of NUMBER data type and insert values into this...

Using SQL, carry out the various DML and DDL functions on the tables mentioned below: 1. Insert the data given above in both employee, department and project tables. 2. Display all the employees...

Question 1: Triggers and Stored Procedures: Download the file named assignment4_database.sql from D2L. Run the file from MySQL workbench, putty or Terminal. If using Metrostate login via Putty or...

/* company.sql Script to define and populate the example database COMPANY from Chapter 3 of Elmasri and Navathe (pp.70-75 in the 6th edition), with some modifications */ -- drop tables DROP TABLE...

need the sql solution the question relates to the data model shown below in the picture. the sql code needs to be written in regards to the example data model given below ecerything there nothing...

I need help with my assignment I am supposed to use command prompt and sequel for it There are three tasks in this assignment: A) create tables , B) insert data , and C) c omplete queries. For each...

>>> Hello! I have the following sql code to create a new procedure called InsertCustomerWithTransaction. DELIMITER // CREATE PROCEDURE InsertCustomerWithTransaction (IN newCustomerLastName Char(25),...

Feel free to edit the code below to answer questions 1-13 Please note for question 2-8 , this the error message am getting (20:52:54 INSERT INTO PROJECT VALUES('ProductA', 4, 'Bellaire', 2) Error...

0024 WORKS_ON *A PNO 1 2 3 1 2 13 2 ES5N 123456789 123456789 666884444 45 145 1453 451453413 333445555 333445555 333445555 333445555 999887777 999887777 987987987 987987987 987654321 987654321...

The states that a tuple in one relation that refers to another relation must refer to an existing tuple in that relation Select one: O physical data independence NOT NULL constraint O Entity...

Research Methods in Psychology I. Characteristics of Psychology Research Theoretical Framework Explain what a theory is Explain what a hypothesis , is. Explain how it is different than a theory use...

The market price of the common shares of Horokhiv Corporation at the end of fiscal year 2016 was $47.50 and it declared and paid cash dividends of $3.28 per share. What is the dividend yield index...

Describe two of the Help features available in QuickBooks Accountant.

Issued check 1021 for 6000 to office plus as payment on account for invoice 2223. What would be the debit for the general journal.

How can a report writer meet the needs of both primary and secondary readers? Give a specific example. (Objective 3)

What five steps are followed when conducting business research? (Objective 3)

What can a researcher do to create a comfortable, supportive environment for a personal interview? (Objective 3)