Data Resource Management PDF

DATA RESOURCE MANAGEMENT RaihanZ  Logical Data Elements Traditional File Processing The Database Management Approach Database Management System (DBMS)  What? Data Hierarchy Logical Data Elements ...

DATA RESOURCE MANAGEMENT RaihanZ  Logical Data Elements Traditional File Processing The Database Management Approach Database Management System (DBMS)  What? Data Hierarchy Logical Data Elements  What? Logical Data Elements Data Information Information is Data are raw processed data facts which have which have not been specific processed meanings  What? Logical Data Elements The increasing Difficulties in amounts of data managing data and addition of new data The fact that data are Data should be found everywhere and secured and can are collected and only be accessed stored using various by authorised methods persons  What? Data Hierarchy Logical Data Elements Data Hierarchy Logical Data Elements Database Files Records Fields Bytes Bits Data Hierarchy Logical Data Elements  What? Data Hierarchy Logical Data Elements  Logical Data Elements Traditional File Processing The Database Management Approach Database Management System (DBMS)  What? Limitations Traditional File Processing  What? Traditional File Processing File-Based System A file-based system is a collection of application programs which perform various tasks  What? Traditional File Processing Example Student Scheduling Payment registration system system system Timetable Program Fees file register file payment file Student Student Student register file register file register file Program Course register file register file Course register file  What? Traditional File Processing Example Student Scheduling Payment registration system system system Timetable Program Fees file register file payment file Student Student Student register file register file register file Program Course register file register file Course register file  What? Limitations Traditional File Processing  Limitation Traditional File Processing Separation of data Data redundancy Incompatible file formats Data dependence  Logical Data Elements Traditional File Processing The Database Management Approach Database Management System (DBMS)  What? Examples The Database Management Approach  What? The Database Management Approach Database Management What is a Approach database? Independent files are A database is a combined in a collection of database of various interrelated data application programs which has specific and are used for storage and purposes information retrieval  What? Examples The Database Management Approach  Example The Database Management Traditional file-based system Approach (Entity-Relationship (ER) diagram) Student Scheduling Payment registration system system system Timetable Program Fees file register file payment file Student Student Student register file register file register file Program Course register file register file Course register file  Example The Database Management Approach Database approaches (Entity-Relationship (ER) diagram) Human Finance Faculty Resources Department Department Student Scheduling Payment registration system system system Timetable Program Student Course Fees file register file register file register file payment file  Activity Database Management System (DBMS) Activity: 1.Create a simple Google Form. 2.Gather some responses. 3.Observe how the response data is stored in Google Sheets, or download it in MS Excel. https://www.youtube.com/watch?v=IAL8RwxN0Og  Logical Data Elements Traditional File Processing The Database Management Approach Database Management System (DBMS)  What? Advantages & Disadvanges DBMS Structure DBMS Types Database Management System (DBMS)  What? Database Management 4 major operations System (DBMS) in DBMS DBMS Creating and entering data into the database Accessing data in the database DBMS is a program which allows users to Querying data in the access, retrieve, database manipulate, analyse and manage data in a Displaying data in the database database What? Database Management DBMS Software System (DBMS)  What? Advantages & Disadvanges DBMS Structure DBMS Types Database Management System (DBMS)  Advantages & Database Management Disadvanges System (DBMS) ADVANTAGES DISADVANTAGES Reduces data Complex redundancy Large in size Increases data consistency High in cost Increases data security and integrity Slow in performance Allows data access and sharing Increase concurrency and productivity Activity Database Management System (DBMS) CONTINUOUS ASSESSMENT 3(CA3) BRIFIENG ANG GROUP DISCUSSIONS