CS-06 Data Base Management System June-2001
Q.3(a). The People’s Bank others five types of accounts: loan, checking, premium savings, daily interest saving and money market It operates a number Of branches, and a client of the bank can have any number of accounts. Accounts can be joint; i.e. more than one client may be able to operate a given account Draw a diagrammatic representation of the Network model of the bank, after identifying the relevant concepts.
(b) In respect of project we are given the following record-types for the rela�tional model of the database:
EMPLOYEE: with fields as ‘Emp#’ and ‘Name’
ASSIGNEDJTO: with fields as ‘Projects and ‘Emp#’
PROJECT: with fields and ‘Projects, ‘Project_Name’, ‘Chief_Architect’.
Where ‘Chief_Architect’ is a three-digit code and all other fields have obvious meanings. Then express the following queries in relational algebra:
(i) ‘Get Emp# of employees working on project COMP353′
(ii) ‘Get details of employees (both number and name 3) working on project COMP353′
(iii) ‘Gather details of employees working on both COMP353 and COMP354′
© Briefly describe the various possible problems with a (not normalised) data�base.