NORMAL FORM Normalization of Database Database Normalization is a technique of organizing the data in the database. Normalization is a systematic approach of decomposing tables to eliminate data redundancy and undesirable characteristics like insertion, updates and deletion Anomalies. It is a multi-step process that puts data into tabular form by removing duplicated data from the […]
DATA MODELLING Data modeling is a process used to define and analyze data requirements needed to support the processes within the scope of corresponding information system in an organization. Creating simple data mode Microsoft Access offers one table, queries, forms, reports, macros and modules and these will be created before creating a data model. Table:
DATA MODEL What is Data Model?. Data Model can be defined as abstract model whose purpose is to describe how data can be used and represented effectively. A data model is a picture or description which shows how data are to be arranged to serve a specific purpose it determines the structure of data and
STARTING MICROSOFT ACCESS To start Microsoft Access, follow the steps below: Click start button, the program menu Move to the MS Office menu Click on MS Access Once Access is running, an initial screen will be displayed. From the initial screen, you can either (i) create a new blank database (ii) open an existing database
DATABASE APPLICATION | MICROSOFT ACCESS Read More »
What is Word Processor? This is the act of typing, editing and printing of textual or graphical information using a word processor. Word processor is a software package used on microcomputers with processing power that allow text editing and production of report and documents. Text Document This is a written printed or online document
TRANSLATOR These are programs used in converting programs written in other languages to machine language. They are also called language processors. The computer can only execute programs written in machine codes. These codes are tedious for programmers to write; hence they prefer other languages close to human. The translators are then required to change the
UTILITY PROGRAMS AND TRANSLATORS Read More »
WORD PROCESSING – WELL EXPLAINED Word processing software is used to manipulate a text document, such as a resume or a report. You typically enter text by typing, and the software provide tools for copying, deleting various type of formatting. Word processor is an electronic device or computer software application, which performs the task of
OPERATING SYSTEM This is a set of programs which takes over the operation of the computer to the point of being able to allow a number of programs to be run on the computer without intervention by an operator. It acts as an interface between the user and the hardware. It controls and allocates hardware
COMPUTER SOFTWARE: TYPES, IMPORTANCE, FUNCTIONS AND OS Computer Software is refers to collection of programs (instructions) that cause the hardware to work. A program is a written instruction for a computer to perform a specific task. These are thousands of programs that one can run on a computer. For instance, a graphic program can be
INFORMATION TRANSMISSION PROCESS Information Transmission is the process of transferring information from one place to another. There are many ways by which information could by passed across to somebody or group of people. The major methods are: Ancient Method Modern Method Ancient Method In the olden day information could be passed from one to
PROCESS OF INFORMATION TRANSMISSION Read More »
COMPUTER STORAGE DEVICES Computer Memory This is the part of the computer where data, programs and information are stored for use of the computer. It comes in form of a chip. The basic unit for computer memory is byte. Other units are KB, MB, GB, etc. All computers have memory units. The programs a computer
COMPUTER STORAGE DEVICES Read More »
OUTPUT DEVICES These are hardware components used to obtain results from computer after processing. They convert data from machine-readable format into human readable format. Examples of output devices are monitor, printer, speaker, projector, plotter, etc. MONITOR This is an output device that displays the result of processing on the screen. It resembles a T.V set
COMPONENTS OF COMPUTER (OUTPUT DEVICES) Read More »
INPUT DEVICES These are hardware components used in entering data into the computer for processing. They convert data from human-readable form into machine readable format. They take information from the user of the computer, convert it into electronic signals and transmit it to the processor. Examples of input devices are keyboard, mouse, joystick, microphone,
COMPONENTS OF COMPUTER (INPUT DEVICES) Read More »
ICT is an acronym which stands for Information and Communication Technology. It is defined as set of technological tools and resources used to communicate,
APPLICATION OF ICT IN THE SOCIETY Read More »
NUMBER BASES CONVERSION OF OTHER BASED TO DECIMAL SYSTEM To convert numbers in other bases to denary system, expand the given number in powers of its base and evaluate. Examples 1) Convert the following numbers to base ten (i) 10012 (ii) 255eight (iii) 35416 (i) 10012 = 1 x 23 + 0 x 22 +
Computers can be classified based on the following criteria Development of technology (by generation) Principle of operation (by type) Storage capacity or by configuration (by size) Degree of versatility (by purpose) Classification by types Computers can be classified into three major types based on principles of operations. The three types are Digital computer Analog
CLASSIFICATION OF COMPUTERS Read More »
DIGITIZATION OF DATA What is Digitization of data? Digitization is the process of converting analog information into a digital format. For example, scanning of analog source like printed photos or taped text, images or videos into computers for editing. Digitizing is the primary way of storing images in a form suitable for transmission and computer
DIGITIZATION OF DATA Read More »
DATA AND INFORMATION What is data? Data refers to raw facts yet to be processed. It is a fact, number or text that can be processed by a computer. Data has no meaning to the user unless processed to get meaningful information. Source of data Data can be obtained by any one or more
DATA AND INFORMATION Read More »
GENERATIONS OF COMPUTER A generation is often referred to the state of improvement in the development of a product. Generation of computer is the advancement of computer technology from time to time. In every generation, the circuitry has become smaller and more advanced than the previous generation. Each generation of computer is characterized by a
GENERATIONS OF COMPUTER Read More »
COMPUTER ROOM AND MANAGEMENT ETHICS What is computer room? A computer room is a place where computers are kept for use. Computers need a room well ventilated and conductive for optimum performance. Types of Computer Room Computer room must be designed intelligently and serve the purpose they were intended to serve. The design and
COMPUTER ROOM AND MANAGEMENT ETHICS Read More »