+ 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?) + Click Here To Join (Our facebook study Group)
Note: (This is Featured Discussion)
For Important Helping Material related to this subject (Solved MCQs, Short Notes, Solved past Papers, E-Books, FAQ,Short Questions Answers & more). You must view all the featured Discussion in this subject group.
For how you can view all the Featured discussions click on the Back to Subject Name Discussions link below the title of this Discussion & then under featured Discussion corner click on the view all link.
Or visit this link
Share Your Current Mid Term Papers (Questions/Pattern) 17 December 2016 to 29 December 2016 & Past Papers as well here to help each other. Thanks
Imhum MCS thanks for sharing
Today 18.12.2016 12 pm subjective paper
Part of ER diagram for "University System" is given below. Mention Dependency exists between entities from the list provided.
(Dependencies: Existence, Identifier, Referential)
While creating a database, first step is to analyze the system for which you are going to store data in the database. After analyzing the system, which tool will you use for creating pictorial representation of the system?
Student ID Name Address Degree ID
1 ABC ABC123 Null
Default XYZ XYZ123 01
2 WXY WXY123 05
Degree ID Degree Title Duration
01 BCS 4 Years
02 MCS 2 Years
03 MSCS 2 Years
Where, Degree ID is a reference / foreign key in Relation 1.
Specify the constraint (s) applied on FK (Foreign Key) in the case given above from the list provided. Also justify your answer.
[Referential, Default, Domain]
Analyze the statement given below and identify as correct or incorrect. Justify your answer in either case.
1. In “Three Schema Architecture”, External schema is responsible for data storage on Hard Disk.
Suppose we have two entities involved in a relationship 'A' and 'B'. Entity A and B are in One to Many Relationship.
A- What would be the general rule for mapping A and B entity into relation.
B- What would be the constraint on Foreign Key, if;
I – Minimum Cardinality = 0
II- Minimum Cardinality = 1
You are required to draw an ER diagram including entities along with relations and cardinalities exist among the entities by keeping the following scenario in your mind.
"Suppose a system having three entities, i.e. Product, Product Range and Order. One product range must have at least one product and a product must belong only to a single Product Range. One Order must have at least one product and possibly many. However, at minimum there may exist zero (0) or many orders of a product."
xaIB thanks for sharing
moaz file me se mcq's aye thai ??