DBMS UNIT-1 ASSIGNMENT QUESTIONS

1.Define the following terms: data, database, DBMS, database system,database catalog, program-data independence, user view, DBA, end user, canned transaction, deductive database system, persistent object,meta-data, and transaction-processing application.

2.  Discuss the main characteristics of the database approach and how it differs from traditional file systems.

3.What are the responsibilities of the DBA and the database designers?

4. What are the different types of database end users? Discuss the main activities of each.

5. Discuss the capabilities that should be provided by a DBMS.

1.Define the following terms: data, database, DBMS, database system, database catalog, program-data independence, user view, DBA, end user, canned transaction, deductive database system, persistent object, meta-data, and transaction-processing application.

2.  Discuss the main characteristics of the database approach and how it differs from traditional file systems.

3.What are the responsibilities of the DBA and the database designers?

4. What are the different types of database end users? Discuss the main activities of each.

5. Discuss the capabilities that should be provided by a DBMS.

1. Explain Rules for overloading operators?
2. Explain Binding in c++?
3. Explain Exception Handling?

Exception Handling Lab Program

#include <iostream>
double division(int a, int b)
{
     if( b == 0 )
     {
                throw "Division by zero condition!";
      }
      return (a/b);
}
int main ()
 {
int x = 20;
int y = 0;
double z = 0;
try
{
     z = division(x, y);
     cout << z << endl;
}
catch (const char* msg)
{
     cerr << msg << endl;
}
return 0;
}

OOP THROUGH C++ ASSIGNMENT 3 QUESTIONS

1. Explain Classes in c++?
2. Explain Defining Member functions?
3. Explain Data Hiding?
4. Explain the following?
    a) static Member Variables
    b) static Member Functions
    c) static Object
5. Explain friend Functions?
6. Explain friend Classes?

Write a C++ program to check whether the given number is even or odd (using ? : ternary operator )

#include<iostream>

int main()

{

int a;

cout<<"Enter a Number : ";

cin>>a;

(a%2==0)?cout<<"Number is even":cout<<"Number is odd";

cin.ignore();

cin.get();

return 0;

}

Write a C++ Program illustrating Function Overloading.

#include<iostream.h>

#include<stdlib.h>

#include<conio.h>

#define pi 3.14

class fn

{

public:

void area(int); //circle

void area(int,int); //rectangle

void area(float ,int,int); //triangle

};

void fn::area(int a)

{

cout<<"Area of Circle:"<<pi*a*a;

}

void fn::area(int a,int b)

{

cout<<"Area of rectangle:"<<a*b;

}

void fn::area(float t,int a,int b)

{

cout<<"Area of triangle:"<<t*a*b;

}

void main()

{

int ch;

int a,b,r;

clrscr();

fn obj;

cout<<"\n\t\tFunction Overloading";

cout<<"\n1.Area of Circle\n2.Area of Rectangle\n3.Area of Triangle\n4.Exit\n:”;

cout<<”Enter your Choice:";

cin>>ch;

switch(ch)

{

case 1:

cout<<"Enter Radius of the Circle:";

cin>>r;

obj.area(r);

break;

case 2:

cout<<"Enter Sides of the Rectangle:";

cin>>a>>b;

obj.area(a,b);

break;

case 3:

cout<<"Enter Sides of the Triangle:";

cin>>a>>b;

obj.area(0.5,a,b);

break;

case 4:

exit(0);

}

getch();

}