DBMS Programs

Data Base Management Programs (DBMS)

Done in oracle 10G

1) To find sum of 2 given numbers
2) To find average of 3 given numbers
3) To check whether a student is pass or fail for a given mark
4) To find whether a given number is odd or even
5) To find factorial of a given number
6) To calculate sum of numbers from m to n
7) To check whether given number is prime or not
8) To display numbers from m to n
9) Exception zero_divide1
10) Exception zero_divide2
11) Exception zero_divide3
12) Invalid number exception
13) Others exception
14) Others exception should be at the end
15) Creation of table
16) Insertion of values
17) Selection of a table
18) Views
19) Aggregate functions
20) Joins
21) Conversion functions
22) Number functions
23) Case function
24) Date functions
25) Calculating area of circle for given radius

For Above Programs Download Following Link:

http://www.ziddu.com/download/8088156/DBMS.doc.html

More Examples:

Bank Database Schema:

http://www.ziddu.com/download/8088154/bankdatabase.doc.html

Sailor Database Schema:

http://www.ziddu.com/download/8088157/salorsdatabase.doc.html

Company Database Schema:

http://www.ziddu.com/download/8088155/companydatabase.doc.html