CS403 Fall 2011 4th Assignment
Posted on Saturday, 07 January 2012
in Fall 2011
Write SQL Commands to Create the following tables along with attributes and Primary/Foreign key constraints. Use the appropriate Data Types for each attribute.
Customer (CID, CName, Address, Phone)
Order (Order-ID, Description, CID)
Read 148 times
CS403 Fall 2011 First Assignment
Posted on Tuesday, 08 November 2011
in Fall 2011
Q # 1: Draw a Context Level DFD for “Online Banking System” of ABC Bank. (10 marks) Scenario is given below: Account Holder and IT Manager interact with the system: Account Holder perform following activities:
- He can check his balance.
Read 233 times
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