IGNOU MBA First Semester Solved Assignments for Session 2017-2018 is now Available here at Free of Cost. 1 – Management Functions and Behaviour ( MS-01 ) Download IGNOU MS-01 Solved Assignment 2 – Management of Human Resources ( MS-02 ) Read More …
Category: Assignments
Explain the various computer security classification recognised by trusted computer system Evaluation criteria (TCSEC)
Trusted computer system evaluation criteria is a united states government Department of Defense standard that sets basic requirement for assessing the effectiveness of computer security controls built into a computer system. The TCSEC was used to evalute, classify and select Read More …
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 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
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
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
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
