Question

Employee table has following fields:
EMP_ID, EMP_NAME,GatePass_No, License_No, Dept_idDepartment table has following fields:
Dept_id, Dept_name
Answer the following questions based on above tables:
a.Which is the most suitable primary key field in Employee table and why?
b.Write a query to create Employee table
c.Write a query to create Department table

Answer 1

Answer:

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:

EMPLOYEES

EMPLOYEE_ID NUMBER

DEPARTMENT_ID NUMBER

MANAGER_ID NUMBER

LAST_NAME VARCHAR2(25)

DEPARTMENTS

DEPARTMENT_ID NUMBER

MANAGER_ID NUMBER

DEPARTMENT_NAME VARCHAR2(35)

LOCATION_ID NUMBER

1. You want to create a report displaying employee last names, department names, and locations. Which query should you use to create an equi-join?

A. SELECT last_name,