S.

NO LAB ASSIGNMENT PAGE DATE SIGNATURE

NO

1 What do you mean data , information , 21/08/23

database , DBMS and RDBMS.

2 Write steps to open Microsoft 21/08/23

Access .Write steps to create a
database. What are the various
elements or objects of a database ?
What are the various ways ways to
create tables in database?

3 Define and Write features of SQL. 22/08/23

4 Write steps to create table in design 22/08/23

view and datasheet view.

5 What do you mean by field 28/08/23

name ,datatype , field size and
description.

6 Give the steps to open an existing 28/08/23

database.

7 29/08/23
Create a student Database with a table
Student_Details containing the
following fields:

1. Student_Id

2. First_Name

3. Last_Name

4. Age

5. Address

Insert 5 records using design view.

Create another table using Datasheet

view as Student_course with the
 following fields.

1. Course_id

2. Course_code

3. Course_name

Enter 5 records.

8 4/09/23
Create a Database Student_Data with
S1 as the table name containing the
following fields.

1. Enrollment_No

2. Name

3. Age

4. DOB

5. Phone_No

6. Address

Insert atleast 10 Records.

9 5/09/23
Create a Database DB1 with a table
T1 with the following fields.

1. ST_No

2. ST_ID

3. ST_Name

4. ST_Address

5. ST_Phone_No

6. ST_Hobbies
 Insert atleast 10 Records in the
table using Design View.

10 Create a Database named Employee 11/09/23

and create a table named
Employee_data with the following
fields:

1. Employee_id

2. Employee_name

3. SSN_no

4. Employee_designation

5. Employee_department

6. Date_of_joining

7. Salary

8. Years_of_experience
Insert any 10 records and delete any 2
records. Also delete one field i.e.
SSN_no from the table.

11 Create an Employee Database with 11/09/23

the following fields:

1. Employee_code

2. Employee_SSN

3. Employee_name

4. Date_of_birth

5. Employee_designation

6. Employee_department

7. Date_of_joining

8. Employee_salary
 9. Years_of_experience
For the above created Database set the
following field properties:

1. Employee’s name should be in

the uppercase with field
size=10.

2. Set the default value of

Employee_department as HR.

3. Date of joining should be set to

current date by default.

4. Employee_salary should be in
Euro.
Using general wizard.
12 Create an employee database with the 12/09/23
following fields.

1. Employee_code

2. Employee_ssn

3. Employee_name

4. Employee_DOB

For the above created database set the

input mask for the field property
Employee_ssn and Employee_DOB
using input mask wizard.

13 Create a table Student_details with the 18/09/23

following fields:

1. S_ID

2. S_name

3. S_course
 4. S_marks

5. S_DOB

Make S_ID as a primary key and

apply the following validations:

1. S_name should start with A

and end with M.

2. S_course can have only BBA

or MBA.

3. S_marks can be NULL or

should be greater than 50.

4. S_DOB should be less than the

current date,

Enter atleast 10 records in the table.

14 Create a local template of 19/09/23

“FACULTY”, insert 5 records and
perform the following queries on
faculty template table:

1. Insert 5 records using “new

faculty” tab in faculty template.

2. Faculty name should be in

ascending order.

3. Department should be in
descending order.

4. Generate report for: All faculty

category and faculty by
department category.
15 Create a database name student with a 19/09/23
table student_details with the
 following fields.

1. Stu_id

2. Stu_roll

3. Stu_name

4. Stu_age

5. Stu_dob

6. Stu_course

7. Stu_address

8. Stu_contact
Add atleast 7 records in the table.
Answer the following.

1. What is a primary key. Name a

field stu_id. Also write the
steps for the same.

2. What is composite key. In the

table make stu_role and
stu_dob as the composite key
and write the steps for the
same.
16 Create a company Database with the 25/09/23
following table:

1. Emp_details with the following

fields:

a. Emp_ID

b. Emp_name

c. Emp_designation
Make Emp_ID as a primary key

2. Dept_details with the following

fields:

a. Dept_ID
 b. Dept_name

c. Dept_location

3. Projects with the following fields:

a. P_ID

b. P_name
Designate primary key in all the
tables. Establish the relationship
between the table Emp_details and
Dept_details as 1:1, 1:M and M:1.
Also establish a relationship between
the table Emp_details and projects as
1:1. Enforce referential integrity
constraints on it and write down the
steps for the same.

17 Explain in brief about the query object 26/09/23

in MS Access 2007. Write steps to
execute queries using the query
wizard. Create an Account_details
table with the following fields:

1. Acc_no

2. Acc_type

3. Date_of_opening

4. Transaction_type

5. Balance

6. AccH_name

7. Transaction ID
Enter 10 records in the table and
perform the following queries on it.

1. Display the Acc_no in ascending

order

2. Display the details of account

 where Acc_no is 675

3. Display the details where Acc_no

is 675 and name is Ajay

4. Display the Acc_no, Acc_type,

AccH_name, and balance is
greater than 5000
18 Create a table student with the 3/10/23
following fields

1. Enroll no.

2. Stu_name

3. Course_id

4. Batch

5. Semester
Execute the following query after
entering 10 records in the table

1. Display the list of students in

batch 2017-20

2. Display the enroll_no. Of fourth

semester students

3. Display the list of students of

batch 2017-20 and course_id =17

4. Display the number of students in

course_id = 444
19 Create a table Customer having the 3/10/23
following fields and Data types:

Field Name Data type

