Sikkim-Manipal University of Health Medical and Technological Sciences (SMUHMTS) 2009 B.C.A Computer Application MC0041-Fundamentals of Database Management- Assignment s for fall session - Questi

August 2009
Bachelor of Computer Application (BCA) – Semester 2
BC0041 – Fundamentals of Database Management – four Credits
(Book ID: B0716)
Assignment Set – one (40 Marks)


Answer All the ques.

1. Explain the kinds of database Systems. [10 Marks]


2. discuss the subsequent concepts with respect to storage structures in databases:
• Clustering [10 Marks]
• Indexing

3. discuss the concept of foreign key. How a foreign key differs from a primary key? [10 Marks]

4. define the subsequent with respect to Relational Databases:
• Database Creation [10 Marks]
• Sorting of Records within a table
• Built – in Functions
• Union

Note: All the above descriptions should be done by taking atleast 2 examples from outside (Other than the text book examples)











August 2009
Bachelor of Computer Application (BCA) – Semester 2
BC0041 – Fundamentals of Database Management – four Credits
(Book ID: B0716)
Assignment Set – two (40 Marks)


ans All the ques.


1. Describe the following: [10 Marks]
• Advantages of Database processing
• Functions of a DBMS


2. define DIFFERENCE and DIVIDE Operators with suitable examples [10 Marks]


3. discuss the 1st three Normal Forms taking the help of an un-normalized relation and reducing it to three NF. [10 Marks]

4. elaborate views? How acan you create a view. [10 Marks]

Earning:   Approval pending.