MINISTRY OF HEALTH

TECHNICIAN CERTIFICATE IN PHYSIOTHERAPY

NTA LEVEL 5
CONTINUOUS ASSESSMENT TEST II -SEMESTER II(CAT II)
MODULE CODE: PT 05213
MODULE NAME: DATABASE APPLICATION
AUGUST, 2024

MARKING SCHEME
TIME: 2:00 HOURS DATE:…………………
GENERAL INSTRUCTIONS
1. Read all instructions carefully.
2. Cellular phones and unauthorized materials are NOT allowed in the examination room.
3. Attempt all questions.
4. This paper consists of five (5) sections namely A, B, C, D and E
5. Write your examination number on each page of the answer sheet you use.
6. Each essay question to be answered on not more than 3 hand-written papers
The table below is for OFFICIAL USE ONLY
SECTION TYPE OF QUESTIONS ALLOCATE SCORED INITIAL INITIAL
D MARKS MARKS SIGNATURE SIGNATURE
OF OF
MARKER VERIFIER

A MULTIPLE CHOICE 10

B MULTIPLE TRUE/FALSE 10

C MATCHING ITEMS 10

D SHORT ANSWER 40
QUESTIONS
E GUIDED ESSAY 30

TOTAL 100

TIME: 2:00HOURS DATE……………………….

GENERAL INSTRUCTIONS:
 Answer all questions
 Kindly observer all examination procedure
  This exam has got three sections A, B, C, D & E

SECTION A: MULTIPLE CHOICE QUESTIONS

(i) Tree structure database is also called

A. Plex Structure database
B. Normalize Structure database
C. Hierarchical database C
D. Table structure database
E. File database

(ii) A type of database in which stores data in the form of rows and columns;
A. Flat file database
B. Network database
C. Relational Database
D. waterfall database C
E. Structured database

(iii) Which of the following is not the reasons for establishing database;
A. Efficient retrieval of data
B. Reliable storage of data
C. Organization of data
D. Data Insertion
E. Sharing data
D
(iv) Which of the following is a component of database;
A. Related data
B. Hardware
C. Database
D. computer B
E. Smartphone
(v) “parent-children relationship nodes.” Used in :
A. string data in database
B. centralized database
C. network database
D. Hierarchical database
D
E. Binary data

(vi) Function of DBMS in a database.

A. Software package for data
B. Retriever of data
C. Designer of Data B
D. Magnifier of Data
E. Pressing primarily data of single person.

(vii) Directories
A. having built in Database
B. A human powered search engine
C. Specialty search engine
B
 D. An Operating System
E. An application programs

(viii) Flat file database is ;

A. An Application Program.
B. An Adjacency searching of Data
C. Also known as text database
D. Used to Store data in a table and column. C
E. A Truncation and wildcards data

(ix) Application programs and operating system are part of :-

A. Database Administrator
B. Wikipedia
C. Bridge
D. Machine
E. Database Application programs
E
(x) Hybrids.
A. description of Data
B. Commercial Database
C. A mix of crawlers directories
D. NoSQL Database
C
E. Mixed Database.

SECTION B: MULTIPLE TRUE/FALSE QUESTIONS

Instruction
Write the word “TRUE” for a correct statement and the word ” FALSE” for incorrect statement in the
space provided before each options

1. There are many databases available like

(i) Oracle TRUE
(ii) MySQL TRUE
(iii)Google DBM FALSE
(iv) Sybase TRUE
(v)MangoDB FALSE

2. The following is a component of databases

(i) Related data FALSE
(ii) Hardware TRUE
(iii) Data TRUE
(iv) Database FALSE
(v) MySQL FALSE
3. One of the following is an example of physiotherapy database;
(i) Physiopedia FALSE
(ii) HINARI TRUE
(iii) Physiomedicine DB FALSE
(iv) PubMed TRUE
(v) PEDro TRUE

4. Atomicity property is having the following tips

(i) Operation will complete either with success or with failure TRUE
(ii) Relational database FALSE
(iii) each Atom contains a primary key FALSE
(iv) All or Total Nothing TRUE
(iv) Each atom contains a foreign key FALSE

5. File system consist of different types of files like the following;

(ii) PDF TRUE
(iii) PPT TRUE
(iv) TEXT TRUE
(v) NTFS FALSE

