Introduction To Database

Question 1

It is a Collection of information that is organize

Answer 1

Database

Question 2

Give some example of commonly used database

Answer 2

•Address book
•Library catalogue
•Telephone directory
•Stock list

Question 3

Give some example of the sort of information that can be kept in a database

Answer 3

•Inventory Control
•Payroll system
•Personnel

Question 4

Give some of the popular relational database management system

Answer 4

•Microsoft access
•File Maker
•mySQL
•Oracle
•Microsoft mySQL server

Question 5

Advantages of database

Answer 5

•Improved Availability
•Minimized Redundancy
•Accuracy
•Program and file consistency
•User friendly
•Improved Security

Question 6

It is responsible for strong data in the database,
Database tables cnsists of rows (record) and columns (fields)

Answer 6

Table

Question 7

It is a named of unit of information

Answer 7

Field

Question 8

A discrete piece of information that is part of a record

Answer 8

Field

Question 9

It is a group of fields within a table that are relevant to a specific entity

Answer 9

Record

Question 10

A row in a table that contains information about a particular person, place or thing

Answer 10

Record

Question 11

Relational Database

Answer 11

> The Primary key
The Foreign key

Question 12

It is a field that uniquely Identifies the record

Answer 12

Primary Key

Question 13

It is a field in a relational table that matches the primary key column of another table. Can be used to cross reference tables.

Answer 13

Foreign Key

Question 14

It Identifies a column or a set of column in one(referencing) table that refers to a column or set of columns in another (referenced) table.

Answer 14

Foreign key

Question 15

It is the process of organizing data to minimize duplication

Answer 15

Normalization

Question 16

All columns (field) must be atomic which mean no repeating items in column.

Answer 16

First Normal Form

Question 17

All non-key columns must be fully dependent on the primary key.

Answer 17

Second Normal Form

Question 18

A table must meet all the requirements for first and second normal forms. and all non key column must be mutually independent.

Answer 18

Third Normal Form

Question 19

Database Relationship

Answer 19

> One to One Relationship
One to many relationship
Many to many relationship

Question 20

It can exist between any two tables in which a row in the first table can be related to only one row in the second table and a row in the second table can be related only row in first table.

Answer 20

One to One relationship

Question 21

This Relationship cannot directly define a many to many relationship access. The user must be develop this type of relationship by adding a table called JUNCTION TABLE.

Answer 21

Many to Many relationship

Question 22

It Differs from one to one relationship in that a row in the first table can be related to one or more rows in the second table, but a row in the second table can be related to only one row in the first table

Answer 22

One to Many relationship