HIERARCHY OF DATA

Hierarchy Of Data
Hierarchy is a series of ordered groupings in a system, beginning with the smallest unit to the largest.
 

Data is organized in a hierarchy that begins with the smallest to the largest unit of data, as it progresses up the hierarchy.
 

Together, bits, bytes, fields, records, files and database form the hierarchy of data.
BIT, BYTE, FIELD, RECORD AND FILE

The bit is represented by 0 for OFF or 1 for ON. It is a binary digit. It is the smallest unit of data the computer can store in a database.
A byte is a collection of bits. Each byte consists of eight bits. Each byte represents a character.
For example : The letter S is made up of 0101 0011
A field is a unit of data consisting of one or more characters (bytes).
A field is the smallest unit of meaningful information in the database. Each field has a field name.
The field name describes the data that should be entered into the field, such as StudentID (Student ID), Name, Address and MyKad Number.
A record is a collection of related fields.
Example : Each record stores data about a students.
For example, a student record is a collection of fields about a student.

A file is a collection of related records. For example, a student file is a collection of students’ records



Database

Database is structured collection of information on specific subjects. We can think of a database as an electronic filing system.
An example of the database is a telephone book which contains records of names, addresses and contact numbers.
A database allows its contents to be easily accessed, updated, stored and retrieved.

A database is an organized collection of data, today typically in digital form. The data are typically organized to model relevant aspects of reality (for example, the availability of books in bookstores), in a way that supports processes requiring this information (for example, finding a book with prices).
The term database is correctly applied to the data and their supporting data structures, and not to the database management system (DBMS). The database data collection with DBMS is called a database system.


DATABASE MANAGEMENT SYSTEM (DBMS)
A Database management System is a program that accesses information from a database.
A Database Management System provides an interface between the database and the user.
A Database management System enables you to extract, modify and store information from a database.

Well known DBMSs include Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access, PostgreSQL, MySQL, and SQLite. A database is not generally portable across different DBMS, but different DBMSs can inter-operate to some degree by using standards like SQL and ODBC together to support a single application. A DBMS also needs to provide effective run-time execution to properly support (e.g., in terms of performance, availability, and security) as many end-users as needed.

