Why are duplicate tuples not allowed in a relation?
Discuss the different types of update operations in relation to the integrity constraints which must be satisfied in a relational database model.
distinguish between harware and software?
What do you understand by union compatibility of relations? For which operations such compatibility is required and why?
How are computers useful in processing the accounting data?
What integrity constraints are specified on database schema? Why each is considered important?
What is meant by NULL value? What are the reasons that lead to their occurrence in database relations?
What do you understand by the concept of weak entity used in data modelling? Explain the relevance of owner entity type, partial key and identifying relationship in the context of such modelling.
Discuss the basic concepts of Entity Relationship (ER) Model. Illustrate as to how an ER model is diagrammed.
What is a participation role? State the circumstances under which the use of role names becomes necessary in description of relationship types.
Define foreign key. How is this concept useful in relational data model? Illustrate with suitable example.
What do you understand by database? How does it differ from DBMS?
State main categories of data models.
Discuss the steps you would take to transform an ER Model into various relations of Relational Data Model. Give suitable examples.
Why are duplicate tuples not allowed in a relation?
Discuss the different types of update operations in relation to the integrity constraints which must be satisfied in a relational database model.
distinguish between harware and software?
What do you understand by union compatibility of relations? For which operations such compatibility is required and why?
How are computers useful in processing the accounting data?
What integrity constraints are specified on database schema? Why each is considered important?
What is meant by NULL value? What are the reasons that lead to their occurrence in database relations?
What do you understand by the concept of weak entity used in data modelling? Explain the relevance of owner entity type, partial key and identifying relationship in the context of such modelling.
Discuss the basic concepts of Entity Relationship (ER) Model. Illustrate as to how an ER model is diagrammed.
What is a participation role? State the circumstances under which the use of role names becomes necessary in description of relationship types.
''Secondary data are those which are already in existence, and which have been collected, for some other purpose than the answering of the question in hand." Substantiate this statement focusing on the difference between primary and secondary data.
Define foreign key. How is this concept useful in relational data model? Illustrate with suitable example.
What do you understand by database? How does it differ from DBMS?
State main categories of data models.
Discuss the steps you would take to transform an ER Model into various relations of Relational Data Model. Give suitable examples.