Question: Question- 2 Create Database : Records Create Table : Emp EmpNo (Not Null, unique) EName (Not Null) Job (Not Null) ManagerNo HireDate (Not Null) Salary

Question- 2

Create Database : Records

Create Table : Emp

EmpNo

(Not Null, unique)

EName

(Not Null)

Job

(Not Null)

ManagerNo

HireDate

(Not Null)

Salary

(Not Null, >1000)

Commission

DeptNo

(Not Null)

1001

Gohar

Salesman

512

18-Dec-11

1600

400

20

1002

Ahmed

Clerk

511

28-Nov-11

1250

10

1003

Shahid

Manager

505

11-Jun-11

10000

20

1004

Toqeer

Salesman

512

15-Dec-10

2700

300

20

1005

Asif

Manager

505

18-Dec-10

12000

15

1006

Babar

Salesman

512

14-Nov-10

4000

500

20

1007

Kashif

President

21-Oct-10

20000

10

1008

Zubair

Manager

505

8-Dec-09

15000

10

1009

Yasir

Clerk

511

18-Dec-09

1650

15

1010

Salman

Salesman

512

10-May-09

5300

700

20

1011

Hafeez

Clerk

511

1-Jan-09

1500

15

Perform the following queries for above table:

  • List all Salesman and add 500 to their salaries, also change the column heading to Salary With Bonus.

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!

Q:

Create Database : Records Create Table Emp EmpNo EName Job Manager No (Not (Not Null) (Not Null) Null, unique) 1001 Gohar Salesman 512 1002 Ahmed Clerk 511 Hire Date (Not Null) Commission Salary (Not...

Q:

Create Database : Records Create Table Emp ManagerNo Commission EName Job (Not Null) (Not Null) HireDate (Not Null) EmpNo (Not Null, unique) Salary (Not Null, >1000) DeptNo (Not Null) 1001 Gohar...

Q:

Consider the following schema tables and answer the questions below CREATE TABLE DEPT ( DEPTNO NUMBER(2) NOT NULL, DNAME CHAR(14), LOC CHAR(13), CONSTRAINT DEPT_PRIMARY_KEY PRIMARY KEY (DEPTNO));...

Q:

Consider the following schema tables and answer the questions below CREATE TABLE DEPT ( DEPTNO NUMBER(2) NOT NULL, DNAME CHAR(14), LOC CHAR(13), CONSTRAINT DEPT_PRIMARY_KEY PRIMARY KEY (DEPTNO));...

Q:

CREATE TABLE DEPT ( DEPTNO NUMBER ( 2 ) NOT NULL, DNAME CHAR ( 1 4 ) , LOC CHAR ( 1 3 ) , CONSTRAINT DEPT _ PRIMARY _ KEY PRIMARY KEY ( DEPTNO ) ) ; INSERT INTO DEPT VALUES ( 1 0 , 'ACCOUNTING','NEW...

Q:

Start SQL*Plus CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER(7, 2), COMM NUMBER(7, 2), DEPTNO NUMBER(2)); INSERT INTO EMP...

Q:

Start SQL*Plus database: CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER(7, 2), COMM NUMBER(7, 2), DEPTNO NUMBER(2)); INSERT...

Q:

SER322 Database Management Systems Lab: JDBC programming and XML This lab asks you to write simple JDBC programs, and execute an XPath query. What you will need: A MySQL server installation A MySQL...

Q:

USING MYSQL Create a database instance named jdbclab in MySQL Load the JDBCLabInit.sql into the jdbclab space in MySQL provided below CREATE TABLE DEPT ( DEPTNO INTEGER NOT NULL, DNAME VARCHAR(14),...

Q:

// Create an export method to export the entire database to an XML file. // This would be invoked on the command line as java Export url user pwd driver export filename class Export { public void...

Q:

(a) Explain what diminishing returns and economies of scale mean? (b) Compare and contrast diminishing return and economies of scale? (c) Give examples of diminishing returns and economics of scale?

Q:

Blacken Company manufactures motorcycles. The company's management accountant wants to calculate the fixed and variable costs associated with the usage cost incurred by the factory. Data for the last...

Q:

One of the major advantages associated with liquid money market securities is safety of principal. False True

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

10. Information about career plans and talent evaluation is accessible to all managers.

Q:

2. Discuss the implications that the career development model presented in this chapter may have for training and development activities.

Q:

9. System creates a large, diverse talent pool.