TOTAL 27 QUESTIONS
22 MCQZ, REMAINING LONG QUESTIONS
MCQZ MOSTLY FROM ONLINE QUIZEZ
LONG QUESTION
E-R DIAGARAM
GIVEN SUITAIONS Aand find out the suitaion is this 1NF or 2NF upto 6N
theta join , semi join,
relations and relation, tuples and degree difference?
mostly situation tables
===========================
IN My PAPER
1 difference between intersaction & set difference operation (2 marks )
2.Variables and data type in two columns Relate these columns relate with each other LIke data type is related to variable f ( which has some name ) eg. 1-> f (5 marks)
3.Draw a ER diagram of given scenario.. ( 5 marks )
4.Check The rules and find that statement is in which normal ? (3 marks )
5.ER diagram was given .Draw it again with out multivalued attribute (3 marks )
======================
Total 40 marks
20 mcqs(most from past papers)
6 quests…
Draw a ER diagram of Patient Management System…5 marks
Two relations were given and asked to find equi join of them…5 marks
Why relation model is consider as simple?3 marks
What is one-to-one mapping table?2 marks
Two relations was given to find set difference…2 marks
One question related to projection, and joins type…3 marks
==================
Current Paper of CS 403 …DATE 13 MAY 2012
MASOOM FAIRY
Total 26 Questions:
20 MCQ'S in which 6 MCQ'S are from past
papers and other are from all 22 lectures.
Subjective Questions are:
Q: 21: You have to sequence these data:
i: ERD
ii: Relation
iii: DFD
iv: Cartesian Product
MARKS: 2:
Q: 22: Identify above Relation is in which
NF? Write reason also.
MARKS: 2:
Q: 23: Suppose ERD for Employee Record
System, where Employee belong to any of the
given Category,
i: Hourly
ii: Permanently
iii: Temporarily
Describe these are in which category, if
Employee do his/her own work after
completion of job.
[Complete consentraint, partially
consentraint]
Current Paper of CS 403 …DATE 13 MAY 2012
MASOOM FAIRY
MARKS: 3:
Q: 24: ∏Degree ID, Degree Title
(δDuration=2(Relation1))
Find the Resultant case algebra statement.
Q: 25: Find out the Cartesian product
(A x B) of the given pair of sets.
Also find any two relations from the
Set A x B.
MARKS: 5:
Q: 26: Find Q=Credit-Hours>3.
MARKS: 5:
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Q.1 Different activities of DB development process are below you are required to write the correct sequence.
Relation
Cross reference matrix
ERD
Q.2 List down any two types of anomalies
Q.3 Suppose we have an ERD for employs record system, where employs belong to any of the given category.
Hourly
Permanent
Contractual
Q.4 Relates Colum 1 to the Colum 2( the Colum was given)
Q. 5 Draw cross reference matrix for the given diagram where 1,2,3,4 are reports of an organization A B C D E F are the attributes of this report
======================
Difference between relation and relationship.
two types of nominals.
Two tables are given and you have to develop semi-join from them.
Create a ERD of university course selection system.
======================
nothing was from past papers...!
5 marks ka aik scenario dia hoa tha us mn sy entities nikalny thy
5 marks ka functinal dependancy tha us ko high normal form mn convert kerna tha
2 marks. how many resultant table when one to one implemntd.
2marks diference bw equi and natural join
define range contrl
=: ============================
20Mcqz(2,3 from past paper else from lecture 1-22)
6 Subjective Questions
Q1:- Names different types of completness?(2)
Q2:- What is range control?(3)
Q3:-X(StudentId, SpecializedId, SupervisorId)
Dependences
StudentId, SpecializedId is functionally determines SupervisorId
SupervisorId is functional determines SpecializedId
A) Is BCNF
B) IS X have every candidate key (2)
Q4:- Find equi-join table? (5
Q5:- Given a paragraph find different entities? Paragraph is related university pic and drop srvice
========================
X(StudentId, SpecializedId, SupervisorId)
Dependences
StudentId, SpecializedId is functionally determines SupervisorId
SupervisorId functional determines SpecializedId
A) Is BCNF
B) IS X have every candidate key
20Mcqz(2,3 from past paper else from lecture 1-22)
6 Subjective Questions
Q1:- Names different types of completness?(2)
Q2:-X(StudentId, SpecializedId, SupervisorId) ( 2)
Dependences
StudentId, SpecializedId is functionally determines SupervisorId
SupervisorId functional determines SpecializedId
A) Is BCNF
B) IS X have every candidate key
Q3:- What is range control? (3)
Q4:- Multivalved attributes? (3)
Q5:- Given a paragrapg find different etititis? Paragraph is related to university pick and and drop service. (5)
Q6:- Make equi-join table? (5)
==========================
سورہ النحل
bajaye is k tum bura karo or zamana tmko acha samjhe"
--
To post to this group, send email to vuhelp_pk@googlegroups.com
To unsubscribe from this group, send email to vuhelp_pk+unsubscribe@googlegroups.com
Group Rules Vuhelp4u
Sharing of Video songs links, movies links, dramas links are not allowed in study group. Only Islamic and general information Video links allowed.
SPAM, Advertisement, and Adult messages are NOT allowed and that member will be behaved strictly.
http://groups.google.com/group/vuhelp_pk?hl=en_US
No comments:
Post a Comment