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

Assignment:

 

 (a). Find out the Cartesian product (D1 × D2 × D3) of the given pair of sets.                                      Marks: 5

                                                                                                                  

      D1 => Set of first two Vowels                  =     D =  {A, E}   

      D2 => Set of three country codes            =     D2 =  {213,54, 994} 

      D3 => Set of first three odd numbers       =     D3 =  {1, 3, 5}


(b). Keeping in view the previous assignment scenario lets suppose there is a simple database for some entities in CMS  might contain relations for Student, Class, Faculty and Enrollment. The relation schema would be written as:

 

Student (Stu_Id, LastName, FirstName, Major, Credits)

Faculty (Fac_Id, department, rank, name)

Class (Class_No, Fac_Id, Schedule, room)

Enrollment (Stu_Id, Class_No, Grade)

 

Using this sample relational schema, identify foreign key in Class relation and Composite primary key in Enrollment relation.                                                                                                                                     Marks: 5

+ Click Here To Join also Our facebook study Group.

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


See Your Saved Posts Timeline

Views: 1545

.

+ 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?)

Attachments:

Replies to This Discussion

where 's 2nd quiz solution

complete and correct solution is here

Attachments:

question 1 is simple one set of ordered triples  

second question

you have to mention PK, FK and composite key

yaar in second question .... We have to find out the PK and FK and composite key...so whats the solution

yarooo

class relation ma fac_id foreign key ha

and

enrollement relation ma stud_Id composite primary key ha

 

enjoy

 

RSS

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

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