We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ Link For Past Papers, Solved MCQs, Short Notes & More

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

+ Click Here To Join also Our facebook study Group.

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?


See Your Saved Posts Timeline

Views: 2906

.

+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

Replies to This Discussion

All MCQs are new.

Subjective: ( which i remember

i) what is degree of a relation?

ii) join types? define a join type which is suitable and assign it for given example.

iii)assign data types for above described attributes.

iv)Normalization

Hafiz Arslan 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.

+ Death Game + Thanks for sharing 

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.

1) List the difference between relationns and relationship?

2) Table diya tha jis mese degree n Cartesian Product find karna tha.

(3 Marks k Questions)

3) Table diya hua tha us mese NF find krni the k konsi hai n apne apne justify karna tha.

4) Aik table tha jis me 2 columns the like this:



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

otal Question 26

20 were mcqz 50% from past paper and 6 subjective were as below;

Q: 01 How many Resultant tables we have, while implementing one-to-one relationship in designing database? 2 Marks

Q: 02 As we know, Software is of two major types.

  • System Software
  • Application Software

Write short names, which can be used to encode/compress for each type of Software mention above? 2 Marks

Q: 03 Which of the attributes(s) from the given diagram is/are best candidate for multi-valued attribute? 3 Marks

Q: 04 Relational algebra se related question tha table diya tha or 1 equation di thi jis k mutabiq us table ko explain krna tha? 3 Marks

Q: 05 Suppose we have two entities involved in a relationship, Entities are A and B. Entity A and B are in one-to-many relationship.

@ What would be the general rule for mapping A and B entity into relation? 5 Marks

A. what would be the constraint on foreign key, if;

  1. Minimum Cardinality = 0
  2. Minimum Cardinality = 1

Q: 06 I’ve forgot

   Best of luck to all students




CS403 - 12 dec 2012 11.00 am

 

  1. Name types of completeness constraint.    (2 marks)
  2. Match the table one side contain operation names (projection, theta join, equi join etc) and the other side contain symbols.     (2 marks)
  3. Two tables are given, point out domain constraint, default and referential constraint and also explain.         (3 marks)
  4. Example given suppose (not the exact example)

              std (stId, stName, prName)

              prg(prName, prCrdts)

      which normal form is used in this example.      (3 marks)

  1. One scenario was given point out entities.         (5 marks)
  2. Which inference rule is use explain                   (5 marks)

       If (X-> YZ) then X -> Y and X -> Y .

 Sana Khan 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.

Cs403

Date 12-12-2012

Midterm paper

Subjective

1)      Difference between relation and relationship?                    2marks

         Answer:

         Relation: is a structure of relational data model

         Relationship: is purely construct of E-R data model.

2)      These two are software’s. Write them in short form to be used in code.    2marks

          a)      System software

          b)      Application software

             Answer: according to me

              syssoftware

              appsoftware

3)      Using select() and project() what is outcome of this instruction 3 marks

         projectSign stu-name, stu-address (selectSign city, Lahore (relation 1))

 

        Relation 1

Stu-id

Stu-name

Stu-address

City

1

XYZ

XYZ123

Lahore

2

ABC

ABC123

Lahore

3

JHI

JHI123

Karachi

4

KLM

KLM123

Islamabad

5

PQR

PQR123

Lahore

 

Answer: according to me is

Stu-name

Stu-address

City

XYZ

XYZ123

Lahore

ABC

ABC123

Lahore

PQR

PQR123

Lahore

 

4)      Can we use relational data model for logical/conceptual view. Yes or no?       3marks

         Answer: Yes we can use. Because it makes data and schema manipulation much easier.

5)      Which inference rule is used? Write name.  5marks

a)      stu-Id -- > stu-name         and     stu-name-- > stu-class

         stu-id -- >stu-class

b)      stu-id -- > stu-name

          stu-id . stu-class -- > stu-name . stu-class

          answer.  a) Transitivity                      b) Augmantation

6)      Draw ER.diagram for the following entities.            5marks

a)      Doctor

b)      Patients

c)      Admitted patients

d)      Outdoor patients

e)      Bed

  • Doctor are associated only with single type of patients
  • Patients are sub divided into two groups admitted and outdoor patients
  • Bed are associated only with admitted patients

Instruction was given are same like above. Maybe a lil bit difference in them.

 

Attachments:

aira abbas 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.

 

thanks admin

aj mera cs403 ka 2:30 bajay paper hai dua karna

RSS

Latest Activity

M +S +K posted a status
"Faasle Ghata Dete Hain Dilo’n Mein Nafraton Ko, Woh Jo Dur Huye Toh Kuch Mohabbat Si Hone Lagi"
58 seconds ago
M +S +K posted a status
"Ab Iss Ke Baad Laga Dil Toh Dil Lagi Hogi, Hum Tum Pe Apni Mohabbat Tamam Kar Bethey"
1 minute ago
M +S +K posted a status
"Zaroori Toh Nahi Jo Khushi Dey Ussi Se Mohabbat Ho, Pyar Toh Akser Dil Torne Walon Se Bhi Ho Jaata Hai"
4 minutes ago
M +S +K posted a status
"Tum Aik Shayar Ki Mohabbat Ho Jaana, Zinda Rahogi Hemesha Lafzon Mein"
11 minutes ago
M +S +K posted a status
"Kabhi Parh Toh Sahee Meri Aankhon ko, Yahan Samundar Behta Hai Teri Mohabbat Ka"
12 minutes ago
Zain Kazimi posted discussions
13 minutes ago
Zain Kazimi liked Zain Kazimi's discussion Self Poetry
14 minutes ago
M +S +K posted a status
"Usne Apni Aankhon Se Tableegh Hee Yun Ki, Main Bina Soche Mohabbat Pe Iman Le Aaya"
15 minutes ago

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

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