DBMS

31. What is a SQL view? Briefly explain the use of views. A SQL view is a virtual table built from other tables or views. Views are used to (1) …

21. Explain the relationship between entity, entity class, and entity instance. An entity is something that can be identified in the users’ work environment, something that the users want to …

11. Discuss the alternative terminology that is used in the relational model. Relations are also called tables, and sometimes by the older data processing term files. A row is known …

1. What are data and information, and how are they related in a database? Data is recorded facts and figures, and information is knowledge derived from data. A database stores …

81. What is File Manager? It is a program module, which manages the allocation of space on disk storage and data structure used to represent information stored on a disk. …

71. Which part of the RDBMS takes care of the data dictionary? How? Data dictionary is a set of tables and database objects that is stored in a special area …

61. What do you mean by flat file database? It is a database in which there are no programs or user access languages. It has no cross-file capabilities but is …

51. What is Domain-Key Normal Form? A relation is said to be in DKNF if all constraints and dependencies that should hold on the the constraint can be enforced by …

41. What is normalization? It is a process of analysing the given relation schemas based on their Functional Dependencies (FDs) and primary key to achieve the properties (1).Minimizing redundancy, (2). …

30. What is SDL (Storage Definition Language)? This language is to specify the internal schema. This language may specify the mapping between two schemas.