Que1.1. What’s database operation system( DBMS)? What are the tasks performed by druggies in DBMS? Answer 1. Database operation system( DBMS) is a software which is use to manage the database. For illustration, MySQL, Oracle, are marketable database which is used in different operations. 2. DBMS provides an interface to perform colorful operations like database creation, storing data, streamlining data, creating a table in the database 3. It provides protection and security to the database. In case of multiple druggies, it also maintains data thickness. DBMS allows druggies the following tasks 1. Data description It’s used for creation, revision, and junking of database objects that defines the association of data in the database. 2. Data updation It’s used for the insertion, revision, and omission of the factual data in the database. 3. Data reclamation It’s used to recoup the data from the database which can be used by operations for colorful purposes. 4. stoner administration It’s used for registering and covering druggies, maintaining data integrity, administering data security, dealing with concurrency control, covering performance and recovering information corrupted by unanticipated failure. Que1.2. What are the advantages and disadvantages of DBMS? Answer Advantages of DBMS 1. Database redundancy It controls data redundancy because it stores all the data in one single database train and that recorded data is placed in the database. 2. Data participating In DBMS, the authorized druggies of an association can partake the data among multiple druggies. 3. Easy conservation It can be fluently justifiable due to the centralized nature of the database system. 4. Reduce time It reduces development time and conservation need. 5. Provisory It provides backup and recovery subsystems which produce automatic backup of data from tackle and software failures and restores the data if needed. 6. Multiple stoner affiliate It provides different types of stoner interfaces like graphical stoner interface, operation program interface. Disadvantages of DBMS 1. Cost of tackle and software It requires high speed of data processor and large memory size to run DBMS software. 2. Size It occupies a large space of disks and large memory to run efficiently. 3. Complexity Database system creates fresh complexity and conditions. 4. Advanced impact of failure Failure is largely impacted the database because in utmost of the association, all the data stored in a single database and if the database is damaged due to electric failure or database corruption also the data may be lost ever. Que1.3. What do you understand by database druggies? Describe the different types of database druggies. Answer Database druggies are the bone
who use and take the benefits of database. The different types of druggies depending on the need and way of penetrating the database are 1. operation programmers They’re the inventors who interact with the database by means of DML queries. b. These DML queries are written in the operation programs like C, C, JAVA, Pascaletc. c. These queries are converted into object law to communicate with the database. 2. Sophisticated druggies They’re database inventors, who write SQL queries to elect insert/ delete/ update data. b. They directly interact with the database by means of query language like SQL. c. These druggies can be scientists, masterminds, judges who completely study SQL and DBMS to apply the generalities in their demand. 3. Specialized druggies a. These are also sophisticated druggies, but they write special database operation programs. They’re the inventors who develop the complex programs according to the demand. 4. Standalone druggies a. These druggies will have standalone database for their particular use. b. These kinds of database will have predefined database packages which will have menus and visual interfaces. 5. Native druggies a. These are the druggies who use the being operation to interact with the database. b. For illustration, online library system, ticket booking systems, ATMs Que1.4. Who are data directors? What are the functions of database director? OR bandy the part of database director. Answer Database directors are the labor force’s who has control over data and programs used for penetrating the data. Functions/ part of database director( DBA) 1. Schema description Original database schema is defined by DBA. b. This is fulfilled by writing a set of delineations, which are restated by the DDL compiler to a set of markers that are permanently stored in the data wordbook. 2. Storage structure and access system description a. The creation of applicable storehouse structure and access system. b. This is fulfilled by writing a set of delineations, which are restated by the data storehouse and description language compiler. 3. Schema and physical association and revision revision of the database schema or the description of the physical storehouse association. b. These changes are fulfilled by writing a set of description to do revision to the applicable internal system tables. Database Management System 1 – 5 A( CS/ IT- Sem- 5) 4. Granting of authorization for data access DBA subventions different types of authorization for data access to the colorful druggies of the database. 5. Integrity constraint specification DBA carry out data administration in data wordbook such as defining constraints. Que1.5. What’s data abstraction? Explain different situations of abstraction. Answer Data abstraction is the process of chancing inapplicable details from stoner i.e., hiding the background details from the druggies. Different situations of data abstraction 1. Physical position Physical position is the smallest position of abstraction and describes how the data are actually stored. ii. The physical position describes the complex low- position data structures in details. 2. Logical position Logical position is the coming-advanced position of abstraction and it describes what data are stored in the database, and what relationship exists among those data. ii. The logical position therefore describes the entire database in terms of a small number of fairly simple structures. 3. View position View position is the loftiest position of abstraction; it describes only part of the entire database. ii. The view position of abstraction exists to simplify their commerce with the system. iii. The system may give numerous views for the same database. Que1.8. bandy the armature of DBMS. What are the types of DBMS armature? Answer 1. The DBMS design depends upon its armature. The introductory customer/ garçon armature is used to deal with a large number of PCs, web waiters, database waiters and other factors that are connected with networks. 2. DBMS armature depends upon how druggies are connected to the database to get their request done. Types of DBMS armature 1- league armature 1. In this armature, the database is directly available to the stoner. 2. Any changes done are directly done on the database itself. It does not give a handy tool for end druggies. 3. The 1- league armature is used for development of the original operation, where programmers can directly communicate with the database for the quick response. ii. 2- league armature 1. The 2- league armature is same as introductory customer- garçon. 2. In the two- league armature, operations on the customer end can directly communicate with the database at the garçon side. For this commerce, API’s similar as ODBC, JDBC are used. 2. The stoner interfaces and operation programs are run on the customer- side. 3. DBMS provides a crash recovery medium, i.e., DBMS protects the data from the system failure. 4. DBMS provides a good protection medium. 5. DBMS can efficiently store and recoup the data. 6. DBMS takes care of concurrent access of data using some form of locking. train system don’t have a crash medium, i.e., if the system crashes while entering some data, also the content of the train will lost. It’s veritably delicate to cover a train under the train system. train system can not efficiently store and recoup the data. In the train system, concurrent access has numerous problems like turning the train while other deleting some information or streamlining some information. 3. The garçon side is responsible to give the functionalities like query processing and sale operation. 4. To communicate with the DBMS, customer- side operation establishes a connection with the garçon side. iii. 3- league armature 1. The 3- league armature contains another subcaste between the customer and garçon. In this armature, customer can not directly communicate with the garçon. 2. The operation on the customer- end interacts with an operation garçon which further communicates with the database system. 3. End stoner has no idea about the actuality of the database beyond the operation garçon. The database also has no idea about any other stoner beyond the operation. 4. The 3- league armature is used in case of large web operation.
