×
Yes, you can do it.
--Your friends at LectureNotes
Close

Database Management System

by Farrukh JamalFarrukh Jamal
Type: PracticalInstitute: Aisect Specialization: Information Technology EngineeringViews: 16Uploaded: 17 days ago

Share it with your friends

Suggested Materials

Leave your Comments

Contributors

Farrukh Jamal
Farrukh Jamal
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
LIST OF EXPERIMENTS Course Title: Database Management System Laboratory Exp. No. Title PAGE NO Course Coordinator 2
HARDWARE AND SOFTWARE REQUIREMENTS • HARDWARE REQUIREMENTS: INTEL PENTIUM 915 GV 80GB HDD 512MB DDR • SOFTWARE REQUIREMENTS: ORACLE 10g, 12c. MY SQL, DB2. 3
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