Skip to main content

Posts

Showing posts from April 12, 2014

206 DBMSC ASSI

 What is logical view of data?  Explain what are relation and their characteristics in detail? What are keys? How it is useful to Controlled redundancy? Explain integrity rules Explain relation set operators Explain joins in detail What is data dictionary and System Catalog? Explain relationship with relational database What are indexes? Explain the following Single Valued Attribute Multi Valued Attribute Simple Attribute Composite Attribute Derived Attribute What is connectivity and cardinality? What is Existence Dependency? Explain Weak Entity, ID-Dependent Entity What is Composite Entities? What two condition must be met before an entity can be classified as a weak entity? Give an example of a weak entity. What is a strong relationship? And how it is depicted in a crow’s foot ERD? What is recursive relationship? Give an example What is composite Entity? Discuss two ways in which the 1:M relationship between course and class can be implemented. How would y