Scribd
Upload
6 views7 pages

DBMS Project Report NEB With SQL Examples-1

The document outlines the practical implementation of SQL commands as per the NEB Class 12 Computer Science syllabus using MySQL DBMS. It includes steps for creating a database, creating tables, and executing commands such as INSERT, SELECT, UPDATE, and DELETE, along with their respective syntax and outputs. Screenshots of each execution are provided separately in the project file.

Uploaded by

joshilokeshextra
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
6 views7 pages

DBMS Project Report NEB With SQL Examples-1

The document outlines the practical implementation of SQL commands as per the NEB Class 12 Computer Science syllabus using MySQL DBMS. It includes steps for creating a database, creating tables, and executing commands such as INSERT, SELECT, UPDATE, and DELETE, along with their respective syntax and outputs. Screenshots of each execution are provided separately in the project file.

Uploaded by

joshilokeshextra
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

COMPUTER PROJECT REPORT

Topic: Database Management System (DBMS)


SQL PRACTICAL IMPLEMENTATION (NEB Syllabus)
This section presents the practical implementation of SQL commands as prescribed in the NEB
Class 12 Computer Science syllabus. All SQL commands were executed using MySQL DBMS.
Screenshots were taken during execution and are attached separately in the project file.

1. Database Creation
A database is created to store related tables. The CREATE DATABASE command is used for this
purpose.
SQL Command Syntax
CREATE DATABASE CREATE DATABASE SchoolDB;

Output: Database 'SchoolDB' created successfully. Screenshot: Screenshot showing successful


execution of CREATE DATABASE command.
2. Table Creation (CREATE TABLE)
Tables are created inside a database to store records in structured format.
SQL Command Syntax
CREATE TABLE Student (
RollNo INT,
Name VARCHAR(50),
Class VARCHAR(10),
Marks INT
CREATE TABLE );

Output: Table 'Student' created successfully. Screenshot: Screenshot showing table structure after
execution.
3. INSERT Command
The INSERT command is used to add records into a table.
SQL Command Syntax
INSERT INSERT INTO Student VALUES (1, 'Ram', '12', 85);

Output: 1 row inserted successfully. Screenshot: Screenshot showing data inserted in Student
table.
4. SELECT Command
The SELECT command is used to retrieve records from a table.
SQL Command Syntax
SELECT SELECT * FROM Student;

Output: All records of Student table displayed. Screenshot: Screenshot showing output of SELECT
command.
5. UPDATE Command
The UPDATE command is used to modify existing records.
SQL Command Syntax
UPDATE UPDATE Student SET Marks = 90 WHERE RollNo = 1;

Output: Record updated successfully. Screenshot: Screenshot showing updated record.


6. DELETE Command
The DELETE command is used to remove records from a table.
SQL Command Syntax
DELETE DELETE FROM Student WHERE RollNo = 1;

Output: Record deleted successfully. Screenshot: Screenshot showing deletion output.

You might also like