Actors on the scene - Classification of DBMS - Data Models
Know the actors in a DBMS: Database Administrator (DBA), Database Designers, Application Programmers, End Users, and System Analysts. Be able to explain the role of each actor.
Understand DBMS classification: DBMS can be classified as Hierarchical, Network, Relational, and Object-Oriented based on how data is organized and managed.
Learn the major data models: Hierarchical Model, Network Model, Relational Model, Entity-Relationship (ER) Model, and Object-Oriented Model. Know their basic structure and use cases.
Remember the most important model: The Relational Model is the most widely used because it stores data in tables (rows and columns) and uses SQL for data manipulation.
Practice comparison questions: Be able to differentiate Hierarchical vs Network vs Relational Models based on structure, relationships, flexibility, and examples.
List the types of Database users and discuss the roles of DBA.
Present the various users of the DBMS environment and their interactions with the components of the DBMS modules with a neat diagram.
Vtop web system is developed to feed the details of all the individuals at VIT, such as Deans, Faculties, Staff, and Students. Deans can track the complete details of faculties, staff, students, and faculties. Faculties can see their details and all the student's details. Students can view only the respective information needed for them. Software Development Cell solves when there is an issue in data retrieval, and it helps to keep track of the information relevant to their courses. a) Identify the actors and workers behind the screen involved while using the application system and their different roles. b) Clarify how the details are processed and retrieved across the various components in the Database System Architecture.
A university is developing an Integrated Academic Management System to handle student records, course registrations examinations, and result processing. The system is accessed by different types of users. The university uses a DBMS that interacts with several internal components like query processors, compilers, transaction managers, storage managers, and relies on operating systems, compilers, and utility software for smooth functioning. Answer the following questions based on the above scenario. a) Draw and explain the Database System Environment, clearly depicting the major components of a DBMS and their interactions. b) Identify the different categories of users involved in a DBMS. Explain the roles and responsibilities of any three types of users in detail.