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

 www.bit.ly/vucodes + Link For Assignments, GDBs & Online Quizzes Solution www.bit.ly/papersvu + Link For Past Papers, Solved MCQs, Short Notes & More

Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

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

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?

Views: 756

.

+ 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

Maham Raza. liked Maham Raza.'s discussion Kuch Log..
7 minutes ago
Maham Raza. posted discussions
8 minutes ago
Maham Raza. replied to Maham Raza.'s discussion VIP Kon.......???
31 minutes ago
1 hour ago
BC20*74 added a discussion to the group MTH101 Calculus And Analytical Geometry

### MTH101 Calculus And Analytical Geometry Quiz # 1 2020 - Ending June 12 2020

1 hour ago
BC20*74 joined +M.Tariq Malik's group

### MTH101 Calculus And Analytical Geometry

1 hour ago
1 hour ago
Maham Raza. commented on Ayesha's blog post Golden Words
1 hour ago
Maham Raza. liked Ayesha's blog post Golden Words
1 hour ago
1 hour ago
Maham Raza. liked + ! ! ! ! ! ! !pคຖ໓คค ! !'s discussion ﺣﻘﯿﻘﺖ ﮐﭽﮫ ﺍﻭﺭ ہو۔
1 hour ago
Maham Raza. liked + ! ! ! ! ! ! !pคຖ໓คค ! !'s discussion ﺣﻘﯿﻘﺖ ﮐﭽﮫ ﺍﻭﺭ ہو۔
1 hour ago

1

2

3