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...
Category: LAB
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....
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...
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...
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...
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...
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...
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...
Ex.No:1 Student Database using Classes and Objects
AIM: To write a C++ program to create a student database using classes and objects. ALGORITHM: STEP 1: Start the program. STEP 2: Declare the data members. STEP 3: Define the...
Ex.No:5 solving problems using String functions
AIM: To write a C program to illustrate any five string functions. ALGORITHM: Step 1: Start the program. Step 2: Read the string str1 and choice. Step 3: If choice is...