Latest Activity In Study Groups

Join Your Study Groups

VU Past Papers, MCQs and More

CS403 Current MID Term Papers Fall 2012 Date: 08-December-2012 to 19-December-2012

Views: 3022

Replies to This Discussion

Column A
 
Column B
1
Schema
A
Binary Operation
2
 relational algebra
B
 select operation
3
 greek letter |``|  pie type tha yahin tag nai ho raha
C
 project  operation
4
 
D
 
5
 
E
 
Q2what is difference between  select operator and project  operator
Q3senario : in a govt hospital .. patient  .. nurses .. pura paragraph tha  ..aur sirf entities maloom karni thi
Q4digram thi .and find out forign key
Q5 find out  the cardinality and degree from the given table
4 column thy  so  degree =4
and 5 rows thi so cardinality = 5
Q6 yad nai raha
good luck 


R

thanks

tnx 

thanks to all friends

today is my paper at 4 pm. sb dua karna

Object was easy from 5 lecture to 18 lectures. 
Questions were 
What is null value and Zero Value 2 
A diagram given find a Foreign Key in it 2 
Can we use a Relational Data Model for logical/conceptual view yes or no justify your answer 2 

question a paragraph given find entities among them 5
A form given to check which NF it is and solve to next level 5 

You should prepare the Key all chapters Join and Normalization de-normalization also

2Q---2 marks
2Q---3marks
and 2Q---5marks

20 mcqs and 6 subjective


MCQS past papers main say 10 ayi tye 

subjective questions main 

1 : froign Key identify keri thi figure given thi 

2: characteristics of RDBM

3: diffrence b/t select and projection

4:AXB and BXA find kerna tha ----5

5: .................... bhul gya  

1.cgpa and student name ma kon si functional dependency ha
2. e.r daigrame banani thi
3.one to one relationship ka relation bananaa tha ballet paper or votter ka darmian
4. infernce rule batanay thay
5. what is mean by degree in relati
cs403 paper

My paper of cs403

Mcqs were mostly from past papers.

1 Difference between null value and zero value (2)

2 In a Database Development relation are given specify in sequence (2)

            i-Cross Refrence matrix

            ii-ERD

            ii-DFD

3 Two table student1 and student 2were given and asked to find student1- student2 (3)

4 about foreign key two table were given                              (3)

Relation1 and relation2

Relation1

Student ID

Name

Address

Degree ID

1

ABC

ABC123

Null

Default

XYZ

XYZ123

01

2

WXY

WXY123

05

 

Relation 2

Degree ID

Degree Title

Duration

01

BCS

4 years

02

MCS

2 years

03

MSCS

2 years

 

Where Degree Id is a refrencial/foreign key in relation 1. Specify the constraints applied on foreign key in the case given above from the list provided. Also justify

Referential, default, domain

5                                                                                                          (5)

Column A

 

Column B

1

Sigma

A

Procedural query language

2

 table

B

 select operation

3

 Relation algebraion

C

 project  operation

4

 

D

 Relation data model

5

 Intersection  operator

E

 Binary operation

 Write the number of item of both columns like this 5 ->E

6 A ER diagram war given and also given which are reports and which are attributes And asked to make Cross Reffrence matrix.         (5)

pereeshay Thanks for sharing ur paper 

Note for All Members: You don’t need to go any other site for current Mid Term papers fall 2012, Because All discussed data/sharing of our members in this discussion are going from here to other sites. You can judge this at other sites yourself. So don’t waste your precious time with different links.

 

my today papers ...

students mostly mcqz past papers main sy aya thy .

20 mcqz 

mostly mcqz keys and FN1 FN2 S realted thy 

2 quizz 2 marks 

1) dffrance between relation & relationship?

primery key  aur super key whers used?

2 quizz 3 marks

2 table thy un m ain sy value di hue then un main sy select krna tha tha ky superkey kis waly row lgy ge.

 

Fazi Maher Thanks 

RSS

© 2021   Created by + M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service