Scribd
Upload
3 views41 pages

Dbms Lab Assg

The document outlines the creation and management of various database tables including Student, Employee, Customer, Orders, Product, and Sales. It details operations such as inserting, modifying, and querying data using SQL commands and joins, as well as performing aggregations and validations. Additionally, it emphasizes the importance of foreign keys and data integrity across related tables.

Uploaded by

joshiravi96123
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 views41 pages

Dbms Lab Assg

The document outlines the creation and management of various database tables including Student, Employee, Customer, Orders, Product, and Sales. It details operations such as inserting, modifying, and querying data using SQL commands and joins, as well as performing aggregations and validations. Additionally, it emphasizes the importance of foreign keys and data integrity across related tables.

Uploaded by

joshiravi96123
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

ER Diagram representation of Database

 Creating, Modifying, and Altering the


Student Table
 Creating the employee table,
inserting records, updating employee
details, deleting invalid entries, and
displaying the final table.
 Inserting and Validating Data in the
student Table
 Creating and Modifying the employee
and department Tables with Foreign Key
and Data Insertion
 Creating the customer Table, Inserting Data,
and Executing Various Queries Including
SELECT, COUNT, GROUP BY, ORDER BY, and
Aggregate Functions
 Creating the orders Table, Inserting Data,
and Executing Queries with JOIN,
WHERE, BETWEEN, and Aggregate
Functions
 Creating and Inserting Data into the
Product, Sales, and Office Tables
• Creating and Inserting Data into Product, Sales,
Office, and Salesperson Tables; Grouping and
Summarizing by Salesperson; Joining Tables to
Extract Salesperson Details.
 Creating and Inserting Data into the
SALESPERSON, CUSTOMER Tables and
Updating Sales Data
 Create SALESPERSON and CUSTOMER
tables, Insert data into SALESPERSON
and CUSTOMER
 Develop and implement tables for
Department, Employee, Product, and
Sales. Populate the Department,
Employee, and Product tables with
relevant data.
 Create Employee and Department Table,
Insert Data into Employee and Department ,
Modify Employee Table, Select Data from
Employs and Department, Perform
Aggregation on Customer Data.
 Create Orders Table, Insert Data into
Orders, Modify Orders Table, Select Data
from Orders and Customers, Perform
Aggregation on Customer Data.
 Performing Insert, Commit, Select, and
Join

Operations on Customers
and Related Tables
 Using Joins to Retrieve Data and Filtering
Rows Based on a Range in Orders
 Fi
ltering Salesperson Data by
Commission and City Mismatch
with Join Queries

 Querying Orders with Customer and


Salesperson Details Using Joins
 Querying Customer and Salesperson
Details with City Matching and
Ordering by Customer ID
 Querying Customer and Order Details
with Sorting by Order Date
 Querying Customer Details for
Purchases Greater than 2000
 Querying Customer Names for Specific
Date Range and Purchase Amount
 Queries on Employee Data

You might also like