Q.1 What is DBMS? Explain 3 level architecture of DBMS. Explain how it leads to Data Independence? ANSWER:
Q2) Role and Functions of Database Administrator ANSWER:
Q3) Discuss different database users. ANSWER:
Q.4) Define Distributed Database. Differentiate between centralized and distributed database with advantages and dis-advantages of each. ANSWER:
Q5) Elaborate different physical storage media used in DBMS. ANSWER:
Q.3 Explain various symbols used in construction of Entity Relationship Diagram.
Draw an ERD for Library Management System.
ANSWER:
Q1 ERD
Q4) What are attributes of an entity? Explain its types. ANSWER:
Q5) Construct an E-R diagram for a car insurance company whose customers own one ANSWER:
Q.6 Consider a Hospital Management System in which hospital has (IPD) and (OPD). The system maintains Patient Records and billing of patients. It also maintains information of various wards like ICU, General, Semi Private and Deluxe. Draw an Entity Relationship Diagram. ANSWER:
Q7) Types of Attributes ANSWER:
Q.8 What is relational database model? Explain various mapping cardinalities ratios with relevant example in detail. ANSWER:
UNIT 3:
Q9) What do you understand by normalization? Discuss data normalization process, ANSWER:
Q10) Benefit of Normalization ANSWER:
Q11) CODD’S RULES
Q.11) Explain the following terms with example. a) Foreign Key b) DDL statement c) Group by clause ANSWER:
Q12) Explain SQL , DDL, DQL, DML. ANSWER:
Q.13) What is Concurrency Control? Explain its need in database environment. ANSWER:
Q15) What do you understand by lossy and lossless decomposition? ANSWER:
Q17) Explain the shadow paging technique with example. ANSWER:
Q.18) Write short notes a) Data abstraction b) Strong entity c) Responsibilities of DBA e) Deadlock ANSWER:
Q19) Discuss the ACID properties of a transaction. Give relevant example, ANSWER:
Q20) What is two phase locking? How does it work? ANSWER:
Q.21) What is deadlock? Explain how deadlock can be handled using timestamp method in detail. ANSWER:
Q22) Shadow paging ANSWER: