0

EX.No: 3   CONSTRAINTS

AIM To work on various constraints in DBMS CONSTRAINTS Constraints are part of the table definition that limits and restriction on the value entered into its columns. TYPES OF CONSTRAINTS: 1) Primary key 2) Foreign...

0

Ex:no:2 Data Manipulation Language

Aim: To perform insertion, deletion, modification of records based on some conditions and to execute the DCL and TCL commands Insert command: Insert command is used to insert single or multiple rows in the table....

0

Ex: NO:1 SQL QUERIES FOR CREATION OF DATABASE

Aim: To execute the queries to create and alter the schema of the database. Data Definition in SQL Creating Tables: The SQL command for creating an empty table has the following form: Syntax: create table...

0

PREREQUISITES FOR THE DBMS LAB

The prerequisites of the lab are: 1. Oracle-Sql 2. Visual Basic 6.0 SQL:          In relational database systems (DBS) data are represented using tables (relations). A query issued against the DBS also...

0

Ex.No:3c Dynamic Constructors

AIM:          To write a C++ program for string manipulation using dynamic constructors. ALGORITHM: STEP 1: Start the program. STEP 2: Declare the data members and member functions. STEP 3: Define the...

0

Ex.No:3a Constructor Overloading

AIM:          To write a C++ program for maintaining bank account using constructor overloading. ALGORITHM: STEP 1: Start the program. STEP 2: Declare the data members and constructors. STEP 3: Define the...

0

Ex.No:2b Inline Funtions

AIM:           To write a C++ program to perform arithmetic operation using inline function. ALGORITHM: STEP 1: Start the program. STEP 2: Declare and define inline functions ie. ‘add()’,’sub()’,’mul()’,’div()’. STEP 3: Assign...

0

Ex.No:2a Static Data and Function Members

AIM:           To write a C++ program using static data member and static member function. ALGORITHM: STEP 1: Start the program. STEP 2: Declare static variable ‘count’. STEP 3: Define static variable...