Database Management System (DBMS) 2011 Question Paper (BCA Sem-2)

Download below DBMS pages

Page 1

Page 2

Page 3

Page 4

Page 5

Page 6

Most IMP Advanced C-Programming Questions (University Exam)

1.       State different between Array & Structure with example

2.       Explain structure with pointer with suitable example

3.       State different between Array with example

4.       State different between automatic & external variable with example

5.       Different between Global Variable & Static Variables with example

Normalization Flow Chart

Normalization step by steps:-

1.       Check, If there are any comma separated value. If yes then create a row for single data.

2.       Check for primary key, It must exist.

3.       Check weather Primary key -> Composite key. If no, then table is already in 2^nd Normalization Form. Else draw dependency diagram and follow the process to convert table in 2NF. It removes partial dependency.

4.       Check if there exists any Transitive dependency. If no, Table already in 3NF.

IMP DBMS Information

1.       Problem with File System.

2.       Advantages & Disadvantages of DBMS.

3.       Function of DBMS.

4.       Relationship Types

5.       Hierarchical & Network Model

6.       Degree Data Abstract

7.       All kinds of Keys.

8.       Entity Rules

9.       Relation Set Operator

10.   Data Dictionary & Indexes

11.   ERModel & Normalization

12.   Cardinality, Weak Entity

o   DBMS                    -Database Management System

o   DBTG                     -Database Task Group

Assignment 4 (DBMS)

1.       What is weak entity? How you know that a particular entity is a weak entity explain with example.

2.       When do we call that two entities have a strong relationship?

3.       Explain domain of any attributes.

4.       Write a very short note on existence dependence.

5.       Explain relationship participation in detail.

6.       What is relationship degree ?Explain all kind of relationship degree why entity relationship is called recursive?

7.       Explain associative entities.

Weak Entity and Strong Entities in DBMS

An entity set that does not possess sufficient attributes to form a primary key is called a weak entity set. One that does have a primary key is called a strong entity set.

 For example,
The entity set transaction has attributes transaction-number, date and amount.
Different transactions on different accounts could share the same number.
These are not sufficient to form a primary key (uniquely identify a transaction).

DBMS Assignment 2 Questions

Q.1    Describe the below mentioned topics and their advantages and disadvantages.

            1. Hierarchical Model
            2. Network Model
            3.Relational Model
            4.Entity Relational Model

Degrees of Data Abstraction

Hello Students,

Here is a wonderful documentation of three schema architecture of DBMS or Degrees of Data abstraction..
http://www.myreadingroom.co.in/images/stories/docs/dbms/degrees%20of%20data%20abstraction.pdf

-Shalini

DBMS Introduction PDF File

Download DBMS PDF File

Name of 5 DBMS Softwares

* Oracle
* SQL server
* Fox Pro
* MS-Access
* Sequel-Pro(mac)