SECTION C: MATCHING ITEMS (10 MARKS)

 This section consist of 2 questions
 match the items from column B with those in column A by writing the letter of correct response
in space provided.
 Each correct answer is awarded 1 mark
 Each items from column B is used once

COLUMN A (TERMS) COLUMN B (EXPLANATION)

(i) Adjacency Search A. To narrow your results
(ii) Crawlers B. Search a word by placing a symbol at the end of the word
(iii) Truncation C. search by citations
(iv) Using AND D. search by using key words
(v) Using NOT E. connect search together to either narrow or broaden your results
F. search by phrase
G. To broaden your results
H . To Exclude word from your results
I. Google robots

i ii iii iv v
F I B A H
COLUMN A (DBMS COLUMN B (EXPLANATION)
CONCEPTS)
(i) Search Engine A. Nodes interconnected by communication path
(ii) DBMS B. Data structure that store organized record that can be Processed to useful
(iii) Ranking In-formations.
(iv) Primary Key C. key that can be easily manipulated
(v) Network D. Support large amounts of data
E. Help to rank object from highest to lowest
F. Software that allow users to define, create, Maintain and control access
to the database
G. Unique key
H. A tool that Search for result in it’s Database on the search query
I. Arrangement of objects from lowest to highest

i ii iii iv v
H F I G A

SECTION D: SHORT ANSWERS QUESTIONS (40 marks)

4. Mention five (5) types of operating systems
1. Batch Operating System
2. Multitasking/Time Sharing OS
3. Multiprocessing OS
4. Real Time OS
5. Distributed OS
6. Network OS
7. Mobile OS

5. Mention 4 advantages of using operating system

1. Allows you to hide details of hardware by creating an abstraction
2. Easy to use with a GUI
3. Offers an environment in which a user may execute programs/applicatio
4. The operating system must make sure that the computer system convenient to use
5. Operating System acts as an intermediary among applications and the hardware
components
6. It provides the computer system resources with easy to use format
7. Acts as an intermediator between all hardware's and software's of the system

6. Mention 4 types of computer network

a) Computer network
- refers to interconnected computing devices that can exchange data and share
resources with each other.
 1. Personal area Network (PAN)
2. Local Area Network (LAN)
3. Metropolitan Area Network (MAN)
4. Wide Area Network (WAN)

7. Mention five (5) essential component of computer network

1. Switches
2. Routers
3. Servers
4. Clients
5. Transmission Media
6. Access Point
7. Shared Data
8. Network Interface Card
9. Network Operating system
10. Local Operating System
11. Protocal
12. Hub
13. IP Address
14. MAC Address

8. List five (5) Search Strategies.

1. Choosing search terms
2. Searching with keywords
3. Searching for exact phrase
4. Using truncated and wildcard searches
5. Using Boolean Logic
6. Citation searching

9. List five (5) output of Logical database design

1. E-R Diagrams
2. Class Diagrams
3. State transition diagrams
4. Sequence diagrams
5. Object interaction diagram

10. Mention five (5) physiotherapy database that you know

1. CINAHL
2. PEDRO
3. PUBMED
4. COCHRANE LIBRARY
5. AMED
6. SPORTDiscus
7. Evidence based search
11. list five (5) areas where DBMS can be applied
1. Banking systems
2. Telecommunication
3. E- commerce
4. Health care
5. Education

SECTION E: GUIDED ESSAY QUESTIONS (30 marks)

 This section consists of three (3) questions which are supposed to be answered in a narrative
way
 Bulleting and numbering is NOT ALLOWED.
 Write your answer on the empty pages of this question paper
 Each question has 10 marks if done correctly.
 Each question should start on a new page

11. (a) Explain five (5) Limitation of File-based system

is an early method of managing and organizing data, where data is stored in separate files
within the file system of an operating system
the following are the limitations of file-based system
Separation and isolation of data
Each program maintains its own set of data.
Users of one program may be unaware of potentially useful data held by other programs.
Duplication of data
Same data is held by different programs.
Wasted space and potentially different values and/or different formats for the same item.
Time consuming
In order to get a certain information some times you have to compile data from different sources
or program.
Data dependence
File structure is defined in the program code.
Change in file data’s characteristics requires modification of data access programs.
Must tell program what to do and how
Makes file systems cumbersome from programming and data management views.
Incompatible file formats
Programs are written in different languages, and so cannot easily access each others files.
Fixed Queries/Proliferation of application programs
Programs are written to satisfy particular functions. Any new requirement needs a new program.
Data Redundancy
Some data may be missed from other program or on the same source.
Limited data sharing
It limit sharing of data among users.

