System Analysts are the type of database users in DBMS who analyze the requirements of Naive / Parametric End users. In simple terms, Naive / Parametric End users work directly on developed applications to access the database indirectly for getting the desired results.įor example: Railway ticket booking users in general are naive/parametric end users as they don't have much knowledge about DBMS and directly use railway booking application to book their tickets. Naive users don't need to be aware of the presence of the database system as they can interact with the database with the help of menu-driven application interface. With the help of the interface provided by the DBMS applications, Naive users mostly use the database to fill in or retrieve the information (view level of the database). Naive users also known as Parametric End users, don't have any knowledge of DBMS but still frequently use the database applications to get the desired results. They decide which form of data needs to be stored, what kind of relations exist among different entities of the database, what will be the type of attributes etc. which complete the database.ĭatabase designers try to gather information depending upon the requirements related to the database like the layout, looks, database functioning, costing, technologies to be used & implementation techniques, and finally, they design the final layout of the database for programmers to code its logic.ĭatabase Designers are the type of database users in DBMS who are responsible for implementing the overall design of the database. Who are Database Designers?Īs the name suggests, Database Designers are the users in DBMS who design and create the structure of the database including triggers, indexes, schemas, entity relationships, tables, constraints, etc. If the technical team raises any concern, DBAs have to resolve it. They are also responsible for handling data loss, which can be caused due to any error or even due to system failures.Īlso, Database Administrators (DBAs) monitor the backup & recovery of the database records and provide technical support as well. They have to update the database timely in terms of technology, functionality, and workflow in order to meet future requirements and in making the database ready for future scope.ĭatabase Administrators (Database admins) are also responsible to keep a check on data integrity, data consistency, data redundancy, hardware and software installation requirements, and routine maintenance of the databases. Database Administrators (DBAs) are solely responsible for providing security to the database by restricting unauthorized users from accessing the database.ĭatabase Administrators (DBAs) have all the privileges allowed by the DBMS. In order to access the database, DBAs have to provide login credentials (account ID and password) to all other users when required. They work alongside developers in order to discuss and design the overall structure of the database including layouts, functionalities, workflow, etc.ĭatabase Administrators (DBAs) can grant or revoke authorization permission to all other users at any point of time.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |