B.C.A RELATIONAL DATABASE MANAGEMENT SYSTEMS Question paper - 2008

Started by ganeshbala, Jan 08, 2009, 07:18 pm

previous topic - next topic
Go Down

ganeshbala

B.C.A RELATIONAL DATABASE MANAGEMENT SYSTEMS Question paper - 2008 open university

RELATIONAL DATABASE MANAGEMENT SYSTEMS

Time : 3 hours Maximum marks : 75

Answer for 5 marks questions should not exceed 2 pages.

Answer for 10 marks questions should not exceed 5 pages.

PART A -- (5 5 = 25 marks)

Answer any FIVE questions.
1. Discuss briefly about DBMS.
2. Discuss briefly about the steps involved in designing a database.
3. Discuss briefly the desirable properties of decompositions.
4. Define the following
(a) domain
(b) attribute
(c) primary key
(d) candidate key
(e) relational database.
5. Discuss briefly about Microsoft Access Database.
6. Discuss briefly how to set toolbars to our working style.
7. Discuss the benefits of conventional DBMS.

PART B -- (5 x 10 = 50 marks)

Answer any FIVE questions.
8. Discuss in detail the advantages and disadvantages of using a database system.
9. Discuss in detail the components of an E_R diagram.
10. Explain in detail the various NORMAL FORMS.
11. Explain in detail about the objects of an Access Database.
12. Explain in detail how to create Tables using Microsoft Access Database.
13. Explain in detail how to create Forms using Microsoft Access Database.
14. Explain on views and security using SQL

Go Up
 

Quick Reply

With Quick-Reply you can write a post when viewing a topic without loading a new page. You can still use bulletin board code and smileys as you would in a normal post.

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.
Name:
Email:
Verification:
Please leave this box empty:

Type the letters shown in the picture
Listen to the letters / Request another image

Type the letters shown in the picture:

shortcuts: alt+s submit/post or alt+p preview