BCA IGNOU

Pages (1) : [1]



CS-06 Data Base Management System Dec-2003

Filed under:

Question Paper of CS-06 Data Base Management System Dec-2003

Q.l(a). Construct an ER diagram (including important attributes) for a car insurance database that includes data about customer (car owners), cars accidents, drivers involved in accidents and injured drivers and/or passengers. Note that any customer can insure many cars, each car may have different drivers at different times and accidents typically involve one or more cars.

(b) Explain the 3 levels of the database architecture. Also discuss the advantages of having the 3 levels.

© What are functional dependencies? With a suitable example explain the importance of functional dependencies in database design and data modelling.

(d) Discuss the Boyce-Codd Normal Form (BCNF) with the help of an example.

Pages: 1 2 3 4 5 6

CS-06 Data Base Management System Dec- 2002

Filed under:

Question Paper of CS-06 Data Base Management System Dec- 2002

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

(b) Describe the following relational operators with examples:
(i) UNION
(ii) DIFFERENCE
(iii) INTERSECTION
(iv) CARTESIAN PRODUCT
(v) PROJECTION

© Write short notes on the following:
(i) Distributed databases

(ii) Object Oriented databases

(iii) Data Redundancy

(iv) Query Processor

(d) Explain the difference between the physical and logical data independence.

Pages: 1 2 3 4 5 6


Courses Offered by IGNOU

School of Computer and Information Sciences (SOCIS)
Master of Computer Applications (MCA)
Bachelor of Computer Applications (BCA)
Bachelor of Information Technology (BIT)
Advanced Diploma in Information Technology (ADIT)
Certificate in Computing (CIC)

School of Humanities
M.A.English (MEG)
M.A.Hindi (MHD)
BA English
BA Hindi
Postgraduate Diploma in Radio Prasran (PGDRP)
Postgraduate Diploma in Translation (PGDT)
Diploma in Creative Writing in English (DCE)
Postgraduate Certificate in Television Writing (PGCTW)
Postgraduate Certificate in Copyediting and Proofreading (PGCCP)
Certificate in the Teaching of English (CTE)

School of Education
Doctor of Philosophy (Ph.D.) (Phase-I)
Post Graduate Diploma in Higher Education (PGDHE)
Bachelor of Education (B.Ed)
Diploma in Primary Education (DPE)
CIG
Certificate in Primary Education (CPE)
Master of Arts (Education)
Post Graduate Diploma in Educational Technology (PGDET)
Post Graduate Diploma in School Leadership and Management (PGDSLM)

School of Continuing Education
Bachelor in Social Work (BSW)
Postgraduate Diploma in Rural Development (PGDRD)
Diploma in HIV & Family Education (DAFE)
Certificate in HIV & Family Education (CAFÉ)
Certificate Programme in Rural Development (CRD)
Elective in Rural Development
Diploma in Nutrition and Health Education (DNHE)
Diploma in Early Childhood Care and Education (DECE)
Certificate in Food and Nutrition (CFN)
Certificate Programme in Nutrition and Childcare (CNCC)
Application Oriented Courses for BDP
Postgraduate Diploma in Journalism and Mass Communication (PGDJMC)
Post Graduate Diploma in Audio Programme Production (PGDAPP)
Certificate in Food Safety (CFS)
M.A. in Rural Development, M.A.(RD)
Master's of Science Degree in Dietetics and Food Service Management {MSc. (DFSM) }
Application Oriented Courses for BDP

School of Health Sciences
Post Basic Bachelor of Sciences in Nursing
Post Graduate Diploma in Maternal & Child Health
Post Graduate Diploma in Hospital and Health Management
Post Graduate Certificate in Rural Surgery
Post Graduate Diploma in Geriatric Medicine
Certificate in Health and Environment
Certificate in Health Care Waste Management
Post Graduate Diploma in Community Cardiology

School of Sciences
Bachelor of Science (B.Sc.) Programme
Certficate Programme Teaching of Primary School Mathematics (CTPM)
Certificate Programme in Laboratory Techniques (CPLT)
Post Graduate Diploma in Intellectal Property Rights (PGDIPR)
Post Graduate Diploma in Environment and Sustainable Devlopment
Appreciation Course On Environment
Awareness Course On Intellectual Property Rights
Programme Under Development