Adbms lab

May 7, 2013Download as DOCX, PDF0 likes325 views

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.

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.

Maen Maroonkandah is a Jordanian male born in 1988 who completed high school in Jordan and university in Amman, earning a B.Sc. in Administration and Financial Sciences/Marketing. He has experience in sales, marketing, customer service and protecting company information. His skills include using SPSS, Microsoft Office programs, social media, and networking. He has received training in emotional intelligence and customer relationship management.

Pen sartA1289k

��

This document describes the 5 Pen PC technology system called P-ISM. P-ISM consists of 5 pen-like devices that work together: a CPU pen, communication pen, projector pen, keyboard pen, and camera pen. The CPU pen functions as the computing engine and uses Windows OS. The pens are connected wirelessly and to the internet through Bluetooth and cellular connectivity in the communication pen. The projector pen projects a 1024x768 display. The keyboard pen projects a virtual laser keyboard. The camera pen functions as a webcam. The system provides portable, ubiquitous computing but has limitations around storage capacity and battery life.

Redacción de textosFrancy Dayana PZx

��

Carlos mejiacarlosdanielm

��

CV1410201_3Mark Dlugosz

��

Mark Dlugosz has over 15 years of experience in business analysis, risk analysis, financial analysis, project management, and data analytics. He has worked for several large financial institutions including Depfa Bank, Ulster Bank, and Bank PKO BP S.A. in roles analyzing credit risk, calculating risk-weighted assets, managing projects, and reporting key metrics to management. He has strong skills in Excel, SQL, databases, and business intelligence tools.

Sportsbhuvaneshwari kumar

��

Sachin Tendulkar is one of the most famous batsmen in cricket. He made his debut in 1989. Since he has made his mark within the game in a number of ways. He currently holds the record for the highest number of centuries in one-day international games. He is also the second highest test scorer. In 2002, he was rated second greatest test-cricketer and best ODI batsman of all time. He has achieved iconic status in his native India and has earned millions of pounds through endorsements and advertising schemes. He is a master blaster in cricket and achieved many awards for our Indian team. He is a role model for all the youngsters.

Доноры и конкурсы международной технической помощи, автор Денис Ткачов и Ната...UKRAINKY.BIZ

��

ElpueblodeceutaElena P.R.

��

El presidente de la Unión de Comunidades Islámicas hizo declaraciones cuestionando la lucha contra la violencia de género. La Asociación de Mujeres Progresistas condena estas declaraciones y afirma que la única solución es denunciar al agresor y que la violencia de género no se resuelve en la familia sino con apoyo y denuncia para proteger a la víctima. La asociación apoya a los equipos que ayudan a las víctimas y presentará una denuncia ante la fiscalía por estas declaraciones que

How To Jumpstart Your Career In Japan Or Anywhere ElseJames Santagata

��

V4 graphic photos parm four 4 pillars presentation business developmentBenoit Grenier

��

Proactive Risk Management Inc. (PARM) is a leading risk management and security services provider founded in 2006. PARM takes an integrated approach to risk management based on four pillars: business intelligence, incident management, loss prevention and security services, and technology/tradecraft innovations. PARM's 80-20 mindset focuses on the 20% of risks that cause 80% of damages to efficiently protect clients.

ShowPrescriptionPDFArnon Gitelman ????? ??????

��

Center research publications. III Summer science reading August 17, 2015Center_research_publications

��

2012 エデルマン・トラストバロメーターEdelman Japan

��

What needs to be done before getting started in social mediaEdelman Japan

��

The document provides guidance on preparing for social media by establishing the necessary foundations. It recommends: 1. Training employees on social media best practices through a certification program tailored for different audiences. 2. Understanding the target audience by analyzing conversations, behaviors, and demographics to inform engagement strategies. 3. Developing rules of engagement that establish social media policies, decision trees for moderating content, and crisis response processes tailored for each market. 4. Transforming into a social business by defining it as bridging external and internal connections, and implementing supporting people, processes, and platforms across the entire organization to drive deeper engagement and innovation.

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.

�ݺ�ߣ

Adbms lab

Recommended

More Related Content

Viewers also liked (6)

Adbms lab