Scribd
Upload
4 views1 page

Manage Database Assignment

Uploaded by

musyokivincent582
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views1 page

Manage Database Assignment

Uploaded by

musyokivincent582
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

MANAGE DATABASE MANAGEMENT SYSTEMS

ASSIGNMENT

CS6 S25 A MOD 3/ ICT5/6 M25

INSTRUCTIONS: Answer ALL questions. (8/06/2026)

1. Differentiate clearly between the following terms: (2 Marks)


a) Database and DBMS
b) Schema and Instance
2. State six (6) disadvantages of the traditional file processing system. (6 Marks)
3. Explain six (6) functions of a Database Management System. (6 Marks)
4. Define the following terms as used in DBMS: (3 Marks)
a) Candidate key
b) Composite key
c) Super key
5. A STUDENT table contains the following fields:
RegNo, Name, Phone, CourseCode, CourseName, DeptName, DeptHead
Identify six (6) possible anomalies that may arise in this table. (3 Marks)
6. Explain the three (3) levels of the ANSI/SPARC architecture and show how they
support data independence. (3 Marks)
7. State and explain three (3) differences between: (3 Marks)
a) Centralized databases and Distributed databases
8. Explain the following transaction properties (ACID): (4 Marks)
a) Atomicity
b) Consistency
c) Isolation
d) Durability

You might also like