IGNOU MCA IGNOU BCA IGNOU MBA IGNOU CIC Courses

December 2001

Filed under:

Question Paper of CS 06 - Database Management System of December 2001 from IGNOU


Time: 3 hours
Maximum Marks: 75

Note: There are six questions in this paper Question number 1 is compulsory and carries 30 marks. Attempt any three,from the rest.

1.
a. Design a Relational database to the E-R diagram given below (7)

b. Explain the following general integrity rules of Relational Model: (8) i. Entity Integrity
ii. Referential Integrity

c. For the relations P and Q, perform the following operations: (8)
i. Find the projection of Q on the attributes (B,C)
ii. Find the natural join of P and Q on the common attributes.

P

A - B - C - D
a1 - b2 - c2 - d2
a2 - b1 - c1 - d2
a1 - b1 - c2 - d1
a2 - b1 - c2 - d2
a1 - b2 - c1 - d2
a3 - b1 - c2 - d1
a1 - b2 - c2 - d2
a2 - b1 - c1 - d2
a1 - b3 - c2 - d2

Q

B - C - D
b1 - c1 - d2
b3 - c1 - d2
b2 - c2 - d1
b1 - c1 - d2
b3 - c2 - d2

d. Write short notes on (7)
1. Object Oriented databases
2. Schema in database approach

2. Define the following terms (15)
i. Aggregation
ii. Specialization
iii. Generalization
iv. Data Independence
v. Query Processor

3.
a. Explain the distinction between the representation of association and Relationship in the network and hierarchical models. (7)

b. Explain why navigation is simpler in the Relational model than in the Hierarchical data model. (8)

4. Discuss the differences between the following file organizations: (15)

a. Serial
b. Index-Sequential
c. Hashed
d. Inverted

Compare their storage and access efficiencies. To what type of application in each of the organizations suited?

5.
a. What are the advantages of normalized relations over unnormalizaed relations? (5)

b. Why is 4NF preferable to BCNF? (5)

c. Explain the design goals of a good relational database design. (5)

6.
a. Explain how the knowledge representation is done through semantic network. (5)

b. Discuss the basics of client/server computing paradigm. (5)

c. Explain Dynamic Data Exchange and Remote Procedure Calls (5)








Related pages

December 2001

Question Paper of CS-09 - Data Communication & Network of December 2001 from IGNOU Time: 3 hours Maximum Marks: 75 Note: Question 1 is compulsory. Attempt any 3 from the remaining. 1 (a). Describe the salient features of mobile IP.3 (b). Describe the various issues related to measuring network performances.6 (c).Identify the range of .....

December, 2001

Question Paper of CS-12 - Computer Architecture of December 2001 from IGNOU Note : Question one is compulsory. Answer any three from the rest. 1. (i) What are the design parameters for pipeline processors? Discuss them briefly with examples. 5 (ii) Discuss the structure of superscalar pipelines and the factors causing .....

Date Sheet For August 2005 :IGNOU BIT / ADIT Trimester Examination

DATE & DAY 10.00 AM TO 1.00 PM 2.00 PM TO 5.00 PM 22.8.05 (MONDAY) CST-301* CSI-21 23.8.05 .....

DEC 2001

Question Paper of CS-54 - Finance & Accounting On Computers of December 2001 from IGNOU Time : 3 Hours Max. Marks : 75 Note : There are 6 questions in the paper. Question no. 1 is compulsory and carries 35 marks. From the remaining attempt any two questions. Each of these .....

June 2001

Question Paper of CS 08 Numerical & Statistical Computing of June 2001 from IGNOU Time: 2 hours Max. Marks: 75 Note: Note: Calculator is allowed in this examination. Question number 1 is compulsory. Attempt any three more questions from questions numbered 2 to 6. 1. a. Write, which of the following variable names, .....

December 2001

Question Paper of CS 08 Numerical & Statistical Computing of Dec 2001 from IGNOU Time: 3 hours Maximum Marks: 75 Note: Question 1 is compulsory. Attempt any 3 from the remaining. 1. (a) Which of the variable names given below are invalid in Fortran ? Give reasons in support of your .....

December 2002

Question Paper of CS-13 - Operating Systems of December 2002 from IGNOU 1. (a) Write and explain one of the deadlock detection algorithms and evaluate its performance. (b) Explain the logic of Dekker�s solution to the mutual-exclusion problem and also discuss whether it is suitable to be implemented in a .....

TEE - June, 2001

Question Paper of CS-02 Introduction to Software of June 2001 from IGNOU Note : Question one is compulsory. Answer any three from the remaining. 1. (1) Write a BNF grammar for the following C-language syntax : [5] a. Looping statements b. Switch statements (2) Write an algorithm for converting a decimal number .....

Bachelor of Arts (BA) Social Work

Bachelor of Arts (BA) Social Work Starting from 2004-05 Comment for Bachelor of Arts (BA) Social Work ----------------------------------------------------------------------------------------- admission for Graduate course Dears Sir/Madam, i am looking for admission for a .....

