BACHELOR IN COMPUTER APPLICATIONS
CS-06:DATABASE MANAGEMENT SYSTEM
Note : Question one is compulsory. Answer any three from the rest.
Q.1(a). Name six major components of a Data Base Management System.
(b)Define the following concepts in context of DBMS,
(i) Inverted List
(ii) Foreign Key
(iii) Referential Integrity
(c) What does ISAM stand for? Briefly describe the advantages of ISAM indexes/Indices.
(d) For the set of following two relations:
And Q :
Find out which of the following operation(s) are defined on this set of record types:
(e) Briefly describe the properties of a normalized relation.
(f) Write briefly about the advantages of Data distribution.
Data Sharing and Distributed Control
(g) Name the fundamental ideas underlying Object Oriented Technology (OOT)
(h) Briefly explain what do you understand by a Knowledge Base System.
Q2(a). Explain briefly the levels of an architecture of a DBMS. Viz., Internal level. Conceptual level and External level.
(b) Draw E-R diagram for any one of the following two organization viz., (i) Public Library, (ii) Hospital, after determining the entities of interest and the relationship that exist between these entities.
(c) Define the following terms:
Below is the Diagrammatic Representation of Specialization and Generalization : -
--DIAGRAM IS NOT AVAILABLE--
Q.3(a). Draw diagrammatic representation of a university, which runs a number of program say Pj.....Pm ; The program P; hasnj course Cjj of Pj for each I is pursued by a set Sjj of students. The diagrammatic representation is to reflect the hierarchical structure of the university system.
(b) Given the relational schemes:
ENROLL (S#, C#, Section)
TEACH (Prof, C#, Section)
ADVISE (Prof, S#)
PRE_REQ (C#, Pre_C#)
GRADES (S#, C#, Grade, Year)
STUDENT (S#, Sname)
Where S#, C# represent respectively ’student number’ and ‘course number’: Sname is student name. Prof is thesis advisor of S# in ADVISE, Pre_C# is prerequisite course.
Express the following queries in relational algebra :
(i) List all student taking courses with Mr. Ram and Mr Abdul.
(ii) List all those professors who teach more than one section of the same course.
(c) What are the essential components of a DBMS?
Q.4(a). For the following record type, tell whether it is Third Normal From or Not: EMPLOYEE (Employee- Code, Employee-name, department, salary, project-no., Termination-date-of-project)
Where each project-no has unique Termination-Date-of-Project. Justify your answer, if it is in third normal form. It is not in third normal form, being it into third normal form through normalization.
(b)Consider the record-types given below:
SUPPLIER : S# SNAME SCITY TURNOVER
PARTS : P# WEIGHT COLOUR COST SELLING PRICE
SUPPLY PARTS : P# QUANTITY
Where S# and P# are keys respectively for SUPPLIER and PARTS. Express the following in SQL
(i) Get the part numbers weighting between 25 and 35
(ii) Get the supplier names (SJVAME) who are located in the city of Hyderabad.
(iii) Get the names of suppliers who supply at least one part of red colour
(iv) Delete all the suppliers involving red colored parts.
Q.5(a). Briefly discuss the alternative Object-Oriented Database strategies.
(b) Briefly explain, the main features of client/server computing.
(c) Explain briefly, with atleast one suitable example any one of the following knowledge representation schemes.
(i) Semantic Nets
(ii) Frame Based
Q.6(a). Discuss main difference between Relational database Management system and Object oriented database management system.
(b) Discuss the following with reference to distributed computing environment
(i) Remote Procedure Call
(ii) Object Linking and Embedding.
(c) Explain the steps required for client server application development.