Scribd
Upload
3 views1 page

Dbms Lab Questions

The document outlines a series of lab questions related to database management systems, focusing on SQL and MongoDB operations. It includes tasks for creating tables, inserting records, updating data, and querying information for students, courses, and employees. The questions cover various database operations such as modifying table structures, performing selections, and deletions.

Uploaded by

haseeb.dotin
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
3 views1 page

Dbms Lab Questions

The document outlines a series of lab questions related to database management systems, focusing on SQL and MongoDB operations. It includes tasks for creating tables, inserting records, updating data, and querying information for students, courses, and employees. The questions cover various database operations such as modifying table structures, performing selections, and deletions.

Uploaded by

haseeb.dotin
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

DATABASE MANAGEMENT SYSTEM LAB QUESTIONS

1. create table student with attributes

Student_id int primary key, name varchar, email varchar, Marks int

i) insert 5 records and show all the inserted record

ii) Add new column phone number to student

iii) Modify the size of email to varchar(30)

2. create table student with attributes

Student_id int primary key, name varchar, email varchar, phone varchar, marks int

i) insert 5 records

ii) Update email of a student and show all the records

iii) Select student name who have marks greater than 80

iv) Delete one student

3. create table Course with attributes

Course_id int primary key, course_name

varchar, Create table student with

attributes

Student_id int primary key, name varchar, course_id int, foreign key(Course_id of Course)
i) Insert 3 records

ii) Find all course names of student_id in s01 and s02

iii) List all course names and student names together in one column

4. Create table Employee with attributes

Employee_id int primary key, Employee name varchar, Salary int

i) insert 5 records

ii) find the total number of Employees

iii) find the Sum of salary

iv) find the name of Employee with Minimum Salary

5. Using MongoDB create a table student

i) Insert 3 records

ii) display all details of student

iii) display the student of student_id = s01

iv) delete one student

You might also like