CIT427 : DATABASE SYSTEMS AND MANAGEMENT (2014)

NATIONAL OPEN UNIVERSITY OF NIGERIA

14/16 AHMADU BELLO WAY, VICTORIA ISLAND, LAGOS

SCHOOL OF SCIENCE AND TECHNOLOGY

MARCH/APRIL 2014 EXAMINATION

COURSE CODE: CIT 427

COURSE TITLE: DATABASE SYSTEMS AND MANAGEMENT

TIME ALLOWED: 3HOURS

INSTRUCTION: ANSWER ANY FIVE (5) QUESTIONS.

QUESTIONS

1a. State the main function and example of the following predefined internal entities:

i. &lt

ii. &gt

iii. &amp

iv. &apos

v. &quot

(2 marks each, =10 marks)

1b. Who is a database administrator? (4 marks)

[Total = 14 marks]

2a. By means of a well-labelled diagram, explain how weather information can be accessed by means of Web services. (10 marks)

2b. Describe where and how security is maintained in a database. (4 marks)

[Total = 14 marks]

3a. List and explain five duties of a database administrator. (10 marks)

3b. Data manipulation can be described in four (4) different ways, write down these ways. (4 marks)

[Total = 14 marks]

4. Go through the code below carefully and answer the questions that follow:

<?xml version=”1.0″?>

<freshplay>

<burns>Say <quote>goodday</quote>,

Nasiru.</burns>

<allen><quote>Ekaro,

Nasiru.</quote></allen>

<applause/>

</freshplay>

4a. What sort of processing instruction is depicted above (4 marks)

4b. Specify the main role of this instruction (6 marks)

4c. Identify and write the empty element in this instruction (4 marks)

[Total = 14 marks]

5a. Write two (2) main functions of the check clause. (5 marks)

5b. Distinguish between a domain constraint and a key constraint. (5 marks)

5c. Specify two (2) modes of inserting data into a relation. (4 marks)

[Total = 14 marks]

6a. State the three (3) main components of an SQL expression. (6 marks)

6b. If a section in a shop is denoted by g, write the expression to find the names of all sections in that shop relation. (4 marks)

6c. Give four (4) reasons why the data definition language is vital in databases. (4 marks)

[Total = 14 marks]

7a. Give a brief explanation of the following attributes:

1. Entity or Entities )
2. ID ) (2 marks each, =6 marks)
3. NMTOKEN or NMTOKENS )

7b. Write down the four (4) main components of an entity-relationship diagram with their corresponding roles (8 marks)

[Total = 14 marks]

For the 2015 – till date past questions for this course CLICK HERE

Contact me for your TMA, GST302 Business plan writeup, Project Writeup and also get your Exam Summary for this course.