Download Solved Assignment of MCS-043 January 2014

Download Solved assignment of MCA - Master in Computer Application
Post Reply
User avatar
pooja
Posts: 1422
Joined: Thu Jul 17, 2014 11:19 am

Download Solved Assignment of MCS-043 January 2014

Post by pooja » Mon Jul 28, 2014 10:53 am

Solved Assignment of MCS-043 - Advanced Database Mathematics Management Systems January 2015

User avatar
pooja
Posts: 1422
Joined: Thu Jul 17, 2014 11:19 am

Re: Download Solved Assignment of MCS-043 January 2014

Post by pooja » Tue Jan 13, 2015 12:39 pm

Course Code : MCS-043
Course Title : Advanced Database Management Systems
Assignment Number : MCA (4)/043/Assign/2014-15
Maximum Marks : 100
Weightage : 25%
Last Dates for Submission : 15th October, 2014 (For July 2014 Session)
15th April, 2015 (For January 2015 Session)


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. (10 marks)

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 (5 marks)

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

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

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? (20 marks)

Q.6. i) How does OLAP support query processing in dataware house. (10 marks)
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. (20 marks)

MichaelClaflin
Posts: 1
Joined: Mon Jun 25, 2018 3:44 pm

Re: Download Solved Assignment of MCS-043 January 2014

Post by MichaelClaflin » Mon Jun 25, 2018 3:50 pm

That was very useful. As part of my research for https://ukessay.com/essay-writing-service I really needed this information. You can make a great contribution to people who research this kind of stuff.

Post Reply