This is the total software package that creates and
runs the data base e.g. MS, Access, D base, oracle, paradox, SQL (simple query
language).
runs the data base e.g. MS, Access, D base, oracle, paradox, SQL (simple query
language).
Database
Structure
Structure
By database structure we mean the outlook of a
database, i.e. the fields it will contain and field specification
specifications this includes:
database, i.e. the fields it will contain and field specification
specifications this includes:
i.
Field
name e.g. hospital no, name, sex, age etc.
Field
name e.g. hospital no, name, sex, age etc.
ii.
Field
types e.g. characters, numeric, date, currency, OLE (Object Linking and
Embedding), Decimal, memo.
Field
types e.g. characters, numeric, date, currency, OLE (Object Linking and
Embedding), Decimal, memo.
iii.
Field
width/size.
Field
width/size.
iv.
Filed
values: are the contents of each field. This may be different from record to record.
Filed
values: are the contents of each field. This may be different from record to record.
Types of Files in Database
Table: A table is use to organize our database into
rows and columns.
rows and columns.
|
Surname
|
First
name |
Hospital
no. |
Age
|
Sex
|
|
|
Adeda
|
Toyin
|
Adedu
|
012734
|
1
½ years |
M
|
|
|
|
|
|
|
|
1.
In a
table the columns are the fields and rows are the record.
In a
table the columns are the fields and rows are the record.
2.
Query —
we use a query to seek for information stores in our database table.
Query —
we use a query to seek for information stores in our database table.
3.
Form — we
are a form to view data information. Here we see only one record at a time.
Form — we
are a form to view data information. Here we see only one record at a time.
4.
Report —
report is use to organize and format our information to specifications.
Report —
report is use to organize and format our information to specifications.
