Download Model question papers & previous years question papers

Posted By: S.Yamini       Member Level: Diamond       Posted Date: 04 Jul 2008

2007 Indira Gandhi National Open University (IGNOU) Post Graduate Diploma Computer Application Database Management system Question paper Course: Post Graduate Diploma Computer Application   University: Indira Gandhi National Open University (IGNOU) Test Papers / Previous Question Papers of IGNOU CS06 Database Management System June 2007 PGDCA / MCA (I Yr) Term-End Examination June, 2007 CS06 : Database Management System Time: 3 hours Maximum Marks: 75 Note: (1) Question no. 1 is compulsory. Attempt any three questions from the rest 1.(a) A Bank maintains information about customers and their accounts. Each customer has a name, address (house number, area, city and state code) and telephone number. Account has number, type and balance. We need to record customers who own an account. Account can be operated individually or jointly. Design and draw an ER diagram, clearly indicating the attributes, keys, the cardinality ratio and participation constraints. (7) (b) What is meant by data abstraction ? Explain the differences between physical level, conceptual level and view level of data abstraction. (6) (c) Explain at least five important characteristics of OORDBMS. (5) (d) For the relation R and S given below, compute natural join and outer join. (6) R A B C 1 2 3 4 5 6 7 8 9 S B C D 2 3 10 2 3 11 6 7 12 (e) Given the following relations : (6) Vehicle (reg_no, colour, type) Person (eno, name, address) Owner (eno, reg-no) Write expressions in the relational algebra to answer the following queries : (i) Ust the reg_no of vehicles owned by "Sandeep)" . (ii) List the names of persons who own "lndica" cars. (iii) List details of all the black coloured vehicles. 2.(a) Describe DROP TABLE command of SQL with both the options CASCADE and RESTRICT. (5) (b) Explain the recovery process after system failure using checkpoint. (5) (c) How is the knowledge representation done through semantic network ? Give an example of semantic network. (5) 3.(a) How does data fragmentation support the distributed databases ? Explain horizontal and vertical fragmentation using an example of given relation. (6) Project (Project-name, Emp_DO, Emp_name, Job-class, Emp-location, Salary) Note: Assume the suitable data. (b) What is NULL ? Give an example to illustrate testing for NULL in SQL. (4) (c) Define and differentiate between ordered indexing and hashing. (5) 4.(a) Construct a B+ tree for the following set of key values where the number of key values that fit in a node is 3. (8) Key values: ( 12 ,2, 15,4 , I23, 45,6 ,7,9,1, 3) Show the steps involved in the deletion of key values 7 and then 6. (b) Why is BCNF a more desirable normal form than any of the lower order normal forms ? Give an example of a relational schema that is in 3NF but not in BCNF. (7) 5.(a) Define the following with respect to SQL. Also give an example of each. (i) UNIQUE function (ii) ORDER-BY clause (iii) LIKE predicate (b) Explain different methods of implementing the (i) Hierarchical Data Model (iil Network Data Model (c) What is the difference between a database schema and a database state ? Return to question paper search

Next Question Paper: M.A. PART-II 2 YEARS (HONOURS) EXAMINATION 2003 Previous Question Paper: M.A. PART-I 2 YEARS (HONOURS) EXAMINATION 2004 Related Question Papers: Data Structures Through 'C' And Pascal (Practical) Set 1 BNS-104: COMMUNICATIVE ENGLISH Managing change in organisations BNS109A English and Human Factors June 2005 CS-67P-S1 RDBMS Lab Categories

Submit Previous Years University Question Papers and make money from adsense revenue sharing program

Are you preparing for a university examination? Download model question papers and practise before you write the exam.