COMPUTER STUDIES QUESTIONS WITH ANSWERS
What is relational database?
This is a database where records are structured within tables (relations)
A relational database is a type of database that stores and provides access to data points that are related to one another.
Relational databases are based on the relational model, an intuitive, straightforward way of representing data in tables. In a relational database, each row in the table is a record with a unique ID called the key. The columns of the table hold attributes of the data, and each record usually has a value for each attribute, making it easy to establish the relationships among data points.
0 Comments
Types of graphs that are supported by spreadsheets
Worksheet cells are referenced using the column letter and row number e.g. D2 is cell in column D and row 2.
a) Write down the data type that is stored in cell C5 (1mk)
b) What cell contains the data items representing transport for the month of February?
c) Write down the formula that may be used to compute the total in cell f6.
Features of word processor
There are two categories of word processor features namely:
DEFINE THE FOLLOWING TERMS; 1)FILE; 2) RECORD; 3) FIELD
A file, record and a field are database terms used especially when dealing with tables.
What is a file
A file is a collection of records, database files organize the data into records and fields.
Definition of Normalization
Normalization is the process of organizing data in a database by establishing relationships between tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency, insertion anomaly, update anomaly & deletion anomaly.
Operational Methods of an Organization Ensuring the Safety of Data01. USE OF PASSWORDS AND PIN NUMBERS
A password is a secret code provided to a system to access its resources. Passwords and pin numbers are provided to an individual to deter any unauthorized access.
02. USER ACCESS LEVEL
This is a process by which the system administrator gives separate accounts with different access rights for each user to protect sensitive data from unwanted audience. Each user in the system is given a set of resources to access the system depending on his/her nature of the job he does. In most cases, the top management are given access to confidential data and employees are given access to filtered and limited data.
03. USING FILE ATTRIBUTES SUCH AS READ ONLY, HIDING ETC.
Most systems provide features such as hiding data or changing file properties to Read Only. This move ensures that original files are not tampered with or altered to change meaning.
A spreadsheet has the following entries. Provide a formula for cell c5 that can be copied onto cell d5 and the range c6...d10 to give a uniform increase of 10% of the previous years value for each item. Expected responseBriefly explain the following terms: Cell, Range, Label, Value, FunctionExpected Response
|
Categories
All
Archives
December 2024
|
We Would Love to Have You Visit Soon! |
Hours24 HR Service
|
Telephone0728 450425
|
|
8-4-4 materialsLevels
Subjects
|
cbc materialsE.C.D.E
Lower Primary
Upper Primary
Lower Secondary
Upper Secondary
|
teacher support
Other Blogs
|