IGNOU MCA MCS-043 Advanced Database Management Systems SOLVED ASSIGNMENTS 2014-2015

IGNOU MCA MCS-043 SOLVED ASSIGNMENTS 2014-2015 Advanced Database Management Systems IV  FOURTH SEMESTER 

Ans: Comming soon. Now follow - How to write Best ASSIGNMENTS / ANSWERS by Yourself

Course Title : Advanced Database Management Systems    

MCS-043

This assignment has seven questions, which carries 80 marks. Answer all the questions. Rest 20 marks are for viva voce. You may use illustrations and diagrams to enhance explanations. Please go through the guidelines regarding assignments given in the Programme Guide for the format of presentation. Answer to each part of the question should be confined to about 300 words.

Q.1. Construct an E-R diagram and the corresponding relational database for a University/ College’s office. The office contains data about each class, including the instructor, the enrolment, the time and room number of the class. For each student the number of subjects and the class is recorded. Document all assumptions that you make about the mapping constraints.

Q.2. Consider the following relation scheme: students (S#,Sname) Courage ( C#, c name, Tname) Studies (S#, C#) Write the relational algebra queries and SQL queries for the following:

1) List students who are not studying in Course No. C2 2) Get the student details of those students who are studying in both courses, with course number, C4 and course no. C6

Q.3. List and explain the two integrity rules of relational model with the help of a suitable example for each.

Q.4. Define Hash join and explain the process and cost calculation of Hash join with the help of an example.

Q.5. i) List the feature of semantic database
 ii) Explain clustering in data mining
iii) Explain the characteristics of mobile database. Also give an application of mobile database.
 iv) How is audit trail done in database? How are they related to database security?

Q.6. i) How does OLAP support query processing in dataware house.
       ii) Differentiate between embedded SQL and dynamic SQL. Give an example of embedded                      SQL.

Q.7. Explain the following with the help of an example:
i) Application of Datagrid
ii) XML and HTML
 iii) Data-marts
iv) Security classes
v) Concurrently control
vi) Deductive database
vii) Significance of creating data dictionary in database
viii) Datagrid
 ix) Query optimization
x) Heterogeneous database.