Database for JSS3

-







Database for JSS3

Definition of Database

1. A database is a collection of data organized in a manner that allows access, retrieval and uses of data.
2. A database is a collection of information that is organized so that it can easily be accessed, managed, and updated.
3. A database is an organized collection of data.
In a manual database, data can be recorded on paper and stored in a filing cabinet. While in a computerized database, it is stored in an electronic format on a storage media.
DBMS (Data Base Management System) is the application software that controls the data in the database. Examples of DBMS packages are: Dbase, Rbase, MS Access, Oracle, Paradox, SQL Server, SyBase, FOXPRO, IDMS, and System 2000.

Database Terminologies

1. Field: Field is a single piece of information about and object. A is also defined as a space that holds specific parts of data from a set or a record. Examples of fields are NAME, ADDRESS, QUANTITY, AGE, etc.
2. Record: A record is a collection of fields. It is the collection of information of a particular element, person or object.
3. File: This is the collection of related record
4. Database: Group of related record
5. Primary Key: a field in a table whose value is uniquely identifies each record in the table.
Forms of Database
1. Flat file: This type of database consists of table that is not complex to understand. This type of database can only handle single table database
2. Hierarchical Database: in this form of database, data are arranged or structured in form of a tree. . It can also be defined as a design that uses a one-to-many relationship for data elements. The data is stored as records are connected to one another through links
3. Network Model: This type of database allows the modeling of many-to-many relationship of data. In the network model of a database it is possible for a record to have multiple parents, making the system more flexible compared to the strict single parents of the hierarchical database.
4. Relational Model: A relational database is one that presents information in tables with rows and columns. Records are arranged in rows while fields are arranged in columns. Relational database is the most common type of database structure. It is used by most microcomputers.


Database Management System (DBMS) packages.
To start database in Microsoft Access, you do the following:
Step1: Click on the start button on the taskbar
Step 2: Move to all Programs,
Step 3: Click on MS Access
To open an existing Database, do the following:
Step 1: Click on file menu, then click open button
Step 2: Click on the file to be opened from the dialogue box.
Step 3: Then click on open or press enter on your keyboard.

Comments

Post a Comment

Popular posts from this blog

BASIC Programming Language for SS1

-
Image
BASIC Programming Language for SS1 BASIC stands for Beginners All-purposed Symbolic Instruction Code. It was developed in 1964 by Professor John Kemeny and Thomas Kurtz to teach students at Dartmouth College. It has undergone series of historical development, which has resulted in several forms of the language. Versions of BASIC 1. BASICA 2. GWBASIC 3. Torbo BASIC 4. Quick BASIC 5. VB.NET BASIC CHARACTER SET 1. Alphabetic Characters – A to Z 2. Numeric Character – 0 to 9 3. Special Characters – 0 + % ^ # = ( ) etc BASIC VARIABLES A variable is a quantity that changes during the execution of a program. It can also be defined as a name that is used to represent some storage location. Types of Variable 1. Numeric Variables : These are used to store numeric values such as 23, 98, etc. There are two major types of numeric variables, which are; Integer variable and real variable a. Integers are whole numbers without decimal places. b. Real numbers are numbers with decimal places Hence Integ
Read more

Computer Ethics for JSS 2

-
Image
Computer Ethics for JSS 2 Definition of Computer Ethics Ethics is a set of moral principles that govern the behavior of a group or individual. Computer ethics can be defined as the set of moral principles that regulate the use of computers. Responsible use of Computer and Internet The following are the basic security measures taken to prevent damage to computer system. 1. There must be adequate ventilation. 2. Adequate space must be allowed between each system unit. 3. Avoid dust by using cover. 4. Avoid moisture. 5. Provision of air conditioners and fans or other cooling machines. 6. Provision of UPS (Uninterruptible Power Supply) and other electrical appliances to avoid loss of information and electrical damage to the system. 7. Adequate care must be taken to storage devices like diskettes, flash drive, CD/DVD writer drive, etc. 8. Disallow an unauthorized user from having access to your computer. 9. Ensure maximum security to files and information on the computer. 10. Provide comput
Read more

Computing Devices I ( Pre-Computer to 19th Century) for SS1

-
Image
Computing Devices I ( Pre-Computer to 19th Century) for SS1 Man has put every effort to have better method of calculations. As a result of man’s search for fast and accurate calculating devices, the computer was developed. 19 th Century Device Some of the 19 th century devices are: Abacus, Napier’s bones, Pascal’s calculator, Leibniz multiplier Jacquard’s Loom, Charles Babbage’s engine, Hollerith Census machine and Borrough’s machine. Abacus The first calculating device was probably the Abacus. The Chinese invented it. Components: It is made up of frame divided into two parts by a horizontal bar and vertical threads. Each thread contains some beads. It is known as Soroban in Japan and Suan Pan in china. Uses : to do simple addition and subtraction Napier’s Bone : In 1617 an eccentric (peculiar, unusual person) Scotsman mathematician named John Napier invented Logarithm which is a technology that allows multiplication to be performed via addition. Components : A set of eleven rods, wit
Read more