際際滷

際際滷Share a Scribd company logo

Adbms lab

Download as DOCX, PDF
Kushal Gupta
Kushal Gupta

The document provides instructions to create three database tables - Product, Account, and Medicine - with various fields. It then asks to insert at least 8 records into each table and answer SQL queries on each one. For the Product table, it asks to list products by weight and price, find price of a specific product, and find company name and price by product ID. For the Account table, it asks to list account holders by type, accounts by type and balance, and balances by date. For the Medicine table, it asks to list by expiry date, find by component and strength, and find by strength and price.

1 of 2
Download to read offline
ADBMS Lab 1. Create the following table and perform the necessary task defined below : (a) Create the following table named 'Product' : Product Name Product ID Price Date_of_Manuf Company Weight (b) Enter at least 8 records in the above table and answer the following queries using SQL: (i) List all the products of weight 2 kg and whose price is Rs. 100 or less ? (ii) Find the price of "GHEE" produced by company "ABCD" of weight 1 kg. (iii) Find the name of company and price of the product ID =100. 2. Create the following table and perform the necessary task defined below : (a) Create the following table named 'Account' : - Account No - Account_Type - Balance - Name_of_Account_Holder - Date_of_Account Open (b) Enter at least 8 records in the above table and answer the following queries using SQL (i) List all the Name_of_Account_Holders whose account is of saving type ? (ii) List all the Account_No who are of Fixed Deposit type and balance is more than Rs. 10,000 ? (iii) List Balance of all the account who are opened after 02-02-2011 ? 3. Create the following table and perform the necessary task defined below : (a) Create the following table named : Medicine Name Company_Name Components Date_of.Mnf. Date_of_Exp MRP Strength
(b) Enter at least 8 records in the above table and answer the following queries using SQL: (i) List all the medicines whose expiry is on 01/07/2011. (ii) List name of medicines whose component is "Paracetamol" and strength is 500 mg. (iii) Find name of all the medicine whose strength is more than 125 mg and MRP is more than Rs. 20.

More Related Content

Adbms lab

  • 1. ADBMS Lab 1. Create the following table and perform the necessary task defined below : (a) Create the following table named 'Product' : Product Name Product ID Price Date_of_Manuf Company Weight (b) Enter at least 8 records in the above table and answer the following queries using SQL: (i) List all the products of weight 2 kg and whose price is Rs. 100 or less ? (ii) Find the price of "GHEE" produced by company "ABCD" of weight 1 kg. (iii) Find the name of company and price of the product ID =100. 2. Create the following table and perform the necessary task defined below : (a) Create the following table named 'Account' : - Account No - Account_Type - Balance - Name_of_Account_Holder - Date_of_Account Open (b) Enter at least 8 records in the above table and answer the following queries using SQL (i) List all the Name_of_Account_Holders whose account is of saving type ? (ii) List all the Account_No who are of Fixed Deposit type and balance is more than Rs. 10,000 ? (iii) List Balance of all the account who are opened after 02-02-2011 ? 3. Create the following table and perform the necessary task defined below : (a) Create the following table named : Medicine Name Company_Name Components Date_of.Mnf. Date_of_Exp MRP Strength
  • 2. (b) Enter at least 8 records in the above table and answer the following queries using SQL: (i) List all the medicines whose expiry is on 01/07/2011. (ii) List name of medicines whose component is "Paracetamol" and strength is 500 mg. (iii) Find name of all the medicine whose strength is more than 125 mg and MRP is more than Rs. 20.