Webocreation

Sunday, December 13, 2009

Question collection of database part 1

  1. Is there any difference between Database and Database Management System? Explain.
  2. Explain Network Model and Hierarchical Model with diagram.
  3. Design a ER Diagram for Hospital Management System.
  4. Write short notes on (Any TWO)
    1. Primary Key
    2. Mapping Constraints
    3. Instances and Schema
  5. Write down SQL statements for following (Any THREE)
    1. Display all employee whose name is starting from letter ‘R’ and ending with letter ‘H’.
    2. Display all employees no, name, annual salary of department 20.
    3. Display all employees whose salary is greater than their commission.
    4. Display all employees working under department no 10,20,30.
6. Who is Database Administrator (DBA)? Explain their task and dutie

No comments:

Post a Comment