LAB Assignment 1

Developing a database engine using C:

accountID

Name

Address

Salary

transactionID

accountID

amount

The first table (employee) can be designed using

struct employee {

int accounted;

char Name[30];

char Address[30];

float Salary;

} emp;

similarly second table can be designed.

Handling queries:

1. Find out the Name of the person whose salary is more than 5000 tk?
2. JOINING TABLES (both tables) : exampleà Find out the Name of the person who transacted more than 5000 TK.

Handling SQL command prompt:

Exampleà If I give input: “select Name from Employee where Salary>5000”

It will execute ‘handling queries’ number 1.

These will be given to solve in home.

Give similar examples in LAB (Lab instructor).