IT 201 Information Management 1 Prelim Week 1 - Introduction to Database PDF

NATIONAL COLLEGE OF SCIENCE & School of TECHNOLOGY Nation Builders COMPUTER STUDIES DEPARTMENT INFORMATION IT 201 MANAGEMENT 1 Prelim: Week 1 – INTRODUCTION TO DATABASE...

NATIONAL COLLEGE OF SCIENCE & School of TECHNOLOGY Nation Builders COMPUTER STUDIES DEPARTMENT INFORMATION IT 201 MANAGEMENT 1 Prelim: Week 1 – INTRODUCTION TO DATABASE Prepared by:Danielle Dino  School of NATIONAL COLLEGE OF SCIENCE AND TECHNOLOGY Nation Builders Amafel Building, Aguinaldo Highway, Dasmariñas City, Cavite DATA is a raw and unorganized fact that required to be processed to make it meaningful. Generally, data comprises facts, observations, perceptions numbers, characters, symbols, image, etc.  School of NATIONAL COLLEGE OF SCIENCE AND TECHNOLOGY Nation Builders Amafel Building, Aguinaldo Highway, Dasmariñas City, Cavite COMPUTER STUDIES DEPARTMENT INFORMATION is defined as refined or processed data that has been transformed into meaningful and useful form for specific users.  School of NATIONAL COLLEGE OF SCIENCE AND TECHNOLOGY Nation Builders Amafel Building, Aguinaldo Highway, Dasmariñas City, Cavite COMPUTER STUDIES DEPARTMENT Database ❑Any collection of related ❑Databases can be stored in information different ways oPhone Book oOn paper oShopping list oIn your mind oTo-do list oOn a computer oYour 5 best friends oThis PowerPoint oFacebook’s User Base oComments Section A database is a structured collection of data organized for efficient storage, retrieval, and management. It can be as simple as a single file or a complex system with multiple interconnected tables.  School of NATIONAL COLLEGE OF SCIENCE AND TECHNOLOGY Nation Builders Amafel Building, Aguinaldo Highway, Dasmariñas City, Cavite COMPUTER STUDIES DEPARTMENT File System A file system is a process that manages how and where data on a storage disk, typically a hard disk drive (HDD), is stored, accessed and managed. Drawback (disadvantage) of using file systems to store data: ▸ Data redundancy and inconsistency ▸ Difficulty in accessing data ▸ Data isolation ▸ Integrity problems ▸ Atomicity of updates ▸ Concurrent access by multiple users ▸ Security problems  School of NATIONAL COLLEGE OF SCIENCE AND TECHNOLOGY Nation Builders Amafel Building, Aguinaldo Highway, Dasmariñas City, Cavite COMPUTER STUDIES DEPARTMENT Database System consists of database (DB) + database Management System (DBMS) + application program Or is just a computerized record keeping system. Database is a repository for a collection of computerized data files. Components of Database System ▸ Data ▸ Hardware ▸ Software ▸ User  School of NATIONAL COLLEGE OF SCIENCE AND TECHNOLOGY Nation Builders Amafel Building, Aguinaldo Highway, Dasmariñas City, Cavite Table The data in the database is stored in database objects which are called as tables. This table is basically a collection of related data entries and it consists of columns and rows.  School of NATIONAL COLLEGE OF SCIENCE AND TECHNOLOGY Nation Builders Amafel Building, Aguinaldo Highway, Dasmariñas City, Cavite COMPUTER STUDIES DEPARTMENT Field Every table is broken up into smaller entities called fields. The fields in the CUSTOMERS table consist of ID, NAME, AGE, ADDRESS and SALARY. A field is a column in a table that is designed to maintain specific information about every record in the table Record or Row A record, also called a row of data, is each individual entry that exists in a table. Following is a single row of data or record in the CUSTOMERS table  School of NATIONAL COLLEGE OF SCIENCE AND TECHNOLOGY Nation Builders Amafel Building, Aguinaldo Highway, Dasmariñas City, Cavite COMPUTER STUDIES DEPARTMENT Column A column is a vertical entity in a table that contains all information associated with a specific field in a table. For example, a column in the CUSTOMERS table is ADDRESS, which represents location description and would consist of the following: THANK YOU! QUIZ 1  1. It is data that has been transformed into meaningful and useful form for specific users.  2. Generally, data comprises facts, observations, perceptions numbers, characters, symbols, image, etc.  3. It comprises facts, observations, perceptions numbers, characters, symbols, image, etc. 4-6. GIVE 3 DISADVANTAGE / DRAWBACKS OF USING FILE SYSTEM TO STORE DATA 7. Every table is broken up into smaller entities called -----.  8. is a process that manages how and where data on a storage disk, 9. It is also called a row of data 10. Any collection of related information