1 / 33

Prepared by K.Padmaja , Lecturer in CME K.Subrahmanyam , Lecturer in CME

Learn about the roles of Database Manager and Administrator, responsibilities, functions, and user types in the realm of Database Management. Understand data definition and manipulation languages.

breilly
Download Presentation

Prepared by K.Padmaja , Lecturer in CME K.Subrahmanyam , Lecturer in CME

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. e – Lesson Module for C-16 Curriculum State Board of Technical Education & Training Andhra Pradesh Year/Semester : III Semester Branch : Computer Engineering Subject : CM-305,DBMS Topic : Concepts of DBMS & RDBMS Sub Topic : Explain Database Manager, Explain Database Administrator and Users Duration : 50 min Prepared by K.Padmaja, Lecturer in CME K.Subrahmanyam, Lecturer in CME At A.A.N.M&V.V.R.S.R POLYTECHNIC , GUDLAVALLERU C_16_CME_305_1.9_1.10

  2. On completion of this period you would be able to Main Objectives of this lesson • Explain data base manager • Explain the Responsibilities of the Database Manager • Explain the Functions and Responsibilities of the Database Administrator • Explain about the Different users in Database Management System C_16_CME_305_1.9_1.10

  3. RECAP In the previous lesson, you have learn • Data definition language • Data manipulation language C_16_CME_305_1.9_1.10

  4. Data definition language: • Specification notation for defining the database schema • A Data base is specified by Data definition language e.g.:- Create, Alter, Drop table C_16_CME_305_1.9_1.10

  5. Data manipulation language: • Enables users to access or manipulate data as organized by the appropriate data model C_16_CME_305_1.9_1.10

  6. What is database? • Collection of data • Contains information about particular enterprise C_16_CME_305_1.9_1.10

  7. Who is a database Manager? • Responsible for ensuring that the database remains in a correct state despite system failures . • Ensures proper functioning of the DBMS Click Here To View Video on Functions of Database Manager C_16_CME_305_1.9_1.10

  8. Responsibilities of Database Manager (DBM) Define various transactions: • Each transaction preserves the consistency of the database(Correct data) Atomicity property: • Failed transaction cause no change on state of the database C_16_CME_305_1.9_1.10

  9. Responsibilities of Database Manager (DBM) Contd . . . Detecting system failures • Restore the database to a state that existed prior to the occurrence of the failure Maintain consistency of the database • To ensure control on the interaction among the concurrent transactions C_16_CME_305_1.9_1.10

  10. Responsibilities of Database Manager (DBM) Contd . . . Security Enforcement • Ensuring that users only have access to information they are permitted to see C_16_CME_305_1.9_1.10

  11. DBM is an interface To provide the interface between the • low-level data stored in database • the application programs • Transactions submitted to the system C_16_CME_305_1.9_1.10

  12. Who is Database Administrator? • Central control of both data and the programs that access those data is called DBA C_16_CME_305_1.9_1.10

  13. Responsibilities of the DBA: • Ensuring security to the database • Providing data Integrity • Restricting accessibility to unauthorized users • Taking backups C_16_CME_305_1.9_1.10

  14. Functions of Database Administrator Schema Definition • Creates the Original database schema • The definitions are translated by DDL compiler to a set of tables stored in the data dictionary C_16_CME_305_1.9_1.10

  15. Functions of Database Administrator Contd . . . Storage structure and Access-method Definition • DBA creates appropriate storage structures and access methods by writing set of definitions • The definitions are translated by Data storage and data definition language compiler C_16_CME_305_1.9_1.10

  16. Functions of Database Administrator Contd . . . Schema and Physical-Organization Modification • DBA allows the users to accomplish modifications in the database schema through a set of definitions Grant of Authorization for Data Access • DBA granting different types of authorizations for data access to various users C_16_CME_305_1.9_1.10

  17. Integrity Constraints Specification Functions of Database Administrator Contd . . . • Integrity Constraints are specified by DBA • The Integrity Constraints are kept in a special system structure that is consulted by the database system C_16_CME_305_1.9_1.10

  18. Database Administrator jobs • Participate in database and application development • Develop procedures for integrity and quality of data • Facilitate changes to database structure • Participate in database design and dictionary • Modify database structure C_16_CME_305_1.9_1.10

  19. Database Administrator jobs Contd . . . • Evaluate and implement new DBMS features • Tune the database • Develop, document, and train staff on backup and recovery procedures • Controlling and monitoring user access to the database • Publish and Maintain data activity standards documentation C_16_CME_305_1.9_1.10

  20. Database Users • The primary goal of a database system is to provide an environment for retrieving information from and storing new information into the database. • The persons who are authorized to use database for storing and retrieval of data. Click Here To View Video on Database Users C_16_CME_305_1.9_1.10

  21. Different types of database users: • Application programmers • Are computer professionals interact with the system through DML calls • Sophisticated Users • Interact with the system without writing programs • They form requests by writing queries in a database query language C_16_CME_305_1.9_1.10

  22. Different types of database users: Contd . . . • Specialized Users • Users are sophisticated users writing special database application programs • These may be CADD Systems, Knowledge-based and expert systems , complex data systems, etc C_16_CME305_1.9_1.10

  23. Different types of database users: Contd . . . • Unsophisticated Users or Naïve Users • Users who interact with the system by using permanent application program e.g: people accessing database over the web, bank tellers, clerical staff C_16_CME_305_1.9_1.10

  24. In this class, you have learnt Summary • Who is Database Manager • Responsibilities of the Database Manager • Who is Database Administrator • Different functions of the Database Administrator • Different Responsibilities of the Database Administrator • Different users of Database system C_16_CME_305_1.9_1.10

  25. Assignment questions 1.What is DBM 2.What is DBA 3.Explain the Responsibilities of the Database Manager? 4. Explain the Responsibilities of the Database Administrator? C_16_CME_305_1.9_1.10

  26. Quiz C_16_CME_305_1.9_1.10

  27. 1. DBM act as an interface • No • Yes • Unknown C_16_CME_305_1.9_1.10

  28. 1. DBM act as an interface • No • Yes • Unknown C_16_CME_305_1.9_1.10

  29. 2. DBM maintains inconsistency of the database • Yes • No • Unknown C_16_CME_305_1.9_1.10

  30. 2. DBM maintains inconsistency of the database • Yes • No • Unknown C_16_CME_305_1.9_1.10

  31. 3. DBM detects system failures • No • Yes • Unknown CM503.8

  32. 3. DBM detects system failures • No • Yes • Unknown C_16_CME_305_1.9_1.10

  33. Thank You C_16_CME_305_1.9_1.10

More Related