difference between

Document Sample
difference between Powered By Docstoc
					Difference between
    1) primary,secondry,super key
    2) File processing and DBMS
    3) Instances and schema
    4) Mapping cardinalities and weak entity sets
    5) Aggregation and specialization

 Explain Transaction management

 What is server side script, CGI, JDBC, ODBC, DBA, Internet database?

 Define types of normalization?
 Explain triggers, active database and joins?

 List the usefulness of acid properties?

 What is relation and relation schema? Discuss the various update operations on
 relations?

 E-R model to represent database?

 Q) Consider the following schema
    Employee (fname, iname, ssn, bdate, address, sex, salary, dnum)
    Department (dname, dnum, ssn, startdate)
    Project (pname, pnum, plocation, dnum)
    Works_on (ssn, pnum, hours)
    The key field are underlined
 Write the following queries in relational algebra

 a) Find all employees whose department is 4 or salary > $3000
 b) Find the ssn of all employees who work either in department 5 or directly supervise
   an employee who works in department on all projects
 c) Find the name of the manager of each department


 Q) Queries in sql
 Queries of group by, order by functions can come?
 One question of writing query is going to come?