Question: Help me plz this qustion use SQL 1. Create a table EMPLOYEE with following schema: (Emp_no, E_name, E_address, E_ph_no, Dept_no, Dept_name, Job_id , Salary) 2.

Help me plz

this qustion use SQL Help me plz this qustion use SQL 1. Create a table

1. Create a table EMPLOYEE with following schema: (Emp_no, E_name, E_address, E_ph_no, Dept_no, Dept_name, Job_id , Salary) 2. Add a new column (Field) HIREDATE to the existing relation. 3. Change the data type of JOB_ID from integer to char. 4. Change the name of column (field) Emp_no to E_no. 5. Modify the column width of the job field of emp table. 6. Insert 4 different records in the table EMPLOYEE

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!

Use SQL 1. Create a table EMPLOYEE with following schema: (EWRRR E_name, E_address, E_ph_no, Dept_no, Dept_name, Job_id, Salary) 2. Add a new column (Field) HIREDATE to the existing relation. 3....

1. Create a table EMPLOYEE with following schema: (Emp_no, E_name, E_address, E_ph_no, Dept_no, Dept_name, Job_id , Salary) 2. Add a new column (Field) HIREDATE to the existing relation. 3. Change...

1. Create a table EMPLOYEE with following schema: (EWRRR E_name, E_address, E_ph_no, Dept_no, Dept_name, Job_id, Salary) 2. Add a new column (Field) HIREDATE to the existing relation. 3. Change the...

DATABASE PROGRAMMING - WRITE THE SQL QUERIES FOR THE FOLLOWING QUESTIONS CREATE TABLE dept ( deptno NUMBER(2,0), dname VARCHAR2(14), loc VARCHAR2(13), CONSTRAINT n_pk_dept PRIMARY KEY (deptno) );...

Please help For each question below, provide solution for DBMS of your choice (Oracle or Microsoft SQL Server) as shown in class. So, your answer must contain the following: SQL command Output from...

PLease Help Submission Guidelines Type your answers in a Word document and upload it in the blackboard. Assignment must be completed individually. Penalty for Late Submission Description of Homework...

Project Specification: 1. Part A: Entity Relationship Diagram 1. Your first task is to study the Case study requirements and gather as much knowledge to list all the main Entities and attributes. 2....

WRITE SQL QUERIES FOR THE FOLLOWING QUESTIONS WHICH IS BASED ON EMPLOYEES TABLE Below is a sample of searched CASE statement. It finds the average salary of the employees in the Employees table,...

Write SQL scripts to retrieve the following using the Oracle demo tables: 7. The name of all customers living in a postcode area starting with BS. 8. The customer ids of all customers whose credit...

Write a literature review on the topic "The effect of supply chain collaboration on innovation" based on the following dimensions 1. Collaborative communication 2. Decision Synchronization 3. Goal...

Given that the random variable X has mean = 120 and SD = 15, find the mean and SD of each of these random variables that are defined from X: (a) X / 3 (b) 2X 100 (c) X + 2 (d) X X

Inventory is always valued at: A . The greater of the net realisable value or cost B . Cost if lower than the net realisable value Selling price less net realisable value D . Selling price less the...

Orion Iron Corp. tracks the number of units purchased and sold throughout each year but applies its inventory costing method at the end of the year as if it uses a periodic inventory system. Assume...

3. Are these strategies used constructively to enhance organizational goal attainment? Are these strategies used for self-serving purposes? Explain.

4. How comfortable are you with introducing yourself to people? What kind of impression do you think you give others? (You may want to check your self-assessment by asking a trusted source what kind...

3. Have you ever felt good or been flattered by someone seeking to network with you? What did the person do to make you feel good about the interaction?