Q1. What are the difference between a file processing system and DBMS?
Q2. What do you mean by Data Abstraction?Explain Diffenrence Between Physical,Conceptual and View Level?
Or
What do you mean by Internal Schema ,Conceptual Schema and External Schema?
Q3. What is Data Independence ?Difference between the Logical and Physical Data Independence?
Q4. What are the difference between DDL and DML?
Q5. What do you mean by entity and relationship in E-R Model ? Explain how a relationship set is defined.
Q8. What is difference between specialization and generalization with respect to database?
Q9. Difference between weak entity and strong entity.
Q10. Define-
a)Database System
b)End User
c)Data Redundancy and consistency
d)Data Models
e)Aggregation
Q11. Difference between procedural and non-procedural DMLs.
Q12. Draw overall structure of DBMS and Explain its various component.
Q13. Explain 2-Tier and 3-Tier architecture of DBMS.
Q14. Explain Different types of attributes of an Entity with example.
Q15. Draw E-R Diagram showing cardinality.
A operator can work on many machines and each machine has many operators.Each machine belongs to one department but a department a can have many machines.
Q16. Explain Cardinality Ratio and Participation Constraints with Example.
Q17. What are different types of Databases?
Q2. What do you mean by Data Abstraction?Explain Diffenrence Between Physical,Conceptual and View Level?
Or
What do you mean by Internal Schema ,Conceptual Schema and External Schema?
Q3. What is Data Independence ?Difference between the Logical and Physical Data Independence?
Q4. What are the difference between DDL and DML?
Q5. What do you mean by entity and relationship in E-R Model ? Explain how a relationship set is defined.
Q6. Design an E-R Diagram for Airline Reservation System-
It must consist of flights ,aircrafts,airports,fairs,reservation,tickets,pilots,crew and passenger.Clearly highlight the entities,relationship ,primary keys.Transform this E-R diagram to Relational Database Schema.Clearly mention the generalization ,aggregation and weak entity.
Q7. Explain the distinction among the terms-primary key,candidate key and super key.Q8. What is difference between specialization and generalization with respect to database?
Q9. Difference between weak entity and strong entity.
Q10. Define-
a)Database System
b)End User
c)Data Redundancy and consistency
d)Data Models
e)Aggregation
Q11. Difference between procedural and non-procedural DMLs.
Q12. Draw overall structure of DBMS and Explain its various component.
Q13. Explain 2-Tier and 3-Tier architecture of DBMS.
Q14. Explain Different types of attributes of an Entity with example.
Q15. Draw E-R Diagram showing cardinality.
A operator can work on many machines and each machine has many operators.Each machine belongs to one department but a department a can have many machines.
Q16. Explain Cardinality Ratio and Participation Constraints with Example.
Q17. What are different types of Databases?
No comments:
Post a Comment