Scribd
Upload
9 views2 pages

Lalit Last Dbms

Uploaded by

Kishan Gupta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views2 pages

Lalit Last Dbms

Uploaded by

Kishan Gupta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

INDEX

S.no. Practical Name Page no.

1. Data Definition Language (DDL)


commands in RDBMS.

2. Data Manipulation Language


(DML) and Data Control Language
(DCL)

3. High level language extensions with


cursors

4. High level language extension with


Triggers

5. Procedures and functions 8 6 embedded


SQL

6. Database design using E-R model and


Normalization

7. Design and implementa on of payroll


processing system

8. Design and implementa on of Banking


system
9. Design and implementa on of Library
Informa on System

10. Design and implementa on of Student


Informa on Systems

11. Automatic backup of files and recovery


of files.

Practical - 1
Data Defini on Language (DDL) commands in RDBMS
1.Create a Table
Syntax:- Create table <table_name> (column1 Datatype (size),
column2 Datatype (size), …);
Query:- create table CUSTOMER (C_id integer, C_name varch
ar(40), C_branch varchar(40));
Result:-

LALIT KUMAR
2209005371046

You might also like