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

www.vustudents.ning.com

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 Assignment No 2 Solution & Discussion Due Date: 02-05-2012

### 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

## Latest Activity

1 hour ago
+ "αяsαℓ " Ќąƶµяɨ •" liked 2.O's discussion 2 Goli Subah, 2 Goli Shaam :P :P
1 hour ago
2.O posted a discussion

### 2 Goli Subah, 2 Goli Shaam :P :P

1 hour ago
+ ..✦ S α ɾ α K ԋ α ɳ✦ liked +++Amara+++++'s blog post HADEES
4 hours ago
4 hours ago
+ "αяsαℓ " Ќąƶµяɨ •" liked Sharal Khan's discussion jag gumya ma :-p
4 hours ago
4 hours ago
+ "αяsαℓ " Ќąƶµяɨ •" liked Sharal Khan's discussion mudat bad............ ;-)
4 hours ago

1

2

3