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.

WAP Structure with File Handling

#include<stdio.h>
#include<conio.h>
struct product
{
int c;
char name[20];
int qty,cost;
}p[100];

How to Draw House,Tree & Sun with C-Graphics

#include<graphics.h>
#include<conio.h>
void main()
{
int gd=DETECT ,gm;
int p[]={320,150,420,300,250,300,320,150};
initgraph(&gd,&gm,"C:\\TC\\BGI");
cleardevice();

Collect Sem-2 C-Programs

You total C-Program must up to 40

Download .rar File

Download FY BCA Sem-1 Result

Download Now (.pdf)

Maths Presentation Schedule

1.       Limit & Differentiation                        over

2.       Derivative                                          30 March

3.       Application of Derivative                    2 April

4.       Integration                                         4 April

5.       Application of Integration                   6 April

6.       Differential Equations                         9 April

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

Download C- Graphics Material Files

Download File 2

Download File 1