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