data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAkGBhMSERISExQUFRUWFRIVFBcXFxUWFxYVFxQVFBcUFBMXHCYhHBwlGRQWHy8kIycrLCwsFx4xNTAqNSYrLCoBCQoKDgwOGg8PGisiHyQyKiktKSo0NS80KSwqNSwsLSwyNSw2LS0sNCwsLCw1LCwpKiwsLDUsNSksKSopKSwsLP/AABEIAGYAZgMBIgACEQEDEQH/xAAbAAACAwEBAQAAAAAAAAAAAAAFBgADBAIHAf/EAD8QAAEDAgIGBwYDBwQDAAAAAAECAxEABBIhBQYTMUFhByJRcYGRsRQyUqHB8EKi0RVTcpKywuEjYmOCFjM0/8QAGwEAAgIDAQAAAAAAAAAAAAAABAUABgECAwf/xAA0EQABAwIDAwoEBwAAAAAAAAABAAIDBBEFMUESIZETFDJRYXGBseHwFULB0SIjMzRDUqH/2gAMAwEAAhEDEQA/APbo5HzrDp7aey3GyxhzZO7MpAUoLwHDhSTmZiBW6OR86waeLwtbg24l4NOFof8AJgODLviospP1e1+uym3af0Zf7Q7NDruABGIwlTh3Qnjuyp/jkfOvA9XtOOG4SzbvX67kv6PWpLu0OYC03iX8WSWxiOXd2V7feaTCDgCStfwgwAOBUrh68q0c4NFytmMc82C2xyPnXK1ACTkOZj60GW64o9dZSPhby81nM/KufZGpzbxc1HGfzE0M6q6hxRIp+s8PYRJWlmBvcR/OD6GuP20x+8T5msgaAiIjyq99kYcvX/NcHVhGo4eqzyUY3b+PorP20x+8R4qj1q5q/aV7q0q7lpPoaFKT2+tZ3WGz7yArvAj9axz0jqPvxXTm8Zyv5/ZMscj51I5HzpSS2Un/AE1LR2BKjH8pJFc22uSkOKbdTtEgkY0ZGBvJTMHjurb4jE0gSbvL34LPMJHAmPfbwP2/1N8cj51KptLpDqAtBxJO4g1KYggi4S8gg2Kujl86yaWSjYPbRSkN7NzGsKIKEYTiUFDMECTPKtccvnQ/WGxU7aXLSQSpbLqEgKCSSpBAAUchmd9ZWF5jqtp+/N02ixW/f2RUkOO3TOzwIkAlFzILhAk7vCm7R14FhSt6iteLPOcR+keVC9WdMaYQm3t3LJhQb2TTrguklYSIBWUAnrYQTHGKXWr9bTzmE/jXl/2NKMTlMWwR2/RN8Ni5UPHd9V6KtfGN47a6Qqco7s6W7PWMKEKTn3x30SZ0ik8D50hfXt1NkQ+ne3RFEyOHhNWLTMdw41kavEnga1lYAmPnQUmItGqFcCDkqlMns+dVLaPYa6duRwHzrE6qd/r6UM7E/wCu9dWNcc1qWwMBO4wc53UtqaS2kkDEoyBO6OJjj2Z862P3YG8wOwHh2UFv9JTMDu7AOwChmulmdd5umNNG5u4nNMuor52jyCSZCVxPGSCfvsqVg6N1Evvk59RP9VfK9BwsEUrQe3zSbE/3J8PJegxy+dYdO2zrltcIYOB1TTqWlTGFZQQkzwzjOt2Hl86QeknSuyudGodfXbWqnHnH1pVhxKZSlbbSldijiy40zS1IugdXrjboZa0fdW7ge0e6XlyG0LYCxcuKdmHMYWYAmZNEtMWhbuXQeK1EdxJP1obaXTh9k0kbh4Xt3fp2LGM4VWhd2ZTsfgwg57t1NesGhPaLi4cGRQooSJ90CBMcyaV4kxj2AONjfcmeHSvjc4gXFt6F2yaK27fKgara4ZjEiR2/5q5jWIJyW2odx/WqlPRS/JY9xTQ1cb9bJnYaPPzrai2PPzpdt9a2OOIeH6VvRrfbj8R8lUokpagHoHghnyjQoku1PPzrE+z9zVLuuNv8R/lVQ251vZ4JWfAD61I6WoPyFRkvWVdcN8qF3Ka5Xp1SzCWiJ3SfoKoVo11/FOSYzAy4gU1hpnt/UICKZUi9gCU59G9iQXnTuUEpHgSSalEdQW8NupG8oWUzO8QCJ86lXijDBA3YySKsc90ztvNEtO60Wtns/aXUtbRWFGInM8T3CRJ4SK5tLm00iySlLdwzjKeskKQVIOZTiEEcxQHpF0SVezvpduEOB1pptpotEOLKipP/ALgUpUOt1jlGRByqi01mumbVGytLq9cDr7bwWthK2VoKeqS0kIUM8iKLQiaL9m0ZUy86hlCgUsMrUEgpKzCW2zGUnKBXn2kb9TV7cgbi6qR4zX3WDS2kL/2Vo6KfYSi7tXlLUtCgEtuAqkCOB+VZdYEn2t4x7yyrzpPi7SYQRoU3wlzeUc06hM7WsDbiMKkCY47jXB0aw5+EA8zv8e2l61TyorbpqkvkdH0Smb6aMdHctbWqjKjuHgRX1WpzE7vSrGUn7Na0tH7NBvrJ79NAPhAOaGq1SYHCuToJhO5E98elEHGz9msNwD9mo2omdm8rpHC1VBltBnCBAMT2xlQq80qEhQSJnyyM1bdJoNdijoWbRu43TWKNoT10arKmXicztB/SKlddGzBSwuR7y8Q7oA+lSvQaNpbA0EaKr1rg6d5B1WrpBURZmLYXKStGNspU51cyCEogziCRI92Z4UjLbuFN6N0Ys+xofeuw6thJZLiWQlWBvESRjUtWcnFhnjTp0jpT7K2FlCUm4YBDpUllzrH/AEn1p91B7cxIEg0r3tnZCxtrW6h1T90v2VNksubBRUJDLu8JbChJ3Z7qLQaC68ai+wuWgt3Lo277zTVyldzO1xPICWkIjFijEZ3ACmDXDQJcu1BGQbQlUA8TQHQD2jmNIoKk6QuUt3HszV3cL2lui43QiAIM5SZ7Y40w64Xymr9UbilokTG5MTPnS3EpHRw7TescEww+MSSFvYfolsOvtHrIxD74iiFvrIlPvtqHdn60bsb1l0gKyn4gPWt9/oNgwYTHfvqpzT0khs9tj2bkweZYyG34oPb612/HEO9J+lEWtbLX4/yq/Sqf/FmDwrpOqDHZS+SKhOrh77kM90hzXy51ptviJ7kq/ShF1rYzwSs+AHqaLq1SZ7K5OrzCPwyfStWcyZltFbxuk0SrcacWv3Go5qP0FWtaFceTiWcIyMjKM99MDls2n8I8aH3V/AISN4I5Z8qMFQ21oW27UcIJJOk4+CfdU7YJtkZZ5hWY3pJTw7q+VTqJnZIynrOcf95qVfKZxdCwuzsFXqhoZK5o0JVWvVxhYRk2rC6yt1tRYxLZCusEB/qyTAzjKYMxSqxq3dvtW13Zm3aeYevdkhzZlOwfgBLhturtEwN3CJzq7pXuy2tnC/bJxIUCw4yh512FSNmVNLgA9oAmmPo6JNiglsoJUs4ShhsjP4LcBPyntohcEtsdGt0hiwsgtosNvC6vHOttHHkubTA2PhO6T2eFDteLoKv1pMBQCQB2gDeK9bw8hSlrt0et34Ch1HR7qgYM9sjdQtVT8vHsXsiqWoNPJt2vokuzHKjNsmli41d0rZHNCblA3E9VcfxpyPiK+sa8bPJ+0uGzxISHB8iD8qp1VhNU07m7Xd7unnxCGQZ2707NINa0smlG16RrD8TikfxtOp/tIoqz0iaNj/6WvzD+2kUtHVN/idwKHknZoQiziCKwOpP2aw3XSJo7hcIP8IcV6JoRcdIdqfcS+5/Ayv1VFdIaGqdlE7gVvHURjMhF30cqE3mQNZP27eXGVvYrz/E6Y/Kn9aKaK6Mbu5UF3rkImdkjqp8U7z4mrBSYPUOP5g2R2+i6PxKJg/DvKduj9U2SMhGJcHtBUT9a+0bsdHoZbS2hICUiBUq4xsDGho03KuyPL3F513qnSGg7d8gvMMukCAXEJWQN8DEKtsdHNMowMtNtoknChIQmTvOFIipUrZarRHIVI5CpUqKKRyFZ3tHNL95tB7wP0qVKiiwu6qWit7DdUHUey/cIqVKii6RqVZjcwitjOgLdPustjwqVKii2tspTuSkd2X0rqOQqVKiikchUqVKii//Z

