Sikkim-Manipal University of Health Medical and Technological Sciences (SMUHMTS) 2009 B.C.A Computer Application BC0041 Fundamentals of Database Management Assignment - Question Paper
BC0041 Fundamentals of Database Management August 2009 Assignment
August 2009
Bachelor of Computer Application (BCA) Semester 2
BC0041 Fundamentals of Database Management 4 Credits
(Book ID: B0716)
Assignment Set 1 (40 Marks)
Answer All the Questions
- 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)
Assignment Set 2 (40 Marks)
Answer All the Questions
- 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]
Earning: Approval pending. |