Sikkim-Manipal University of Health Medical and Technological Sciences (SMUHMTS) 2009 B.C.A Computer Application BC0041 Fundamentals of Database Management Assignment - Question Paper

August 2009

Bachelor of Computer Application (BCA) Semester 2

BC0041 Fundamentals of Database Management 4 Credits
(Book ID: B0716)

 

Answer All the Questions

 

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

 

 

2. Explain the following concepts with respect to storage structures in databases:

       Clustering [10 Marks]

       Indexing

 

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

 

4. Describe the following 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 two examples from outside (Other than the text book examples)

 

 

 

 

 

 

 

 

 

 

 

August 2009

Bachelor of Computer Application (BCA) Semester 2

BC0041 Fundamentals of Database Management 4 Credits
(Book ID: B0716)

 

Answer All the Questions

 

 

1. Describe the following: [10 Marks]

       Advantages of Database processing

       Functions of a DBMS

 

 

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

 

 

3. Explain the first 3 Normal Forms taking the help of an un-normalized relation and reducing it to 3 NF. [10 Marks]

 

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