Lecture No 1b Overview of Database intro

this is advanced database

1. Introduction to Database 9/22/2022 1

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

3. Sahih al-Bukhari 59  Book 3, Hadith 1 Introduction to Database 9/22/2022 3

4. Lecture Outline Introduction to Database 9/22/2022 4

5. Database Concept A database intends to have a collection of data stored together to serve multiple applications as possible. Hence a database is often conceived of as a repository of information needed for running certain functions in a corporation or organization. Such a database would permit not only the retrieval of data but also the continuous modification of data needed for control of operations. It may be possible to search the database to obtain answers to queries or information for planning purposes. Introduction to Database 9/22/2022 5

6. Purpose of Database Introduction to Database 9/22/2022 6

7. Advantages of Database Introduction to Database 9/22/2022 7

8. Disadvantages of Database Introduction to Database 9/22/2022 8

9. keys in a database A key in  DBMS  is an attribute or a set of attributes that help to uniquely identify a tuple (or row) in a relation (or table). Keys are also used to establish relationships between the different tables and columns of a relational database . Introduction to Database 9/22/2022 9

10. Type of Keys in DBMS Primary Key Candidate Key Super Key Foreign Key Composite Key Alternate Key Unique Key Introduction to Database 9/22/2022 10

11. Primary Key A primary key is a column of a table or a set of columns that helps to identify every record present in that table uniquely. There can be only one primary Key in a table. Introduction to Database 9/22/2022 11

12. Database Languages Database languages, also known as query languages or data query languages, are a classification of programming languages that developers use to define and access databases, which are collections of organized data that users can access electronically. These languages allow users to complete tasks such as controlling access to data, defining and updating data and searching for information within the database management system (DBMS).  Introduction to Database 9/22/2022 12

13. Types of Database Languages Introduction to Database 9/22/2022 13

14. 1. Data definition language (DDL) Introduction to Database 9/22/2022 14

15. 2. Data manipulation language (DML) Introduction to Database 9/22/2022 15

16. 3. Data control language (DCL) Introduction to Database 9/22/2022 16

17. P urpose of database software Data Redundancy or Data Duplication is Minimized. Data Integrity is maintained in a Database Management System. Data Consistency is also maintained in a Database Management System.  Backing up data from a single location is simple. In DBMSs, Data is housed in a secure central location, and many access privileges can be assigned to multiple people. One of the main benefits of a Database Management System is that the same business data can be made available to various personnel at any time and from any location.  Introduction to Database 9/22/2022 17

18. Introduction to Database P urpose of database software Database Management Systems also ensures data durability, that is, even if there is a power outage or any other disaster for that matter, the data in the Database will persist. Usage Of Query Languages Maintenance of a Large Database 9/22/2022 18

19. Is Excel Database System? Yes, Excel can store large amounts of data in workbooks that contain one or more worksheets. However, instead of serving as a database management system, such as Access, Excel is optimized for data analysis and calculation. Introduction to Database 9/22/2022 19

20. Tip of the Day Booting and Startup Stages Introduction to Database 9/22/2022 20

21. Introduction to Database 9/22/2022 21

22. Introduction to Database 9/22/2022 22