×
Aiming for the stars? Great, but did you have to build a rocket first.
--Your friends at LectureNotes
Close

Lab Manuals for Database Management System - DBMS By Farrukh Jamal

  • Database Management System - DBMS
  • Practical
  • Aisect - Aisect
  • Information Technology Engineering
  • 63 Views
  • Uploaded 10 months ago
Farrukh Jamal
Farrukh Jamal
0 User(s)
Download PDFOrder Printed Copy

Share it with your friends

Leave your Comments

Text from page-1

DEPARTMENT OF COMPUTER SCIENCE AND INFORMATION TECHNOLOGY LAB MANUAL Academic Year: 2016-17 Course Title: DATABASE MANAGEMENT SYSTEM LAB MANUAL Prepared By SIDDHARTH KUMAR (Assistant Professor), Department of Computer Science and Information Technology) AISECT University Matwari Chowk Infront of Gandhi Nagar Maidan , Hazaribagh, Jharkhand E-Mail-info@aisectuniversityjharkhand.ac.in Website : www.aisectuniversityjharkhand.ac.in 1

Text from page-2

LIST OF EXPERIMENTS Course Title: Database Management System Laboratory Exp. No. Title PAGE NO Course Coordinator 2

Text from page-3

HARDWARE AND SOFTWARE REQUIREMENTS • HARDWARE REQUIREMENTS: INTEL PENTIUM 915 GV 80GB HDD 512MB DDR • SOFTWARE REQUIREMENTS: ORACLE 10g, 12c. MY SQL, DB2. 3

Text from page-4

EXPERIMENT NO 1: CREATION AND INSERTION IN TABLE CREATION OF TABLE: SYNTAX: create table<tablename>(column1 datatype,column2 datatype...); EXAMPLE: SQL>create table std(sno number(5),sname varchar(20),age number(5),sdob date,sm1 number(4,2),sm2 number(4,2),sm3 number(4,4)); Table created. INSERTION: SQL>insert into std values(101,‟AAA‟,16,‟03-jul-88‟,80,90,98); 1 row created. SQL>insert into std values(102,‟BBB‟,18,‟04-aug-89‟,88,98,90); 1 row created. OUTPUT: Select * from std; SNO SNAME AGE SDOB SM1 SM2 SM3 101 AAA 16 03-jul-88 80 90 98 102 BBB 18 04-aug-89 88 98 90 EXPERIMENT NO 2: ALTER TABLE WITH ADD SQL>create table student(id number(5),name varchar(10),game varchar(20)); Table created. SQL>insert into student values(1,‟mercy‟,‟cricket‟); 1 row created. SYNTAX: alter table<tablename>add(col1 datatype,col2 datatype..); EXAMPLE: SQL>alter table student add(age number(4)); SQL>insert into student values(2,‟sharmi‟,‟tennis‟,19); OUTPUT: ALTER: select * from student; ID NAME GAME 1 Mercy Cricket ADD: select * from student; ID NAME GAME AGE 1 Mercy cricket 2 Sharmi Tennis 19 4

Lecture Notes