How to create views in SQL? Explain with an example. Answer:- In SQL, the command to create a view is CREATE VIEW. Views are given a virtual table name, a list of attribute names, and a query to specify their…
Explain types of DBMS users Answer:-
Explain different types of user-friendly interfaces Answer:- Menu-Based Interfaces for Web Clients or Browsing: These interfaces present the user with lists of options (called menus) that lead the user through the formulation of a request. There is no need for…
Advantages of Database Approach Answer:- Advantages of Database Approach: Let me know if you need more information or clarification on any of these points!
Characteristics of the Database Approach Answer:- The main characteristics of the database approach are the following: Self-Describing Nature of a Database System A fundamental characteristic of the database approach is that the database system contains not only the database itself…
Explain Data Independence Answer:- Data independence can be defined as the capacity to change the schema at one level of a databasesystem without having to change the schema at the next higher level. We can define two types ofdata independence:…
With a neat diagram, explain three schema architectures Answer:- The goal of the three-schema architecture is to separate the user applications from the physicaldatabase. In this architecture, schemas can be defined at the following three levels: In a DBMS based…
Give a detailed comparison between pure ALOHA and slotted ALOHA Answer:-
Explain Selective Repeat in detail Answer:-
Describe Go-Back-N in detail Answer:-
