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

# mid-term papers

salam

dear students,

any one who attempt papers of cs403 plz share others

thanxs

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

Views: 695

.

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

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

### Replies to This Discussion

Shared by other students mine will be tomorrow
http://bkserv3.net/smiley/116.gif
My CS403 Paper
if level zero and level one DFD provide us enough details of each system then y we need contxt lvl DFD?
discuss the main purpose of range control?
normalization is must to apply on all database justify this statement as correct or incorrect?
property rentd system ka long tha ak
certesian product k about tha ak que
Subjective:-
1. Write two major characteristics of RDMs --2 marks
2 . Analyze relation (EMPLOY(enpId,empName etc... ))... and tell whether it is in 2ND
note: it is in 1NF -- 2 marks
3. Why do we say RDM are considered to be simple? -- 3 marks
4. A table was given , draw table for the statement (statement of projection composite wla)
5. Write Cartesian product D X S and write two relations from DXS
D= {manager, officer , director}
S={15000,20000,50000}
6. a table given .... find which normal entity is in and explain how update anomaly occur -- 5 marks
Long Questions: 1. 1NF and 2NF conversion 2. Type Anomalies 3.

thanks Naughty Princess for sharing the paper

discuss the main purpose of range control?

Range Control

Range control implemented over the data can be very easily achieved by using
any data type. As the data type enforces the entry of data in the field according
to the limitations of the data type.

5. Write Cartesian product D X S and write two relations from DXS
D= {manager, officer , director}
S={15000,20000,50000}

Ans: cartesian product: D X S= {(manager, 15000), (manager, 20000), (manager, 50000), (officer, 15000), (officer, 20000), (officer, 50000), (director, 15000), (director, 20000), (director, 50000)}

two relations are:

R1={(manager, 15000), (manager, 20000), (director, 20000)}

R2={(manager, 15000), (manager, 20000), (manager, 50000),(officer, 20000)}

normalization is must to apply on all database justify this statement as correct or incorrect?

Ans: Normalization is not compulsory, but it is strongly
recommended that normalization must be done. Because normalized design makes the
maintenance of database much easier. While carrying out the process of normalization,
it should be applied on each table of database.

1. Write two major characteristics of RDMs --2 marks

Ans: RDBMS stands for Relational Database Management System. It organizes data into related rows and columns.

Features:

- It stores data in tables.

- Tables have rows and column.

- These tables are created using SQL.

- And data from these tables are also retrieved using SQL.

3. Why do we say RDM are considered to be simple? -- 3 marks

Ans: The RDM is simple, why, there is just one structure and that is a relation or a table. Even this single structure is very easy to understand, so a user of even of a moderate genius can understand it easily.

MCQs Bock say thy past paper say koi nahi aya paper
1. Suppose we have two entities involved in a relationship, Entities are A and B. Entity A and B are in one-to-one relationship. (5 Marks
2.Suppose we have two entities involved in a relationship, Entities are A and B. Entity A and B are in many-to-many relationship.3 marks
3. Types of join is ka kalam milana thi 4 types ka nam likay thay or ak taraf un ki pictures Thita join, projection,equi join or semi join ki 2 marks
4.ak statenment thi batana tha ye correct ya incorrect justify your answer 2 marks
ak ye question or ak or same isi tara ka tha atribute change thay bas

ak ye

ak ye

## Latest Activity

+!"❀mσσn❀ "ꌗ" updated their profile
31 minutes ago
Amal Hanif joined + M.Tariq Malik's group

### MGT605 Advanced Cost and Management Accounting

1 hour ago
Student's discussion was featured

### mgt 602

2 hours ago
+ M.Tariq Malik liked Student's discussion mgt 602
2 hours ago
+ M.Tariq Malik replied to Student's discussion MGT602 Quiz 3 in the group MGT602 Entrepreneurship
3 hours ago
+ M.Tariq Malik liked Student's discussion MGT602 Quiz 3
3 hours ago
+ M.Tariq Malik liked +.Ãŋɠɜʆḁ.+'s discussion Final Term past papers
3 hours ago
+ M.Tariq Malik liked +.Ãŋɠɜʆḁ.+'s discussion CS603 Final Term past papers
3 hours ago

1

2

3