Unit 1: Introduction to Database Management System
- Q1). What is database management system? Write capabilities of database management system.
- Q2). Write the advantage and disadvantage of DBMS.
- Q3). Write the major components of DBMS.
- Q4). What do you mean by File System? Explain
- Q5). Write the difference between database system and file system.
- Q6). Discuss the problem caused by data redundancies. Can data redundancies be completely eliminated when the database approach is used?
- Q7). Write brief notes on instance and schema.
- Q8). How does a category differ from a regular shared subclass?
- Q9). What is model in DBMS? write different type of models and also explain each.
- Q10). Describe the three level architecture of database system.
- Q11). What do you mean by logical and physical schemas?
- Q12). What is data independence? Write difference between logical data independence and physical data independence.
- Q13). What is database language? Explain DML and DDL.
- Q14). Write the difference between procedural and non-procedural DMLs.
- Q15). Discuss the role of DBA in database management system.
- Q16). Define the terms Data abstraction and Data redundancy.
- Q17). Write the functions of DBA.
- Q18). Explain ER-Model in detail.
- Q19). Design an E-R diagram for banking enterprise.
- Q20). Explain mapping constraints.Write its types
- Q21). Explain mapping constraints.Write its typesWhat do you mean by a key to the relation ? Explain the differences between super key, candidate key and primary key.
- Q22). What is foreign key? What is its purpose.
- Q23). Define Generalization , Specialization and Aggregation with a suitable example.
- Q24). What do you mean by entity set? What is weak entity and strong entity . Also write the difference between weak and strong entity.