ISISMARC 1.542 is no more available for download at UNESCO website at the URL http://www.unesco.org/ webworld/download/isis/ isismarc/setup1542.zip. However, the snapshot of the above is available at URL using Wayback Machine Click here to download.
Personal Experience
Sunday, August 26, 2018
Thursday, August 02, 2018
The following link contains the raw data of a hypothetical library. You can use it for Pivot Table exercise in Excel.
https://drive.google.com/file/d/1F8HndGUdVqxycLxhwl-wTNfP_kQ6MDx_/view?usp=sharing
https://drive.google.com/file/d/1F8HndGUdVqxycLxhwl-wTNfP_kQ6MDx_/view?usp=sharing
Monday, December 16, 2013
Google Scholar Library - Google Scholar Blog
I found out this by serendipity. May be useful for many. Google Scholar Library - Google Scholar Blog
Thursday, May 02, 2013
Seminar
Topics for MPhil
Names of Students
|
Exercise
|
Reference Book
|
1) Abilash
2) Boraiah
|
Design a relational database corresponding to the E-R diagram of Figure 3.38. Add a few records of your own.
|
Dababase System Concept.
A. Silberschatz, H.F. Korth and S. Sudarshan
|
3)
Girish
4)
Harisha
|
Consider the
relational database of Figure 3.39, where the primary keys are un- derlined.
Give an expression in the relational algebra to express each of the following
queries:
a. Find the names of all employees who
work for First Bank Corporation.
b. Find the names and cities of
residence of all employees who work for First Bank Corporation.
c. Find the names, street address, and
cities of residence of all employees who work for First Bank Corporation and
earn more than $10,000 per annum.
d. Find the names of all employees in
this database who live in the same city as the company for which they work.
e. Find the names of all employees who
live in the same city and on the same street as do their managers.
f. Find the names of all employees in
this database who do not work for First Bank Corporation.
g. Find the names of all employees who
earn more than every employee of Small Bank Corporation.
h. Assume the companies may be located
in several cities. Find all companies located in every city in which Small
Bank Corporation is located.
|
Dababase System Concept.
A.
Silberschatz, H.F. Korth and S. Sudarshan
|
5)
Hasan
6)
Hemavathi
|
Consider
the following employee database schema (Figure 4.13), where the primary keys
are underlined.
Give
an expression in SQL for each of the following queries.
a.
Find the names and cities of residence of all employees who work for First
Bank Corporation.
b.
Find the names, street address, and cities of residence of all employees who
work for First Bank Corporation and earn more than $10,000.
c.
Find all employees in the database who do not work for First Bank
Corporation.
d.
Find all employees in the database who earn more than each employee of Small
Bank Corporation.
e.
Assume that the companies may be located in several cities. Find all
companies located in every city in which Small Bank Corporation is located.
f.
Find the company that has the most employees.
g. Find those companies whose
employees earn a higher salary, on average, than the average salary at First
Bank Corporation.
|
Dababase System Concept.
A. Silberschatz, H.F. Korth and S.
Sudarshan
|
7) Mahadeva S.
8)
Mutturaj
|
Develop the E-R diagram for an
online bookstore. Books are identified by ISBN codes, written by authors and
sold at a given price. Books are published by publishers. The online bookstore
has several warehouses with a given stock-level for each title, whereas each
book may be present (at different quantities) in different warehouses.
Customers create accounts (assume that user_id is their email) and in each
session they make a shopping basket.
|
|
9)
Rajesh H.T.
10) Shivaraju M.
|
Exercise No. 4.3 (4th
edition, page 144).
|
Dababase System Concept.
A. Silberschatz, H.F. Korth and S. Sudarshan
|
11)
Sowmya
12)
Sunitha
|
Exercise No. 4.1 (4th
edition, page 143).
|
Dababase System Concept.
A. Silberschatz, H.F. Korth and S. Sudarshan
|
13) Vasantha
14)
Yogesh Kumar
|
Exercise No. 3.8 (4th
edition, page 129).
|
Dababase System Concept.
A. Silberschatz, H.F. Korth and S. Sudarshan
|
Subscribe to:
Posts (Atom)