CC105 WEEK 2 HANDOUTS GALAPON WATERMARK.pdf

CC105 – INFORMATION MANAGEMENT 1ST SEMESTER (WEEK 2) INFORMATION MANAGEMENT CONCEPTS ○ Excessive Program AND FUNDAMENTALS Maintenance LEARNING OUTCOMES: 1. Define database and its basic terms;...

CC105 – INFORMATION MANAGEMENT 1ST SEMESTER (WEEK 2) INFORMATION MANAGEMENT CONCEPTS ○ Excessive Program AND FUNDAMENTALS Maintenance LEARNING OUTCOMES: 1. Define database and its basic terms; DATABASE SYSTEMS 2. Describe some characteristics of database systems; 3. Identify various capabilities of database systems and some database applications. HISTORY OF DATABASE The concept of a database existed long before computers. In these times, data was stored in journals, in libraries, and in hundreds of filing cabinets. Everything was recorded via paper and that meant it Five Major Parts of a Database System took up space, was hard to find, and 1. Hardware difficult to back up. 2. Software 1960 - Charles Bachman designed the first ✔ Operating Systems computerised database Software ✔ DBMS Software 1970 - E. F. Codd released his paper “A ✔ Application programs and Relational Model of Data for Large Shared utility software Data Banks”. 3. People ✔ Systems Administrators 1980 - Growth and Standardization. SQL(Structured Query Language) has ✔ Database Administrators become the standard language used for ✔ Database Designers databases. ✔ Systems Analysts and Programmers FILE SYSTEMS ✔ End users It is used by a manager of any small 4. Procedures organization to track necessary data. 5. Data DATABASE A shared collection of related data used to support the activities of a particular organization. It can be viewed as a repository of data that is defined once and then accessed by various users. Disadvantages of a File System ○ Program-data dependence ○ Duplication of Data ○ Limited Data Sharing ○ Lengthy Development Times CC105 – INFORMATION MANAGEMENT 1ST SEMESTER (WEEK 2) DATABASE A database has the following properties: ○ It is a representation of some aspect of the real world or a collection of data elements (facts) representing real-world information. ○ A database is logical, coherent and internally consistent. ○ A database is designed, built and populated with data for a specific purpose. TRADITIONAL BANKING SYSTEM ○ Each data item is stored in a field. ○ A combination of fields makes up a table. BANK DBMS DATABASE MANAGEMENT SYSTEM DBMS USERS Stores data in such a way that it becomes easier to retrieve, manipulate, and produce information. Characteristics: ✔ Real-world Entity ✔ Relation-based Tables ✔ Isolation Of Data And Application ✔ Less Redundancy ✔ Consistency INFORMATION MANAGEMENT ✔ Query Language ▪ The infrastructure used to collect, ✔ ACID Properties manage, preserve, store and deliver information. ✔ Multi User And Concurrent Access ✔ Multiple Views ▪ The guiding principles that allow ✔ Security information to be available to the right people at the right time. CC105 – INFORMATION MANAGEMENT 1ST SEMESTER (WEEK 2) INFORMATION MANAGEMENT REFERENCES: Kenneth C. Loudon, Jane P. Loudon, (2022) ▪ The view that all information, both digital Management Information Sytem Managing and physical, is an asset that requires Digital Firm 7th Edition proper management. ▪ The organizational and social contexts in Hossein Bidgoli PH.D.(2021), MIS 10 - which information exists. Management Information Systems - 10th Ed. ▪ ▪ Is an umbrella term that encompasses all Michael E. Whitman, Herbert J. Mattord the systems and processes within an (2018) , Management of Information Security organization for the creation and use of corporate information. Kathy Schwalbe(2019), Information ▪ More than just technology; it is about the Technology Project Management business processes and practices that Coronel, C., Morris, S. & Rob. P., underpin the creation and use of (2017).”Database Systems: design, information. implementation & management”,(12th ▪ It is also about the information itself, edition). Mike and Murach & Associates, Inc: including the structure of information 4340 N, Knoll Ave, Fresno, CA 93722 (“information architecture”), metadata, content quality, and more. Elmasri, R., Navathe, S.(2018), “Fundamentals of Database Systems”.(7th edition), Pearson Higher Education, 221 River Street, Hoboken, PURPOSE OF INFORMATION MANAGEMENT NJ0703. ▪To Design, develop, manage, and use information with insight and innovation. ▪To Support decision making and create value for individuals, organizations, communities, and societies.