12. (a) Explain the Advantages and disadvantages of computer network

- refers to interconnected computing devices that can exchange data and share
resources with each other.
The following are the advantages of computer network
Convenient Sharing of Resources:
Vast amounts of data production by large organizations can be a useful resource for current and future
endeavors. Within these organizations, computer networks share resources, enabling effective data
interchange and collaboration. This functionality is crucial for optimizing daily operations and ensuring
that resources are available in several industries, including education, transportation, and hospitality.

Easy File/Data Sharing:

The sharing of files and data sets is the most vital feature of a computer network. The computer present
during the initial stages didn't even have this file-sharing feature. Now, with constant advancements,
this feature has not only been present in the computer network but has also become much easier. Many
industries and organizations are using computer networks for their operations, and computer networks
have made information sharing easier because such organizations run on their data. It is very important
to get such data to be transferred efficiently. Computer networks also save a lot of time, and it has been
proven monetarily beneficial in the long run.

Highly Flexible:
To accommodate consumers' changing requirements, modern technology must be adaptive and flexible.
In this sense, computer networks shine, providing a variety of capabilities to accommodate users'
desires for mobile and distant access. Because of their adaptability, computer networks have become a
crucial part of our daily lives, boosting connectedness and ease

The following are the disadvantages of computer network

Security Vulnerabilities:
Computer networks are widely used, which poses security issues. Hackers and cybercriminals can use
network flaws to access confidential data, resulting in privacy violations and data theft. It is
challenging to stop unauthorized access and malicious activity due to the complexity of monitoring and
protecting network operations worldwide.

Lacks Robustness:
The system of computer networks across the globe is connected to a singular primary server located at
a fixed location. It runs most of the time smoothly, but in case of a malfunction, the whole will go into
a blackout, and all the operations will shut down. To fix this problem, all these huge networks that
connect many devices should have a very advanced computer that can serve as the server of the files.
This procedure can make network maintenance easier and more frequent, and the risk of facing a total
blackout decreases.
Bandwidth Limitations:
Users share a limited amount of bandwidth on the Internet and in other networks. Large file transfers or
streaming videos can cause a lot of network traffic, which can cause congestion and poor network
performance. This may lead to irritating data transmission delays and decreased internet connections.

Costly Infrastructure Investment:

A large initial investment in hardware, software, and qualified staff is needed to establish and maintain
a reliable computer network. Establishing and maintaining an effective network infrastructure could be
expensive for small firms and organizations with tight finances.
Privacy Concerns:
Data sharing across computer networks frequently involves private and delicate information. There are
several worries regarding data privacy and unauthorized access to personal information. Even with
security precautions in place, there is always a chance that sensitive data could be exposed through data
breaches.

13. (a) Explain the importance of Search Engines

Search Engine is a tool that search for results in its database based on the search query which is
submitted by the user

The following are the importance of search Engine

Information Access: Search engines provide quick access to vast amounts of information, enabling
users to find relevant data on almost any topic within seconds.

Efficient Navigation: They help users navigate the web efficiently by indexing and organizing web
content, making it easier to find specific websites, articles, or resources.

Data Management: Search engines manage and organize massive amounts of data from across the
web, ensuring that it is indexed, stored, and retrievable for users when needed.

Filtering and Sorting: Search engines filter and sort search results based on relevance, freshness,
location, and other criteria, allowing users to find the most pertinent information quickly.

Ranking: They rank search results using complex algorithms, ensuring that the most authoritative,
relevant, and high-quality content appears at the top, enhancing the user's search experience.

Business Visibility: Search engines are crucial for businesses to gain visibility online, helping them
reach potential customers through search engine optimization (SEO) and advertising.

Content Discovery: They aid in the discovery of new content, such as news articles, blogs, videos, and
other media, allowing users to stay informed and entertained.

Personalization: Modern search engines offer personalized results based on user behavior, location, and
preferences, making the search experience more relevant and tailored to individual needs.