DBMS LAB 3

-


Database Schema for a Employee-pay scenario

employee(emp_id : integer, emp_name: string)
department(dept_id: integer, dept_name:string)
paydetails(emp_id : integer, dept_id: integer, basic: integer, deductions: integer, additions: integer, DOJ: date)
payroll(emp_id : integer, pay_date: date)

For the above schema, perform the following—
a)   Create the tables with the appropriate integrity constraints
b)   Insert around 10 records in each of the tables
c)   List  the employee details department wise
d)   List all the employee names who joined after particular date    
e)   List  the details of employees whose basic salary is between 10,000 and 20,000
f)    Give a count of how many employees are working in each department
g)   Give a names of the employees whose netsalary>10,000 
h)   List the  details for an employee_id=5
i)    Create a view which lists out the emp_name, department, basic, dedeuctions, netsalary
j)    Create a view which lists the emp_name and his netsalary

Comments

Post a Comment

Popular posts from this blog

PROCEDURE TO CREATE AN ANIMATION TO REPRESENT THE GROWING MOON.

-
Image
1.       Open flash 8 software -> click on flash document ->go to windows->properties ->select the properties tool-> choose the Background to black. 2.       Go to fill color under tool bar-> select the white color. 3.       Select the oval tool in order to draw the moon. u will get a white circle. 4.       Select the oval tool in order to draw the moon. u will get a white circle. 5.       Select the white circle on the worksheet using the selection tool ->right click- >convert to symbol ->select movie clip ->give suitable name e g: moon->click ok. 6.       Go to filter ->click on the + symbol->select glow to apply glowing effect-> select the color to white under glow and adjust the blur x/blur y values. 7.       Click on the + symbol again and chose blur-> again adjust the blur x/blur y values. 8.       Place the moon where ever you want on the work area. Double click on layer 1 and
Read more

PROCEDURE TO CREATE AN ANIMATION TO INDICATE A BALL BOUNCING ON STEPS.

-
Image
1.     Go to start- macromedia- click on flash document 2.     Select the line tool and draw the steps. color it using the paint bucket tool 3.     Select the circle from the tool bar and create a circle on the work area. 4.     Now fill the color to the circle using the paint bucket tool from the tool bar. 5.     Go to frames right click on the first frame and choose insert key frame. Slightly move the ball. Repeat the same procedure by adding new key frames to show the ball change the shape of the ball slightly when it touches the surface. 6.     In order to change the shape use the free transform tool. 7.     Go to control and click on test movies .you will observe the ball bouncing on steps.
Read more

PROCEDURE TO CHANGE A CIRCLE INTO A SQURE USING FLASH.

-
Image
1.   Go to start->macromedia->flash document 2.    Select the circle tool from the tool bar. draw a circle on the work area.colour it 3.   Click on the 40 th key frame-> insert new key frame. 4.    Selecting the last key frame ->draw a rectangle on the circle by selecting the rectangle tool bar so that it will cover the circle. colour the rectangle by the different colour. 5.   Again click on the last frame->under properties ->under tween ->change the option shape from none. 6.   Then again select the last but one frame ->go to properties->tween ->change to shape. 7.   Go to control->test movie ->see the circle changing in to rectangle. OUTPUT
Read more