Scribd
Upload
17 views6 pages

Data Base Lab Task 1

The document outlines a lab task for creating a database named 'LMS' with four tables: student, faculty, fee, and result. It includes steps for inserting data into each table and viewing their contents. The task is submitted by Syed Zeeshan Ali Shah to Ma’am Syeda Nida Zainab.

Uploaded by

musman.official2001
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
17 views6 pages

Data Base Lab Task 1

The document outlines a lab task for creating a database named 'LMS' with four tables: student, faculty, fee, and result. It includes steps for inserting data into each table and viewing their contents. The task is submitted by Syed Zeeshan Ali Shah to Ma’am Syeda Nida Zainab.

Uploaded by

musman.official2001
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

1

Name: Syed Zeeshan Ali Shah

Roll No : 15445

Subject : Data Base

Lab task No 01

Submitted To :Ma’am Syeda Nida Zainab


2

Question:

 Create Database with 4 Tables.


 Insert data into Tables.
 View the Tables.

Solution:

1. Creating Database(LMS)
3

2. Creating 1st Table named (student), Inserting


values to student Table & viewing the content
of 1st Table.
4

3. Creating 2nd Table named (faculty), Inserting


values to faculty Table & viewing the content
of 2nd Table.

4. Creating 3rd Table named (Fee), Inserting


values to Fee Table & viewing the content of
3rd Table.
5

5. Creating 4th Table named (Result), Inserting


values to Result Table & viewing the content
of 4th Table.
6

You might also like