Explain MVD (Multi Valued Dependencies) and join dependency with the help of an example of your choice. 5:44 AMDownload Solution Ignou MCA Solved Question PaperRead More
Define a simple hash-join and explain the process and cost calculations of hash-join with the help of an example. 5:44 AMDownload Solution Ignou MCA Solved Question PaperRead More
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 5:43 AMDownload Solution Ignou MCA Solved Question PaperRead More
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? 5:43 AMDownload Solution Ignou MCA Solved Question PaperRead More
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 5:43 AMDownload Solution Ignou MCA Solved Question PaperRead More
Create an object oriented database for the following UML class diagram. Make assumption about your attributes and facts. 5:43 AMDownload Solution Ignou MCA Solved Question PaperRead More
Construct an E-R diagram for a coaching institute which prepares students for entrance to engineering programs. The institute conducts theory classes from Monday to Saturday from 9 am to 8 pm in Physics, Chemistry, Maths and English. The institute maintains records about faculty (visiting, full time) and supporting administrative staff, students, assignments, test result, class timings and payments made to staff. Students are admitted to the institute after they have successfully passed the test. The institute issues transcripts to students showing student’s performance in the class tests. The transcript contains student’ name, subject (physics, chemistry, math and English), assignment score and test score. Clearly indicate the entities, attributes, relationship between entities, keys and cardinalities. 5:42 AMDownload Solution Ignou MCA Solved Question PaperRead More