MCS-043
1. (a)
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. (10 Marks)
(b) Create appropriate tables and relationship
among them for the E-R design (6 Marks)
(c) 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.(6
Marks)
(d) 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? (6 Marks)
(e) 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
2. Create an
object oriented database for the following UML class diagram. Make assumption
about your attributes and facts.
3. Explain
MVD (Multi Valued Dependencies) and join dependency with the help of an example
of your choice. (6 Marks)
4. Define
a simple hash-join and explain the process and cost calculations of hash-join
with the help of an example. (6 Marks)
5. The following
are the relational schemes of Employee, Project and Assigned-to (8 Marks)
Employee (Emp#, Emp_name, Profession),
Project (Proj#, Proj_name, Chief_Architect),
Assigned-to (Proj#, Emp#).
·
Create
appropriate samples of each relation according to the question.
·
Write the
following queries in SQL.
(i) Get Emp# of employees working on Project
numbered MCS-043.
(ii) Get details of employees working on database
projects.
(iii) Finally create an optimal query tree for each
query.
6. Given the following semi-structure data in
XML, create the DTD (Document Type Declaration) for it
<document>
<student>
<NAME>
<Address>
</student>
<student>
<NAME>
<Address>
</student>
</document>
What are
the different options available for storing XML data?
7. What
is data mining? How is it different from OLTP? What is classification in
context of data mining? (5 Marks)
8. How will you enforce referential integrity
constraints in Oracle? Explain with the help of one example. (5
Marks)
9. How does
PostgeSQL perform storage and indexing of tables? Briefly discuss the type of
indexes involved in PostgeSQL
*****************************************************************
Note: Answer with Dotcom Books
www.dotcombooks4u.com
(Last 5 year solved question
paper with Assignment solutions)
9825183881
****************************************************************
No comments:
Post a Comment