MS-26 Organisational Dynamics

Syllabus of MS-26 Organisational Dynamics From IGNOU MS-26 Organisational Dynamics Comment for MS-26 Organisational Dynamics ----------------------------------------------------------------------------------------- IGNOU MS-26, MS-27, MS-96 assignments for december 2009 please send those above assignments to provided E-mail ID ----------------------------------------------------------------------------------------- .....

Recently Visited Pages

  • JUNE 1999
    Question Paper of CS-12 - Computer Architecture of June 1999 from IGNOU Note : Question one is compulsory. Answer any three from the rest. 1.(a) (.....)
  • Abu Dhabi - 5103
    International Partner Institutions of IGNOU in Gulf Countries - Abu Dhabi - 5103 Abu Dhabi - 5103 Universal Empire Institute Of Technology Knowledge Village P.O. Box 500332, (.....)
  • DEC 1997
    Question Paper of CS-54 - Finance & Accounting On Computers of Dec 1997 from IGNOU Time : 3 Hours Max. Marks : 75 Note : There (.....)
  • Bachelor of Art (BA)
    Bachelor of Art (BA) Eligibility: 10+2 or its equivalent or BPP from IGNOU Age: No bar Min. Duration: 3 years Max. Duration: 6 years Course Fee: (.....)
  • Ranchi Regional Study Centres
    Ranchi Regional Study Centres SL. NO. PLACE OF STUDY CENTRE SC CODE (.....)
  • Certificate in Women's Empowerment and Development
    Certificate in Women's Empowerment and Development (.....)
  • Dec 1996
    Question Paper of CS-09 - Data Communication & Network of Dec 1996 from IGNOU 1 (i) What is the difference between band width, baud (.....)
  • MBA Assignements : TMA MS - 07 Second Assignment Information Systems for Managers
    MBA Assignements : TMA MS - 07 Second Assignment Information Systems for Managers Course Code : MS-07(Revised) Course Title : Information Systems for Managers Assignment No. : 07/TMA-2/SEM-II/2004 Coverage : (.....)
  • JUN 1998
    Question Paper of CS-54 - Finance & Accounting On Computers of June 1998 from IGNOU Note : Question 1 is compulsory. Attempt any (.....)
  • BCA Assignements : TMA CS - 65 Window Programming
    BCA Assignements : TMA CS - 65 Window Programming Course Code : CS-65 Course Title : Window Programming Assignment Number : BCA(4)-65/TMA/05 Maximum Marks : 10 Last Date of Submission : 15th April, 2005 This is a Tutor Marked (.....)
  • MBA Assignements : TMA MS -21 Second Assignment - Social Processes and Behavioural Issues
    MBA Assignements : TMA MS -21 Second Assignment - Social Processes and Behavioural Issues Course Code : MS-21 (Revised) Course Title : Social Processes and Behavioural Issues Assignment No. : MS-21/TMA-2/SEM-II/2004 Coverage : Blocks 3 & 4 Note: (.....)
  • Ahmedabad Study Centre - Bhuj
    Ahmedabad Study Centre - Bhuj SC CODE - 0906 NAME & ADDRESS OF THE IGNOU STUDY CENTRE DR. N.K. GUPTA COORDINATOR, IGNOU STUDY CENTRE JB THACKER COMMERCE COLLEGE, BHUJ - (.....)
  • IGNOU Regional Centres - Raipur
    IGNOU Regional Centres - Raipur Region Code - 35 Dr. P. Ashok Kumar Regional Director IGNOU Regional Centre Rest House & E.M. Office Hall Sector I Shankar Nagar Raipur Chhattisgarh. Ph.Off 0771-2428285 / (.....)
  • Maldives - 7301
    International Partner Institutions of IGNOU in Indian Ocean Island Countries - Maldives - 7301 Maldives - 7301 Tertiary Institute Of Open Learning (TIOL) Maldives College (.....)
  • Bangalore Study Centre – Comba
    Bangalore Study Centre – Comba SC CODE - 0801 NAME & ADDRESS OF THE IGNOU STUDY CENTRE DR. I. BHANU MURTHY COORDINATOR, IGNOU STUDY CENTRE SH. DAMODAR COLL. OF COM (.....)
Tell Us in Details What You Are Looking for
Your e-mail:


Subject:


Type verification image:
verification image, type it in the box

Message:

Latest Education Alerts
All Archive Section : Alerts News 1 2 3 4 CBSE Institutions 1 2 3 4  IGNOU Symbiosis Amity Delhi University Mumbai University Syllabus Scholarship  Bussiness Schools Results Study Abroad Career Forum Archives : 1 2 3 4 Disclaimer   About Us Site Design and SEO by : MAAS InfoMedia
Site best viewed in Opera and Google Chrome browsers with 1024x768 resolution. May not be best viewed in Internet Explorer.