Answer any four (4) questions
(1a) Define Database management System (DBMS) 5 marks
(b) Explain the difference between logical and physical independence 10 marks
(c) Explain five (5) on responsibilities of a DBA 5 marks
(2a) Define Data Independe
Why would you choose a database system instead of simply storing data
in operating system files? When would it make sense not to use a database system?
A database is an integrated collection of data, usually so large that it
Domain Constraints specifies that what set of values an attribute can take. Value of each attribute
X must be an atomic value from the domain of X.
The data type associated with domains include integer, character, string, date, time, c
1. Write short notes on: (a) Application Areas supercomputers
(b) Techniques used in B.W matching of a
2.Finer the grain size, the higher the potential for parallelism, but
higher the communication and scheduling overhead. Justify this
Logical database modeling is mainly for gathering information about
business needs and does not involve designing a database; whereas physical
database modeling is mainly required for actual designing of the database.