Skip to main content

Posts

Showing posts with the label CS403 Recent Papers

CS403 Current Midterm Paper Fall 2013 File 2

by sadaf noreen on December 23, 2013 at 9:17pm 1.what is supertype discrimination? 2marks 2. make a many to many relationship of an employee and project department employee : emp-id,emp-name,emp-phno project:pr-id, prdura, pr                    5marks 3. there was a context diagram given had to write attributes for that dfd. 3marks 4. columns thay  5marks 1. number                    A. reg id 2. voucher2                  B. pictures 3.char                          c. name 4.blog                          D. address 5. raw                          E.college trip videos 6.......                     ...

CS403 Current Midterm Paper Fall 2013 File 1

by Hamzu on December 20, 2013 at 11:41am there are total 26 question 20 are MCQS (5 marks) Employee Emp-ID Emp-Name City 1 ABC Lahore 2 DEF Islamabad 3 GHI Lahore 4 JKL Karachi Dept-Head Head-ID Dept-Name 1 HR Dept 3 Accounts Dept Employee (Join) Dept-Head The given algebra expression has following output / resultant table. Resultant Table Emp-ID Emp-Name City Dept-Name 1 ABC Lahore HR Dept 3 GHI Lahore Accounts Dept In your point of view, the above scenario is the result of which join type? Justify your answer with reason. (3 marks) make FD in Employe_desig and EMP_ID (2 marks) why relation model is better ? (5 marks) 1 – Sigma                                   A - Procedural Query Language 2 - Table                                         - Select Operator 3 - Relational Algebra     ...

CS403 Current Midterm Paper Fall 2013 File 4

Today Paper Total Questions = 26 Total Marks = 40 Total MCQs of 1 Mark = 20 Short Subjective Question of 2 Marks = 2 Subjective Question of 3 Marks = 2 Subjective Questions of 5 Marks = 2 1- What is extension and intension 2- What is query evaluation engine 3- How many resultant tables we have, while implementing one-to-one relationship in designing database? 4- What is degree of a relation? 5- Difference between null value and zero value. 6- How does Tuple-oriented relational calculus differ from domain-oriented relational calculus?

CS403 Current Midterm Paper Fall 2013 File 3

Total Questions = 26 Total Marks = 40 Total MCQs of 1 Mark = 20 Short Subjective Question of 2 Marks = 2 Subjective Question of 3 Marks = 2 Subjective Questions of 5 Marks = 2 1- write the any four entity of Examination System of the University  2- Match the table of Sigma, Select Operator, Project Operator, Relational Algebra, Primary Key, Foriegn Key ...  3- write the functional dependencies of the the St-Id, Supervisor-Id, Specialization-Id 4- Match 2 columns and ri8 in 3rd column (which includes entity type, value set, Primary Key,  or yad nae hy :(

CS403 Current Midterm Paper Fall 2013 File 7

by maham rida on December 21, 2013 at 7:32pm todye my paper is................    21 dec 2013     ( 8.30 to 9.30) define semi join (2) write the list name of two rules of disjointness constraints (2) convert the given table into first normal form (3) map the one to one relationship given table (3) write down 5 properties of table (5) select (cus add = Lahore (customer)) × (product) (5)

CS403 Current Midterm Paper Fall 2013 File 6

by rao usman on December 21, 2013 at 1:46pm 7 to 8 MCQS from Moaz bhai files Friend function define krna tha code k sath aik main class ka code diya howa tha aur humain oes k andar static variable define krna tha Aik class ki diagram the jis ko textual define krna hai... bank ka sanirio tha aik main -operator overload krwana tha aur aik main & operator aik aur b the oes main b operator ka scean tha kuch wo yaad nai ae raha