Prelim-Session1.pptx

Introduction to Database JESTER EMANN E. PEÑARANDA INSTRUCTOR Outcomes – Based Teaching and Learning Plan Declarative Knowledge:  Introduction to Database  Database Management System  Major Components of DBMS  Advantages of DBMS Functional Knowledge:  Explain the vision, mission, goals a...

Introduction to Database JESTER EMANN E. PEÑARANDA INSTRUCTOR Outcomes – Based Teaching and Learning Plan Declarative Knowledge:  Introduction to Database  Database Management System  Major Components of DBMS  Advantages of DBMS Functional Knowledge:  Explain the vision, mission, goals and objectives of institution and classroom policies.  Describe Major Components of DBMS.  Discuss the Advantages of DBMS. Intended Learning Outcomes (ILO):  Understand the Database Management System. Database  is structured gathered data which was stored to allow to be accessed and updated in the future.  It is used by many establishments or applications to manage and manipulate data of all transactions.  It is not always necessarily data from websites and applications.  It can be data from stored files and folders inside the cabinet which is called File System. They use it to track their data. Database Management System Refers to an information from a computer application which interact to its database  DBMS can be accessed on a local server or in remote 5 Major Components of a Database Hardware  refers to the physical parts of a computer which includes storage drive where data is stored and some input and output devices such as keyboard, mouse and monitor Software  is a collection of programs that provides user friendly interface which has instructions that were used to manage and manipulate the database Data  are organized stored information.  It can be end-user data which are information from the end-user or metadata which is a data about the data that holds information about the data types, relationship, constraints, etc. Procedures  refer to the instructions used in a database management system to help users manage and operate the database system. It also includes operation to install the DBMS, backup and restore database and produce reports. Database Access Language  is a program language used to write commands to create, read, update and delete (CRUD) data stored in a database Advantages of DBMS  Reduction of Data Redundancy  Data Integrity  Data Security  Data Sharing  Backup and Restore Data  Improve Data Administration References Dixon Kimani, “Introduction to Databases”, [Online]. Available: https://www.techopedia.com/6/28832/enterprise/databases/ introduction-to-databases#the-relational-database. [Accessed: 16-January-2023]. Mark Drake, “An Introduction to Databases”, [Online]. Available: https://www.digitalocean.com/community/conceptual- articles/an-introduction-to-databases. [Accessed: 16- January-2023]. Claudio Buttice, "Oracle Database (Oracle DB)”, [Online]. Available: https://www.techopedia.com/definition/8711/oracle- database. [Accessed: 16-January-2023]. tutorialspoint, " Advantages of Database Management System”, [Online]. Available: https://www.tutorialspoint.com/Advantages-of-Database- Management-System. [Accessed: 8-March-2024]. interviewbit, "What are the Components of DBMS (Database Management System)?”, [Online]. Available: https://www.interviewbit.com/blog/components-of-dbms/. [Accessed: 168-March-2024]. THANK YOU