Computerscience2ndyear



?PART B?1.What is meant by term relationship between entities ? Explain the different types of relationships that can exist with examples ?2.Explain the concept of dependent entities ? give example.3.What do you mean by mapping cardinalities ? Explain various type of cardinalities.4.What is difference between total and partial participation ? Explain.5.What is the difference b/w single and multivalued attributes ? Explain.6. What do you mean by Null values? Explain with suitable examples.7.Discuss the various update operation on relation and types of integrity constraints that must be checked for each update operation ?8. What is relational algebra ? Discuss the various operations of relational algebra.9. Describe the different types of relational calculus in detail.10.What dis relational calculus ? Differentiate relational algebra and relational calculus.11.What do you understand by distributed databases? Give the various advantages and disadvantages of distributed database management system.12. Explain the architecture of Client-Server databases in detail.13. What are the main differences between a parallel and a distributed system ? Explain14. Explain nested Queries with examples15. Explain embedded SQL in detail16.Explain the integrity constraints supported by SQL17.Explain triggers with example.18.Explain security and authorization and Security in SQL19.Explain dynamic SQL in detail20. Explain distributed Database in detail21. Explain CSDB in detailPART B?1. Discuss concept of database language2. Discuss about database interfaces.3. What is relationship ? What are various types of relationship ? Explain with example.4. Explain the Codd’s Rule in detail.5. What do you mean by RDBMS ? What are its characteristics ?6. Explain Entity integrity and Referential integrity in detail.7. What is the difference between DBMS and RDBMS ? Which of them is more suitable?8. What is relational algebra ? Discuss the various operations of relational algebra.9. Describe the different types of relational calculus in detail.10.What dis relational calculus ? Differentiate relational algebra and relational calculus.11. What do you mean by Null values? Explain with suitable examples.12. Why normalization needed ? What are its disadvantages ?13..Discuss the various normal form in normalization with suitable examples.14. Define term anomalies.Explain BCNF in detail.15.What do you mean by BCNF ? Why it is used and how it differ from 3 NF ?16. Explain the different normal forms in detail17.Explain Functional dependency and Trivial functional dependency with examples.18.Explain Fourth normal forms with examples.19.Explain Closure of Set of Functional dependency and Closure of Attribute sets20.Explain Canonical cover and Extraneous Attributes with examples.21.Explain BCNF with examples and also state the difference between this from 3NF.22. Give the various advantages and disadvantages of the network model.how it differ from relational model ?pare BCNF and 3NFPART B?1. Why is concurrency control needed? Explain lost update, Inconsistent retrievals and uncommitted dependency anomalies.2. What is a deadlock ? How can a deadlock occur ? explain.3. Briefly explain one deadlock prevention algorithm.4. What if time stamping is used ? Explain briefly5. What is two-phase locking and how does it guarantee serializability ?6. Discuss the concurrency control mechanism in detail using suitable example.7. Differentiate between Two phase locking and Rigorous two-phase locking.8. How can deadlocks be avoided when using 2PL?9. How Share and exclusive locks differ ?Explain.10. How precedence graph can be used to detect deadlock ?11. What is a system log ? What is the purpose of the system log in system recovery12. Explain serializability13. Explain lock based protocols14. Explain two phase locking in detail.15. Explain log based recovery in detail16.Explain ACID properties17.Discuss about recoveryPART B1. Explain RAID levels in detail2. Explain file organization in details.3. Explain indexing and hashing4. Explain B+ tree index in detail5. Explain Query processing in detail.6. Explain Ordered indices in detail.7. Explain Static hashing.8. Explain Dynamic hashing.9. Explain organization of records in files.10. Explain JOIN, SELECTION and SORTING11.Explain Tertiary storage.12.Explain the cost estimation13.What is Query optimization ?What are different techniques used in it.14.Discuss in detail the physical storage media15.Explain the magnetic disks16.Discuss Database tuning?PART B?1.? What are various components of Database System ? Explain in detail.2.? What do you mean by data models ? Explain network, hierarchical and relational model in detail.3.? Explain various levels of Data abstraction in database system ?4.? What do you mean by database ? What is the purpose of a database system ? Explain.5.? What do you mean by DBMS ? Explain its functioning.6.? Explain architecture of DBMS and its advantages ? state two main disadvantages of DBMS ?7.? What is DBA ? What are major responsibilities of DBA and database designers ?8.? What are problems with traditional file processing system ? How they are removed in database system ? Explain9.? What do you mean by Entity-Relationship Diagram ? Explain10.Explain the various terms of an E-R model and how are they represented in an E-R model11.Describe the three-level architecture of DBMS ? Also explain its importance in a database environment.12. Discuss concept of database language and interfaces13. Explain the architecture of DBMS with a neat block diagram14. Explain ER model in detail15. Explain the design issues of ER-model16. Explain the various relational algebra operations17. Draw an ER diagram for a banking enterpr ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download