Get premium membership and access revision papers, questions with answers as well as video lessons.

Database Management Systems(Dbit 221) (Dcis 200) Question Paper

Database Management Systems(Dbit 221) (Dcis 200)

Course:Computer Science & Business Information

Institution: Kenya Methodist University question papers

Exam Year:2013

TIME : 2 HOURS

INSTRUCTIONS
Answer Question one (compulsory) in Section A and any other two questions in section B.
SECTION A
Question One
Define the following terms
(6 Marks)
Database
Data independence
Entity
Differentiate between a relationship and relationship set.
(2 Marks)
A database comprises of four elements. List and explain them.
(12 Marks)
Define the four major symbols used in an ER diagram.
(4 marks)
Explain any three types of End users
(6 Marks)

SECTION B
Question Two
Define ER
(2 Marks)
List three types of cardinalities
(3 marks)
Differentiate between the main tasks carried out by the DA and the DBA.
( 10 Marks)

Question Three
Define five terms for providing security to a dbms
(5 marks)
Show the ER diagram of the following tables, student, lecturer, and course.
(10 Marks)

Question Four
Draw a diagram to show the components of a dbms.
(10 Marks)
Briefly explain the attributes of dbms components.
(5 Marks)

More Question Papers

Birs 111 : Critical And Creative Thinking

Cisy 432:Distributed Systems

Bbit 232:Database Systems

Bbit 241 Cisy 131 (Computer Networks / Telecommunication Networks)(2 Trimester 2016)

Cisy 332:Network Hardware And Configuration

Computer Networks (Bbit 241) (Cisy 131) (Dbit 223) (Dcis 121) 1St Trimester 2016

Database Management (Bbit 232) (Cisy 221) 2Nd Trimester 2015

Database Systems (Bbit 232) (Cisy 221) (Comp 340) (Bsis 115) (Dbit 221) (Dcis 106) 3Rd Trimester 2014

E-Commerce (Bbit 436) (Cisy 428) 1St Trimester 2016

E-Commerce (Bbit 436) (Cisy 428) 2Nd Trimester 2015

E-Commerce (Bbit 436) (Cisy 428) 3Rd Trimester 2015

Human Computer Interraction (Bbit 314) (Bsis 430) 2Nd Trimester 2012

Introduction To Computer Networks (Bbit 241) (Cisy 131) 2Nd Trimester 2014

Introduction To Computer Networks (Cisy 131) (Bbit 241) (Dbit 223) (Dcis 121) 2Nd Trimester 2015

Introduction To Information Systems (Bbit 111) 2Nd Trimester 2012

Introduction To Sociology (Sost 131) 1St Trimester 2015

Introduction To Sociology(Sost 131)2Nd Trimester 2016

Object Oriented Analysis And Design (Bbit 335) (Cisy 411) 3Rd Trimester 2014

Object Oriented Programming (Bbit 223) (Cisy 210) (Dcis 120) 2Nd Trimester 2014

Principles Of Marketing (Mktg 218) 2Nd Trimester 2014

Principles Of Marketing (Mktg 218) 2Nd Trimester 2017

Simulation And Modeling (Bbit 417) (Cisy 403) 3Rd Trimester 2014

System Analysis And Design(Bbit 231)( Cisy 222)( Dbit 124)( Dcis 104)2Nd Trimester 2016

Systems Analysis And Design (Bbit 231) (Cisy 221) 1St Trimester 2017

Systems Analysis And Design (Bbit 231) (Cisy 222) 1St Trimester 2015

A T R (Theo 205)

Accf 330Intermediate Accounting 1

Accf 430Financial Management Ii

Accf 431 Tax Planning And Management

Accf 432Auditing 1

Accf 434: Auditing Ii

Accommodation Management (Bhtm 308) (Bshm 212)

Accounting Information Systems (Bbit 437)

Accounting Information Systems I(Bbit 311)

Accounting Information Systems(Bbit 311)

Accounting Information Systems(Bbit 447)

Acct 010 :Principles Of Accounting

Acct 112: Principles Of Accounting 1

Acct 112: Principles Of Accounting 1

Acct 112: Principles Of Accounting 1

Acct 112: Principles Of Accounting 1

Acct 112: Principles Of Accounting 1

Acct 112: Principles Of Accounting 1

Acct 117 Principles Of Accounting Ii

Acct 219: Cost Accounting

Acct 430: Advanced Accounting 1

Acct 430Advanced Accounting I

Acct 431 :Taxation

Acct 431 :Taxation

Adult Nursing I (Nrsg 224)

Popular Exams

Mid Term Exams

End Term 1 Exams

End Term 3 Exams

Opener Exams

Full Set Exams

Return to Question Papers

Quick Links