DBMS questions with complete solutions 2023

DBMS questions with complete solutions 2023Database collection of related data and data is a collection of facts and figures that can be processed to produce information. Database Management System or DBMS refers to the technology of storing and retrieving users' data with utmost efficiency along with appropriate security measures database management system stores data in such a way that it becomes easier to retrieve, manipulate, and produce information. Administrators maintain the DBMS and are responsible for administrating the database. They are responsible to look after its usage and by whom it should be used. They create access profiles for users and apply limitations to maintain isolation and force security. Designers group of people who actually work on the designing part of the database. They keep a close watch on what data should be kept and in what format. They identify and design the whole set of entities, relations, constraints, and views. End Users those who actually reap the benefits of having a DBMS. Data models define how the logical structure of a database is modeled. Fundamental entities to introduce abstraction in a DBMS. Define how data is connected to each other and how they are processed and stored inside the system. Entity-Relationship (ER) Model based on the notion of real-world entities and relationships among them. Entity An entity in an ER Model is a real-world entity having properties called attributes. domain Every attribute is defined by its set of values called Relationship The logical association among entities A database schema skeleton structure that represents the logical view of the entire database.