Scribd
Upload
6 views8 pages

DB 1 Lab

The document outlines Lab #01 for Database Systems, where the task involves creating a database named SchoolRecords. It includes the creation of three tables: Teachers, Students, and Courses, each with specified attributes, and the insertion of 10 rows of data into each table. Additionally, it mentions displaying all data and selected columns from these tables.

Uploaded by

playstore9.ha
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
6 views8 pages

DB 1 Lab

The document outlines Lab #01 for Database Systems, where the task involves creating a database named SchoolRecords. It includes the creation of three tables: Teachers, Students, and Courses, each with specified attributes, and the insertion of 10 rows of data into each table. Additionally, it mentions displaying all data and selected columns from these tables.

Uploaded by

playstore9.ha
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

Lab # 01

Database Systems

Submitted By: Haider Ali


Submitted To: Ms. Maria Gul/ Mr. Amir Hamza
Registration No: B23F0001AI054
Instructor Name: Ms. Maria Gul Department: AI- Blue
Student Name: Ibadullah Qureshi Lab No: 02
Lab Engineer: Ms. Amir Hamza Registration No: B23F0001AI072

Task:

- Creating database named SchoolRecords

- We would use the database to create tables and perform other functions.

- Afterwards creating table named Teachers with following attributes:


1. TeacherID
2. FirstName
3. LastName
4. Subject
5. Experience

- Creating table named Students with following attributes:


1. StudentID
2. FirstName
Page |2
Instructor Name: Ms. Maria Gul Department: AI- Blue
Student Name: Ibadullah Qureshi Lab No: 02
Lab Engineer: Ms. Amir Hamza Registration No: B23F0001AI072
3. LastName
4. Class

- Creating table named Courses with following attributes:


1. CourseID
2. CourseName
3. Credits

Inserting 10 rows of data in each table (Teachers, Students and Courses)

Page |3
Instructor Name: Ms. Maria Gul Department: AI- Blue
Student Name: Ibadullah Qureshi Lab No: 02
Lab Engineer: Ms. Amir Hamza Registration No: B23F0001AI072

Teachers:

Students:

Page |4
Instructor Name: Ms. Maria Gul Department: AI- Blue
Student Name: Ibadullah Qureshi Lab No: 02
Lab Engineer: Ms. Amir Hamza Registration No: B23F0001AI072

Courses:

- Displaying all the data of the tables and then selected columns of the table

Page |5
Instructor Name: Ms. Maria Gul Department: AI- Blue
Student Name: Ibadullah Qureshi Lab No: 02
Lab Engineer: Ms. Amir Hamza Registration No: B23F0001AI072

Outputs of the Tables:

Teachers Table:

Teachers table with first name and subjects:

Students Table:

Page |6
Instructor Name: Ms. Maria Gul Department: AI- Blue
Student Name: Ibadullah Qureshi Lab No: 02
Lab Engineer: Ms. Amir Hamza Registration No: B23F0001AI072

Students Table with First name and class:

Course Table:

Page |7
Instructor Name: Ms. Maria Gul Department: AI- Blue
Student Name: Ibadullah Qureshi Lab No: 02
Lab Engineer: Ms. Amir Hamza Registration No: B23F0001AI072
Course Table with Course name and credits:

Page |8

You might also like