Que2.20. Describe indicators in SQL. Answer 1. indicators are special lookup tables that the database hunt machine can use to speed up data reclamation. 2. An indicator helps to speed up SELECT queries and WHERE clauses, but it slows down data input, with the UPDATE and the INSERT statements. 3. indicators can be created or … Read more

Que2.10. Write short note on SQL. Explain colorful characteristics of SQL. Answer 1. SQL stands for Structured Query Language. 2. It’s anon-procedural language that can be used for reclamation and operation of data stored in relational database. 3. It can be used for defining the structure of data, modifying data in the database and specifying … Read more

Que2.1. What’s relational model? Explain with illustration. Answer 1. A relational model is a collection of abstract tools for describing data, data connections, data semantics and thickness constraints. 2. It’s the primary data model for marketable data processing operations. 3. The relational model uses collection of tables to represent both data and the connections among … Read more

Que1.25. Explain the reduction of ER schema to tables. OR How to reduce an ER model into table? Answer 1. In ER model, database are represented using the different memos or plates, and these memos can be reduced to a collection of tables. 2. In the database, every reality set or relationship set can be … Read more

Que1.15. Compactly describe the overall structure of DBMS. OR Draw the overall structure of DBMS and explain its factors in Answer A database system is partitioned into modules that deal with each of the liabilities of the overall system. The functional factors of a database system can be astronomically divided into two factors 1. Storage … Read more