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

Database Management Systems (Dcis 200) Question Paper

Database Management Systems (Dcis 200)

Course:Computer Science And Business

Institution: Kenya Methodist University question papers

Exam Year:2012

TIME : 2 HOURS

Instructions:
Answer all questions in section A and any other two in section B.
SECTION A
Question One
Define the following terms
Database
Database management system
Primary key
DML
Explain any four reasons you would advance to an organization in order to encourage them to automate their database management process. (5mks)
Explain the concept of normalization and highlight its main goal and benefit in database design.
(4mks)
Briefly describe the role of the following people
Database designer
Database administrator
Database user
Highlight four challenges that may be encountered as a result of poor database design.
(4mks)

SECTION B
Question Two
Define the term database management system.
(3mks)
Explain any four parts of a database management system environment.
(12mks)

Question Three
Define the term entity relationship model.
(2mks)
Explain the relationship between entity relationship model and the design of relational databases.
(8mks)
Using the examples of student and book as entities of a system show the attributes of each and give a primary key for each.
(5mks)

Question Four
Why is it necessary to specify data types during database design? (4mks)
Suggest suitable data type for the following attributes as maybe used in Microsoft access.
Name
Age
Date of birth
Marital status
Address
(5mks)
State any three main roles of a database administrator and show what these roles entail.
(6mk)

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