WEEK 1 Day 01 New.pdf

Agenda  DATA  TYPES OF DATA  DATA AND INFORMATION  DATABASE MAANGEMENT SYSTEM  WHY WE USE DATABASE? WHAT IS DATA  Data is a collection of information gathered by observations, measurements, research or analysis.  They may consist of facts, numbers, names, figure...

Agenda  DATA  TYPES OF DATA  DATA AND INFORMATION  DATABASE MAANGEMENT SYSTEM  WHY WE USE DATABASE? WHAT IS DATA  Data is a collection of information gathered by observations, measurements, research or analysis.  They may consist of facts, numbers, names, figures or even description of things.  Data is organized in the form of graphs, charts or tables. There exist data scientist who does data mining and with the help of that data analyze our world. Image source-:https://www.splashlearn.com/math-vocabulary/measurements/data Data And Information Data refers to raw facts, details, or distinct pieces Information refers to processed and organized data that has context, of information that are collected, stored, and relevance, and purpose. It results from the interpretation and analysis processed. It can be in various forms, including of raw facts, making it meaningful and valuable for decision-making. numbers, text, images, or any other format. Example-: if train is coming to station then the visual display on the Example -: If train is coming to station at 2:30PM station board showing the train's name, platform, and arrival time is in this case the time 2:30 PM is the data. the information. Image source-: https://www.flaticon.com/free-icon/management_3715093 Data v/s information What is Database Management System? Components of DBMS HARDWARE SOFTWARE DATA PROCEDURES DATA ACCESS LANGUAGE   Hardware: In DBMS, information hardware is the most important visible part. The equipment which is used for the visibility of the data is the printer, computer, scanner, etc. Components of  Software: Software is the main component of the DBMS. DBMS cont.. Software is defined as the collection of programs that are used to instruct the computer about its work. The software consists of a set of procedures, programs, and routines associated with the computer system's operation and performance.  Data:The term data means the collection of any raw fact stored in the database. Here the data are any type of raw material from which meaningful information is generated. The database can store any form of data, such as structural data, non-structural data, and logical data.   Procedures: In DBMS, with the help of procedure, Components of we can validate the data, control the access and reduce the traffic between the server and the clients. DBMS cont.. The DBMS can offer better performance to extensive or complex business logic when the user follows all the procedures correctly.  Database Access Language: Database Access Language is a language used to write commands to access, upset, and delete data stored in a database.  Data independence Characteristics of ACID properties Atomicity Consistency Integrity Durability DBMS Security  Cont…  Data Independence  Logical Independence: Changes in the logical structure (schema) do not affect the application programs.  Physical Independence: Changes in the physical storage and structure do not affect the logical structure or applications.  Atomicity of Operations (Transactions): Here, atomicity means either the operation should be performed or not performed. i.e., it should complete the operation on 0% or 100%. DBMS provides atomicity as a characteristic. This is the most important and useful characteristic of the DBMS.  Integrity: Integrity means the data should be correct and consistent in nature. The data available in the Database should be correct as well as consistent. Ensures the accuracy, consistency, and reliability of data by enforcing constraints (such as unique keys, foreign keys, and data types) on the data.  Ease of Access (The DBMS Queries): In DBMS, we can search any kind of stored data by applying a simple search operation query. It is so much faster than manual searching. In DBMS, Characteristics ACID Properties: ACID stands for Atomicity, of Consistency, Isolation, and Durability. Atomicity means the transaction should either be 0% or 100% completed, and consistency means that the change in data should be DBMS reflected everywhere in a database. Cont.. Security: The Database should be accessible to the users in a limited way. DBMS has authentication for various users that directly refers to the limit to which the user can access the Database. Authentication means the process of logging of the user only with the rights that he/she has been authorized to. Why DBMS?  Efficiency Through Structure Features of Ensuring Data Accuracy DBMS Scalability for the Digital Age  Efficiency Through Structure :Databases bring structure to our data chaos. Think of it as a well-organized library where each piece of information has its place. This structure Features facilitates quick and efficient retrieval. of DBMS Ensuring Data Accuracy :Accuracy is Cont.. paramount. Databases enforce data integrity, ensuring that the information stored is accurate and consistent. No more worries about conflicting or outdated data.  Scalability for the Digital Age : In our digital age, the volume of data is staggering. Databases provide scalability they can handle vast amounts of information without compromising performance. This scalability is Features vital as our data needs continue to grow. of DBMS This DBMS also provide the following Cont… properties which makes it very important. It used by both No redundancy It supports multi- small and large and integrity issue users. business. is found here. Test Yourself  What is the main difference between data and information?  What are the main properties that makes DBMS more important?  What are the differences between qualitative data and quantitative data?  What are the components of DBMS? THANK YOU