Question: 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

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. Change the data type of JOB_ID from integer to char. 4. Change the name of column (field) Empare to E_no. 5. Modify the column width of the job field of edup, 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!

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. Add a new column (Field) HIREDATE to...

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...

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) );...

-- DESCRIPTION -- This script creates the SQL*Plus demonstration tables in the -- current schema. It should be STARTed by each user wishing to -- access the tables. SET TERMOUT ON PROMPT Building...

Consider the following relational schema: Staff ( staffNo , name, dept, skillCode) Skill ( skillCode , description, chargeOutRate) Project ( projectNo ,...

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...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

This uses microsoft SQL management Studio I. OBJECTIVES At the end of this activity, the students will be able to: 1. Create, Alter, and Drop SQL VIEWs. 2. Understand the use of WITH SCHEMABINDING....

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....

1. Can a virtual image be photographed? 2. Answer Problem 9 for a convex mirror.

Use the May 31 fiscal year-end information from the following ledger accounts (assume that all accounts have normal balances). General Ledger M. Muncel, Capital Acct. No. 301 Salaries Expense Acct....

The yield on a corporate bond with a 2 0 year maturity would include A . only the real rate of interest and expected inflation. 8 0 the reel rate eff interest the expected inflation rate and a...

The following dAta were collected in the laboratory on the filteration of a caco 3 sludge Through a washing plate - and frames Filter press. After assembling the press, The data was taken by noting...

Provide examples of KPIs in Human Capital Management.

What would an Internal Compa-Ratio of 118% indicate for an employee?

What are OLAP Cubes?