DATA PROCESSING OBJ:
This is the software that handles the storage, retrieval, and updating of data in a computer system.
A file is a collection of records which have common properties. Each file has its own file reference which is unique. The file reference indicates the subject or contexts of the records.
A record can be an image, text based or in electronic or physical format.
(3bi) Normalization is a process of organizing the data in database to avoid data redundancy, insertion anomaly , update anomaly & deletion anomaly
-Insertion Anomalies: Insertion anomalies occur when we
try to insert data into a flawed table.
-Deletion Anomalies: Deletion anomalies occur when we
delete data from a flawed schema.
-Update Anomalies: Update anomalies occur when we
change data in a flawed schema.
Log files – A log file is a recording of everything that goes in and out of a particular server
Firewall- A firewall is a system designed to prevent unauthorized access to or from a private network.
Encryption – Encryption is the conversion of electronic data into another form, called ciphertext, which cannot be easily understood by anyone except authorized parties.
Backup- backup refers to the copying and archiving of computer data so it may be used to restore the original after a data loss event.
Primary key uniquely identify a record in the table. While,
Foreign key is a field in the table that is primary key in another table.
Primary Key can’t accept null values. While,
Foreign key can accept multiple null value.
Transmission is the act of transferring something from one spot to another, like a radio or TV broadcast, or a disease going from one person to another.
(i)Tasks can be completed faster because computers work at amazing speed.
(ii)Computers can process large amounts of data and generate error-free results, provided that the data is entered correctly.
(i) Hierarchical database model is a data model in which the data is organized into a tree-like structure.
(ii)A network model is a database model that is designed as a flexible approach to representing objects and their relationship
(i)data storage management
(ii) data transformation and presentation
(iv)multiuser access control
(v)backup and recovery management