Customer_ID Number

Customer_name Short text

Designation Short text

City Short text

 Country Short text

Phone Number

Insert the data into the table Customer

and apply the queries:

1. Display customer details having

designation Sales representative.

2. Retrieve customers who is living

in Canada.

3. Show deails of the customer

whose name is Victoria.

4. Show details of the customer who

lives in Sweden.

5. Show details of the customer who

is owner.
20 Create a table named as STUDENT 9/10/23
with the following fields:

1. Serial_no

2. Name

3. City

4. Age

5. Marks
Execute the following queries after
entering 10 records in the table:

1. Display all the details of the given

table

2. Display the names in alphabetical

order

3. Display the marks along with the

names where the marks are greater
than 60

4. Display the name of the students

 whose name starts with the letter
"A"

5. Display the details of students who

lives in "Delhi"

6. Display the details of students who

are older than 10 years
21 Create a table employee with the 9/10/23
following fields:

Emp_id

Emp_name

Contact no.

Gender

Salary

Emp_grade

Designation

Address

Execute the following queries on the

table created:

1. Display the details of the

employees

2. Display the employee id of

employee whose name is
supriya.

3. Display the name of the

employee whose contact no. is
98454863011.

4. Display the details of the

employee whose address is D-
29, IITM, JANAKPURI.

5. Display the name of the

 employees whose salary is
greater than 10,000.

6. Update the employee details,

set EMP_GRADE equal to C
whose salary is less than
10000.

7. Delete the record of the

employee whose gender is
male and designation is
manager

8. Display the name, designation,

and salary of all the employees
whose names begins with A.

9. Update the employee details;

set designation to assistant
manger where designation is
trainee.

10. Display the employee id,

name, salary and designation
for the employees where
emp_grade is A.

22 Create a table Employee with the 10/10/23

following fields:

1. Emp_ID

2. Emp_name

3. Dept_name

4. Salary

5. Address

6. Date of joining
 Perform the following queries:

1. Delete the records of the table

whose Emp_ID=101

2. Delete the records of the

employees whose Dept_name is
HR and salary>10000

3. Delete the records of the

employees whose name begins
with S or salary>10000

4. Update the records of the

employees, set Dept_name= IT
where Dept_name Production

5. Update the records of the

employees, set salary-15000
whose Dept_name is IT.
23 Create a table student Marks with the 16/10/23
following fields

1. S_NO

2. Name

3. Marks
Enter 10 records in the table and
execute the following queries:

1. Display S No. of those students

whose name start with L and ends
with A and Marks <17.

2. Display the name and S.NO of

those students who have scored
marks-95.

3. Display the names and marks of

all the students who have scored
marks between 75 and 90
24 Write SQL Queries using Data 16/10/23
Manipulation Commands insert record
 into table named employee with fields

● EMP ID

● EMP NAME

● EMP DESIGNATION

● EMP AGE

● EMP DEPARTMENT

● EMP SALARY

1. EMP ID as the primary key.

2. Write a query to find the salary of

a person where age is 26 and
salary 25000 from Employee
Table.

3. Write a query to find the name of

Employee whose name is like
"Ku".

4. Customer details using “IN” and

“Between” operator where age can
be 25 or 27

25 Discuss all the DDL commands with 23/10/23

their syntax.

26 Discuss all the DML commands with 23/10/23

their syntax.

27 Write SQL queries using DDL

commands like CREATE, DROP and
ALTER and DML commands like
 INSERT and DELETE.

1. Create Table named Student with

following fields:

a. Student_ID

b. Name

c. Age

d. Course

e. Fees
2. Insert values in this table.

3. Delete the details of the students

where course is BBA.

4. Use ALTER command to add new

column.

5. Delete the whole table from the

Database.

28 Describe the context of forms in MS 23/10/23

Access.

29 Create two tables EMPLOYEE and 7/11/23

DEPARTMENT with the following
fields:

1. EMPLOYEE

 F_NAME

 L_NAME

 E_ID

 DOB

 ADDRESS

 SALARY
 2. DEPARTMENT

 D_NO

 D_NAME

 MGR_NO

 MGR-DOJ

Create the forms for the employee as

well as the dept table in tabular form
and write the steps to create the forms.
Also provide the suitable title to both
the forms and insert the page no’s to
it.

30 Create a table named 7/11/23

STUDENT_DETAILS with the
following fields:

• R no

• Name

• Course name

• Attendance

• Dob

• Address
 Course will have values either ISM or
FMI. Enter 5 records. Create a form
for the abovetable in design view. Add
text box and the following buttons to
it:

1. Go to first record

2. Go to last record

3. Go to previous record

4. Go to next record Add a label

student form to it.

31 Define all the aggregate functions with 14/11/23

their work defined in SQL.

32 Write SQL Queries using SQL 14/11/23

Commands Create a Table Product
with Fields

• PRO ID

• PRO NAME

• PRO PRICE

And make PRO_ID as the primary

key. Insert 10 Records into the Table.

4.Write a query to find the Name of

Product where PRO_PRICE>= 500
 from

PRODUCT Table.

5.Write a query to implement

Aggregate Functions on field PRICE".

Write a query to COUNT the number

of Records in the Product Table.

33 Create an ER diagram for a College 20/11/23

Management System.

34 Create an ER diagram for an Airline 20/11/23

Reservation System.

35 Create an ER diagram for an 21/11/23

Employee Management System.

36 Create an ER diagram for an e- 21/11/23

commerce website.