Database Management System A Complete PPT for XII

ppt of DBMS

1. Database Languages

2. Types of Database Languages

3. Types of Database Languages

4. Types of Database Languages

5. Types of Database Languages

6. Types of Database Languages

7. Types of Database Languages

8. Types of Database Languages

9. Types of Database Languages

10. Types of Database Languages

11. Database Model

12. Types of Database Models Hierarchical Model Relational Database Model Network Model

13. Types of Database Models Hierarchical Model Relational Database Model Network Model Network Model

14. Types of Database Models Network Model

15. Types of Database Models Network Model

16. Types of Database Models Network Model

17. Types of Database Models Network Model

18. Types of Database Models Network Model Hierarchical Model

19. Types of Database Models Hierarchical Model

20. Types of Database Models Hierarchical Model

21. Types of Database Models Hierarchical Model Relational Database Model

22. Types of Database Models Relational Database Model

23. Types of Database Models Relational Database Model

24. Types of Database Models Relational Database Model

25. Types of Database Models Relational Database Model

26. Concept of Normalization

27. Concept of Normalization

28. Concept of Normalization

29. Centralized Database and Distributed Database

30. Centralized Database and Distributed Database Centralized Database and Distributed Database

31. Centralized Database and Distributed Database Centralized Database A centralized database is basically a type of database that is stored, located as well as maintained at a single location only. This type of database is modified and managed from that location itself. This location is thus mainly any database system or a centralized computer system. The centralized location is accessed via an internet connection (LAN, WAN, etc ). This centralized database is mainly used by institutions or organizations. 

32. Centralized Database and Distributed Database Centralized Database A centralized database is basically a type of database that is stored, located as well as maintained at a single location only. This type of database is modified and managed from that location itself. This location is thus mainly any database system or a centralized computer system. The centralized location is accessed via an internet connection (LAN, WAN, etc ). This centralized database is mainly used by institutions or organizations. 

33. Advantages:   Since all data is stored at a single location only thus it is easier to access and coordinate data. 2. The centralized database has very minimal data redundancy since all data is stored in a single place. 3. It is cheaper in comparison to all other databases available. Centralized Database and Distributed Database Centralized Database

34. Advantages:   Since all data is stored at a single location only thus it is easier to access and coordinate data. 2. The centralized database has very minimal data redundancy since all data is stored in a single place. 3. It is cheaper in comparison to all other databases available. Disadvantages: 1. The data traffic in the case of a centralized database is more. 2. If any kind of system failure occurs in the centralized system then the entire data will be destroyed. Centralized Database and Distributed Database Centralized Database

35. A distributed database is basically a type of database which consists of multiple databases that are connected with each other and are spread across different physical locations. The data that is stored in various physical locations can thus be managed independently of other physical locations. The communication between databases at different physical locations is thus done by a computer network.  Distributed Database Centralized Database Disadvantages: 1. The data traffic in the case of a centralized database is more. 2. If any kind of system failure occurs in the centralized system then the entire data will be destroyed. Centralized Database and Distributed Database

36. A distributed database is basically a type of database which consists of multiple databases that are connected with each other and are spread across different physical locations. The data that is stored in various physical locations can thus be managed independently of other physical locations. The communication between databases at different physical locations is thus done by a computer network.  Distributed Database Centralized Database and Distributed Database

37. Advantages: 1. This database can be easily expanded as data is already spread across different physical locations. 2. The distributed database can easily be accessed from different networks . 3. This database is more secure in comparison to a centralized database . Distributed Database Centralized Database and Distributed Database

38. Disadvantages: 1. This database is very costly and is difficult to maintain because of its complexity. 2. In this database, it is difficult to provide a uniform view to users since it is spread across different physical locations. Advantages: 1. This database can be easily expanded as data is already spread across different physical locations. 2. The distributed database can easily be accessed from different networks . 3. This database is more secure in comparison to a centralized database . Distributed Database Centralized Database and Distributed Database

39. Database Security

40. Database Security Elements of Data Security Confidentiality Integrity Availability

41. Database Security Elements of Data Security Confidentiality Integrity Availability Confidentiality Integrity Availability

42. Database Security Elements of Data Security Confidentiality Integrity Availability Different Levels of Data Security Physical Human Operating System Network

43. Different Levels of Data Security Database Security Physical Human Operating System Network Data Security Technologies Authentication Encryption Tokenization Data Masking Access Controls Backup and Recovery Installing Firewall Update Software Manage Physical Controls

44. Tokenization Encryption Data Security Technologies Database Security Authentication Data Masking Access Controls Backup and Recovery Installing Firewall Update Software Manage Physical Controls Authentication

45. Database Security Authentication Encryption

46. Encryption Database Security Tokenization

47. Tokenization Database Security Data Masking

48. Data Masking Database Security Access Controls

49. Access Controls Database Security Backup and Recovery

50. Backup and Recovery Database Security Installing Firewall

51. Installing Firewall Database Security Update Software

52. Update Software Database Security Manage Physical Controls