Question 1

Draw a Data Flow Diagram for a University scenario

Question 2

Discuss the following with suitable examples

• Relational Algebra Operators
• Database Planning

Question 3

Discuss the following

• Client / Server Architecture
• Database Architecture

Question 4

Explain the process of creating databases in SQL Server 2005 with suitable examples

Question 5

Write a query to create a table called "Persons" that contains five columns: P_Id, LastName, FirstName, Address, and City

Question 6

Given the following table STOCK. Write a query to find the rows in table STOCK

Table

STOCK
---------+-------------------------+--------------------+
| RIC | COMPANY | LISTED_ON_EXCHANGE |
+---------+-------------------------+--------------------+
| 6758.T | Sony | T |
| GOOG.O | Google Inc | O |
| GS.N | Goldman Sachs Group Inc | N |
| INFY.BO | InfoSys | BO |
| VOD.L | Vodafone Group PLC | L |
+---------+-------------------------+--------------------+
Query with correct logic