[go: up one dir, main page]
Scribd
Upload
36 views1 page

DBMS Experiment 1

The document outlines an experiment focused on creating a table and inserting data into it using SQL. It includes the SQL code for creating a 'Students' table with attributes like RollNo, Name, Age, and Course, along with sample data insertion. The aim is to provide practical experience in database management system operations.

Uploaded by

kumarrohit06071999
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
36 views1 page

DBMS Experiment 1

The document outlines an experiment focused on creating a table and inserting data into it using SQL. It includes the SQL code for creating a 'Students' table with attributes like RollNo, Name, Age, and Course, along with sample data insertion. The aim is to provide practical experience in database management system operations.

Uploaded by

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

DBMS Practical File

Experiment 1: CREATE TABLE and INSERT DATA

Aim:
To learn how to create a table and insert values into it.

SQL Code:
CREATE TABLE Students (
RollNo INT PRIMARY KEY,
Name VARCHAR(50),
Age INT,
Course VARCHAR(50)
);

INSERT INTO Students VALUES


(1, 'Aman', 20, 'BCA'),
(2, 'Neha', 21, 'BCA'),
(3, 'Ravi', 22, 'BCA');

Output:

You might also like