A way to classify databases involves the type of their contents, for example: bibliographic, document-text, statistical, or multimedia objects. Another way is by their application area, for example: accounting, music compositions, movies, banking, manufacturing, or insurance.
The term database may be narrowed to specify particular aspects of organized collection of data and may refer to the logical database, to the physical database as data content in computer data storage or to many other database sub-definitions.
http://en.wikipedia.org/wiki/Database 

Types of Information Systems

5C class, please do these as your homework..

1. Which of the following can provide regular information about the daily activities of a 
     business to managers?
     A. Expert System
     B. Executive Information System
     C. Transaction Processing System
     D. Management Information System

2. Management Information System is to help managers make the processes and
    activities of a business to _____________.
     A. react to situations
     B. run more efficiently
     C. behave in a smooth way
     D. operate at the highest cost

3. Management Information System provides daily information of a business to   
    _______.
     A. clerks
     B. typists
     C. operators
     D. managers

4. Transaction Processing System is used to __________ business transactions.
     A. repeat
     B. record
     C. reprint
     D. register

 5. Transaction Processing System 
     A. maintains students’ database.
     B. provides computer-based training.
     C. handles distance learning program.
     D. keeps track of daily transaction in a database.

6. Which of the following keeps track of daily transaction in a database?
   
     A. Decision Support System
     B. Executive Information System
     C. Transaction Processing System
     D. Management Information System


7. Decision Support System is used to help managers ______________ in important
    areas of business.

     A. make right decisions
     B. manage people in a company
     C. receive payment over the Internet
     D. call important people with the telephone


8. Which of the following is used when the manager needs information to make the best
    decision?

     A. Decision Support System
     B. Executive Information  System
     C. Transaction Processing System
     D. Management Information System


9. Online banking is the example of

     A. Decision Support System
     B. Executive Information System
     C. Transaction Processing System
     D. Management Information System


10. Q is used to help managers record business transaction. "Q” is referred to

     A. Expert System
     B. Executive Information System
     C. Transaction Processing System
     D. Management Information System

P/s: Pass up your book next week ok...(Tuesday:10th July)