ict

Question 1

what does html mean?

Answer 1

Hypertext Markup Language

Question 2

WHAT IS DBMS?

Answer 2

A Database Management System (DBMS) is software designed to store, retrieve, define, and manage data in a database.

Question 3

WHAT ARE DBMS OBJECTS?

Answer 3

A database object in a relational database is a data structure used to either store or reference data. The most common object that people interact with is the table. Other objects are indexes, stored procedures, sequences, views and many more.

Question 4

WHAT ARE EXAMPLES OF DBMS OBJECTS?

Answer 4

view, 
sequence,
 index, 
Table 
synonym

Question 5

WHAT IS A DATABASE?

Answer 5

It is an organized collection of related data that is stored and convenient to use and access.

Question 6

what is a primary key?

Answer 6

The primary key is a column or set of columns whose value uniquely identify each row in the table.

Question 7

what is a database made of?

Answer 7

Databases are made up of files

Question 8

what are files made of?

Answer 8

Files are made up of records

Question 9

what are records made of?

Answer 9

Records are made up of data fields

Question 10

what is a cell?

Answer 10

An intersection of a row and column

Question 11

what are the types of database?

Answer 11

FLAT FILE DATABASE

RELATIONAL DATABASE

Question 12

what is a flat file database?

Answer 12

It is a type of database where all the data is stored in one table. They can be created spreadsheet, text file or using a database software. They are simple and effective for organizing small amounts of data.

Question 13

what is a relational database?

Answer 13

It is a type of database where large amounts of data are stored in more than one table. It eliminates repetition, saves storage space, reduces errors, speeds up data entry and enables changes to be made quickly, are several tables grouped together to from a link, thus preventing unnecessary repetition of data.

Question 14

what are flat file databases not suitable?

Answer 14

However, they are not suitable for large amounts of data with multiple data types in it.

Question 15

what is used to avoid repetition and distinguish records with the same or similar details in html?

Answer 15

a primary key is used

Question 16

what are characteristics of a relational database?

Answer 16

Complex queries can be carried out
Better security
Cater for future requirements
Data is only stored once
Require more planning

Question 17

what are characteristics of a flat file database?

Answer 17

Poor at complex queries
Poor at limiting access
Harder to update, so inherently inefficient
Potential duplication
Easy to design
Non-unique records
Harder to change data format.

Question 18

what are the differences of a flat file database and relational database?

Answer 18

The difference between a flat file and a relational database is that a flat file only uses one table to show all the records belonging to the owner/organization.

Question 19

what are the types of data?

Answer 19

ALPHANUMERIC
NUMERIC
DATA/TIME
TEXT 
BOOLEAN

Question 20

What are the two types of data entry in form design?

Answer 20

Paper based/Hardcopy form

Screen input or Electronic form

Question 21

what are the guidelines for form design?

Answer 21

Make forms easy to fill in.
Ensure that forms meet the purpose for which they are designed.
Design forms to ensure accurate completion.
Keep forms attractive and user friendly.

Question 22

what are the 7 sections in a form?

Answer 22

Heading.
Identification and access.
Instructions.
Body.
Signature and verification.
Totals.
Comments.

Question 23

what are the features of a screen input form?

Answer 23

A consistent layout of fieldnames and enough data entry spaces.
Clear and legible font style 
Sufficient spaces for data entry
It should have a title and a key field 
Contrasting Background
Navigational tools