CS403 Current Mid Term Paper
Here we have Current Mid term Past Papers of CS403 Database Management Systems semester fall 2016. Previously we shared List Of Virtual University 8th Convocation Position Holders.
You Can Also Download CS403 Solved Mid Term Papers, Short Notes, Assignment Solutions, Lecture Wise Questions Answers Files, Solved MCQs, Solved Quiz , CS403 Solved Mid Term Subjective Papers ,CS403 Solved Mid Term Objective Papers from Virtual Study Solutions For Preparation of Mid Term Papers.
Also Read: Virtual University 8th Convocation Complete Details
Also Read: What is Recursive function in c++ with Examples
CS403 Current Mid Term Question no 1
Part of ER diagram for "University System" is given below. Mention Dependency exists between entities from the list provided.
(Dependencies: Existence, Identifier, Referential)
CS403 Current Mid Term Question no 2
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?
Relation 1
Student ID Name Address Degree ID
1 ABC ABC123 Null
Default XYZ XYZ123 01
2 WXY WXY123 05
Relation 2
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]
CS403 Current Mid Term Question no 3
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.
CS403 Current Mid Term Question no 4
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
CS403 Current Mid Term Question no 5
You are required to draw an ER diagram including entities along with relations and Cardinality 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."
CS403 Mid Term Paper Fall 2016 Sample 1
- What are the three features of Physical data model
- Context level DFD (student grading system)
- Components of Relational data model
- Context level DFD (KFC order)
- Draw a matrix by the given diagram and data
CS403 Mid Term Paper Fall 2016 Sample 2
1. what is the purpose to use the relational data model?
2. what is relationship set ?
3. explain union operation in relational algebra?
4. what is secondary key give an exampel also ?
5. what is partial dependency ?
6. what are data anomalies?
2. what is relationship set ?
3. explain union operation in relational algebra?
4. what is secondary key give an exampel also ?
5. what is partial dependency ?
6. what are data anomalies?
CS403 Mid Term Paper Fall 2016 Sample 3
CS403 Current Mid Term Question no 1
Part of ER diagram for "University System" is given below. Mention Dependency exists between entities from the list provided.
(Dependencies: Existence, Identifier, Referential)
CS403 Current Mid Term Question no 2
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?
Relation 1
Student ID Name Address Degree ID
1 ABC ABC123 Null
Default XYZ XYZ123 01
2 WXY WXY123 05
Relation 2
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]
CS403 Current Mid Term Question no 3
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.
CS403 Current Mid Term Question no 4
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
CS403 Current Mid Term Question no 5
You are required to draw an ER diagram including entities along with relations and Cardinality 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."
Post a Comment