Lecture No 1a Database Basic Introduction.pptx

this is about basic of database onlly

1. Introduction to Database 9/19/2022 1

2. Lecture No 1(a) Database Basic Introduction By Engr. Muhammad Anwar [email protected] Lecturer at Computer Science Department University of Turbat (Panjgur Campus)

3. Introduction to Database 9/19/2022 3

4. Lecture Outline What is Data? What is Information? What is database? What is database Management System (DBMS)? What is Database system? Introduction to Database 9/19/2022 4

5. What is Data? Data are facts and statistics collected for reference or analysis. the quantities, characters, or symbols on which operations are performed by a computer , which may be stored and transmitted in the form of electrical signals and recorded on magnetic, optical, or mechanical recording media. Singular of data is datum Introduction to Database 9/19/2022 5

6. What is Information? Information  is processed, organized and structured  data . It provides context for data and enables decision making process. For example , a single customer’s sale at a restaurant is data – this becomes information when the business is able to identify the most popular or least popular dish. Students Marks (data) to identify topper and average marks (Information) Introduction to Database Data 2 Data 1 Data 3 Processing Information 9/19/2022 6

7. What is Database? A  database  is an organized collection of data , so that it can be easily accessed and managed. Database can organize data into tables, rows, columns, and index it to make it easier to find relevant information. A cylindrical structure is used to display the image of a database. Introduction to Database 9/19/2022 7

8. What is Database Management System (DBMS)? A database management system (DBMS) is system software for creating and managing databases. A DBMS makes it possible for end users to create, protect, read, update and delete data in a database. The most prevalent type of data management platform, the DBMS essentially serves as an interface between databases and end users or application programs, ensuring that data is consistently organized and remains easily accessible. Examples: Microsoft SQL Server, Teradata, SolarWinds Database Performance Analyzer, etc. Introduction to Database 9/19/2022 8

9. What is Database Systems? The Combination of Database and Database Management System (DBMS) is called Database Systems. Introduction to Database 9/19/2022 9

10. Introduction to Database 9/19/2022 10