Download Solution Ignou MCA Solved Question Paper
Tag: Assignments
Define a simple hash-join and explain the process and cost calculations of hash-join with the help of an example.
Download Solution Ignou MCA Solved Question Paper
Define a simple hash-join and explain the process and cost calculations of hash-join with the help of an example.
Download Solution Ignou MCA Solved Question Paper
Explain MVD (Multi Valued Dependencies) and join dependency with the help of an example of your choice.
Download Solution Ignou MCA Solved Question Paper
Define the concepts of specialization and generalization. Give one example(generalization – specialization hierarchy) of where these concepts are useful in the above E- R diagram
Download Solution Ignou MCA Solved Question Paper
Differentiate between a weak entity and a strong entity set. Identify these entity sets in the above diagram. How will you convert a weak entity set to a strong entity set?
Download Solution Ignou MCA Solved Question Paper
Using the coaching institute example above, write relational – algebra expressions to find out the following queries: Find out students who have secured more than 70 percent in physics and chemistry. Find out part time faculties who teaches two subjects
Download Solution Ignou MCA Solved Question Paper
Create an object oriented database for the following UML class diagram. Make assumption about your attributes and facts.
Download Solution Ignou MCA Solved Question Paper
Create an object oriented database for the following UML class diagram. Make assumption about your attributes and facts.
Download Solution Ignou MCA Solved Question Paper
Using the coaching institute example above, write relational – algebra expressions to find out the following queries: Find out students who have secured more than 70 percent in physics and chemistry. Find out part time faculties who teaches two subjects
Download Solution Ignou MCA Solved Question Paper
