CS403 Midterm Questions

salam fellows, today my most of the paper came from last 5 6 lectures aik question me two tables given thay n third table me dono tables ko join kia va tha and uski joining type btani thi k konsi hai? 5marks Q: rules of mapping. 3marks Q :can relational data model use for external , conceptal , logical view? yes or no give logical reason. 2marks define subtype discriminator? yahi kuj yaad raha hai.. or mcqs to sab me say hi aye thy...

there are total 26 question 20 are MCQS (5 marks) Employee

Emp-ID Emp-Name City 1 ABC Lahore 2 DEF Islamabad 3 GHI Lahore 4 JKL Karachi Dept-Head

Head-ID Dept-Name 1 HR Dept 3 Accounts Dept Employee (Join) Dept-Head The given algebra expression has following output / resultant table. Resultant Table

Emp-ID Emp-Name City Dept-Name 1 ABC Lahore HR Dept 3 GHI Lahore Accounts Dept In your point of view, the above scenario is the result of which join type? Justify your answer with reason.

(3 marks) make FD in Employe_desig and EMP_ID (2 marks) why relation model is better ? (5 marks)

2 - Table - Select Operator

Suppose we have two relations A and B, where: A=>R.No B=>GPA And A = {01, 02} B= {3.5, 3.7} Answer the following questions.

1. Find A X B

Answer 1:- A x B = {01,3.5} {01,3.7} {02,3.5} {02,3.7} Answer 2:- B x A {3.5,01}{3.5,02} {3.7,01}{3.7,01} Answer 3 :- No in cartesion product A x B not equal to B x A A x B = {01,3.5} {01,3.7} {02,3.5} {02,3.7} B x A {3.5,01}{3.5,02} {3.7,01}{3.7,01}

2. Find B X A
3. Can A X B = B X A

and thanks to Ctrl Z property of MS word to share my Paper with you :p

2Q---2 marks 2Q---3marks

1. Normalization ky question ay ty subjective ma; tables diy ty aur batana tha kis normal form ma han aur split karna tha next form main..
2. Aik sutiation di thi us ma ER diagram banani thi
3. domain attribute ka aik 2 marks ka question tha
4. 2 names batany ty anomalies ky

st 2 or 3 mcqs moaaz file se thy, subjective ka koi b question match nae kr rha tha kisi b past ppr se…

1. 1 question was related to constraints of foreign nd primary key
2. ek qu maping se related tha
3. ek scenario given tha jis k mutabik btana tha k is mai complete disjoint,partial ya overlap rule mai se kon sa use hua ha aur phr explanation deni the.

Q4. ek scenario normalization se related tha jis mai btana tha k kon c normal form use hoe ha nd explain krna tha k how?

5. ek mathematical relation se tha
6. last wala na mjhy smjh aya na kia aur na e yad ha…

Q1. what is supertype discrimination? (2 marks)

2. make a many to many relationship of an employee and project department employee : emp-id,emp-name,emp-phno

project:pr-id, prdura, pr 5marks

Q3. there was a context diagram given had to write attributes for that dfd. (3 marks)

Q4. columns thay (5 marks)

1. number A. reg id
2. voucher2 B. pictures
3. char c. name
4. blog D. address
5. raw E.college trip videos
6. ...... F........

had to write in this form 3->C 3How many resultant tables we have, while implementing one-to-one relationship in designing database? 4What is degree of a relation?

6- How does Tuple-oriented relational calculus differ from domain-oriented relational calculus?

7 to 8 MCQS from Moaz bhai files Friend function define krna tha code k sath aik main class ka code diya howa tha aur humain oes k andar static variable define krna tha Aik class ki diagram the jis ko textual define krna hai... bank ka sanirio tha aik main -operator overload krwana tha aur aik main & operator aik aur b the oes main b operator ka scean tha kuch wo yaad nai ae raha

20 MCQ's 6 questions subjective 2 = 2marks , 2 = 3 marks . 2 = 5 marks 2 or 3 mcq's were from past papers Functional and Non Functional requirement

StudentName, address (σcity rank=’Asst Prof’ (Student)) write the resultant table (5 marks) and Student R.No, GPA A=> (02 , 05) B=> (3.5,3.7) solve A X B And B X A And show that A X B = B X A (5 Marks) what is completeness? (2 marks ) change the diagrame into relations. (3 marks)