|
The following car details are to be entered in a database: Make, date of manufacture, colour and cost.
(a) Prepare a suitable database structure showing field names and their field types (5mks)
0 Comments
Give three advantages of separating data from the application that use the data in database design.27/12/2020 Give three advantages of separating data from the application that use the data in database design.
A computer Vendor has recommended the use of a computer database to your
school for student information a) Explain to the Board of Governors what a database is an its functions (5mks)
A database is a shared collection of logically related data (and a description of this data) designed to meet the information needs of an organization.
Functions of a database
What is relational database?
This is a database where records are structured within tables (relations)
A relational database is a type of database that stores and provides access to data points that are related to one another.
Relational databases are based on the relational model, an intuitive, straightforward way of representing data in tables. In a relational database, each row in the table is a record with a unique ID called the key. The columns of the table hold attributes of the data, and each record usually has a value for each attribute, making it easy to establish the relationships among data points. 
DEFINE THE FOLLOWING TERMS; 1)FILE; 2) RECORD; 3) FIELD
A file, record and a field are database terms used especially when dealing with tables.
What is a file
A file is a collection of records, database files organize the data into records and fields.
Definition of Normalization
Normalization is the process of organizing data in a database by establishing relationships between tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency, insertion anomaly, update anomaly & deletion anomaly.
|
Categories
All
Archives
December 2024
|
RSS Feed