Download Solution Ignou MCA Solved Question Paper
Tag: solved
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
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
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
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.
Download Solution Ignou MCA Solved Question Paper
Create appropriate tables and relationship among them for the E-R design
Download Solution Ignou MCA Solved Question Paper
Create appropriate tables and relationship among them for the E-R design
Download Solution Ignou MCA Solved Question Paper
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.
Download Solution Ignou MCA Solved Question Paper
Why is that packet switching is said to employ statistical multiplexing ? Contrast statistical multiplexing with the multiplexing that take place in TDM.
Download Solution Ignou MCA Solved Question Paper
Suppose you are developing a standard for a new type of a network. You need to decide whether your network will use Virtual Circuits (VCs) or datagram routing. What are the Pros & Cons for using VCs ?
Download Solution Ignou MCA Solved Question Paper
