Fifth Assignment Spring 2011 CS403 5
Posted on Monday, 04 July 2011
in Spring 2011
Q 1: Write SQL statements/queries for each of individual scenario given below from the given tables on the next page
Read 704 times
Spring 2011 CS403 3
Posted on Friday, 03 June 2011
in Spring 2011
Q1: Find E-R Diagram of ABC Hospital, below.
You are required to translate diagram and write relations (tables) on behalf of E-R diagram provided. 3 Marks
Read 735 times
Spring 2011 CS403 Database Management Systems 2
Posted on Wednesday, 20 April 2011
in Spring 2011
Q Draw an E-R diagram for each of the following situations:
- A University has many departments whereas each department belongs to that particular university. That university has also many buildings whereas each building belongs to that particular university. The University also has many employees whereas each employee belongs to that particular university. Every employee has only one parking space whereas each parking space belongs to only one employee. Department offers many study programs whereas each programs offered by only a single department. 7.5 Marks
Read 644 times
Spring 2011 CS403 1
Posted on Wednesday, 13 April 2011
in Spring 2011
Q 1. State the significance of DFDs in the process of Database designing. (5)
Read 595 times