Databases | SQL | Oracle | MS Access Answers

2.3.1 Which query can produce a contrasting answer? Give the simplest database instance you can think of where a different answer is produced.

1.2 SELECT and RETURN all students with qualification HCIT from relations STUDENTS X BOOKS.

If we apply the cross-product operation to these two instances of STUDENTS & BOOKS, what would be the resulting relation?

Develop an Institution management system (based on VB.NET platform) linked with Microsoft Access Database as infrastructural support. The primary purpose of this application is to automate students, modules, staff’s information and other data resources.

First record in transaction file is read

2

First record in the old master file

is read

3

REPEAT

4

IDs are compared

5

IF IDs do not match, old master file record is written to new master file

6

IF IDs match transaction/calculation is carried out

7

Computer calculates the pay, Rate (from master file) mul

tiplied by

hours worked

(from transaction file)

8

Wages_to_date is updated and record is written to new master file

9

IF IDs match, next record from transaction file is read

10

Next record from master file is read

11

U

NTIL end of transaction file

12

Remaining records of the master file are written to the new master file

Write a PL/SQL program to find area and perimeter of rectangle.

Consider a relation Employee with following attributes:

Name Null Type

-------------------------------- ----------------------- -------------------------

EMPNO NOT NULL NUMBER(4)

ENAME VARCHAR2(10)

JOB VARCHAR2(9)

MGR NUMBER(4)

HIREDATE DATE

SAL NUMBER(7,2)

COMM NUMBER(7,2)

DEPTNO NUMBER(3)

AGE NUMBER(3)

ESAL NUMBER(10)

a. List minimum , maximum , average salaries of employee.

b. What is the difference between maximum and minimum salaries of employees in the organization?

c. Display all employee names and salary whose salary is greater than minimum salary of the company and job title starts with ‘M’.

d. Display total salary spent for each job category.

e. Display lowest paid employee details under each manager.

create table emp with attributes (eid number,ename varchar2(10),age number,salary number);

a. Count number of employee names from employee table.

b. Display the Sum of age employee table.

c. Find grouped salaries of employees (group by clause).

d. Find salaries of employee in Ascending Order (order by clause).

e. Find salaries of employee in Descending Order.