Explain three tier architecture of database with the help of diagram.

Explain three tier architecture of database with the help of diagram.
by

1 Answer

Answer :

image

Application server or Web server

*Adds intermediate layer between client and the database server

*Runs application programs and stores business rules


Clients contain GUI interfaces and some additional applicationspecific business rules. The intermediate server accepts requests the clients, processes the requests and sends database commands to the database server and then acts as a conduit for passing (partially processed data from the database server to the clients, when it may be processed further and filtered to be presented to users in GUI format. Thus the user interfaces, application rules and the database acts as three tier. 

by

Related questions

Explain three level architecture of Database

Description : Explain three level architecture of Database

Last Answer : There are following three levels or layers of DBMS architecture: External Level : Describes part of the database that a particular user group is interested in. Conceptual Level: Describes structure of ... is the one that concerns the way the data are physically stored on the hardware.

Explain client/server database system.

Description : Explain client/server database system. 

Last Answer : 1. It has two logical parts client and server.  2. Computer networking allows some task to be executed on a server system and some tasks on client system. This leads to development ... as application server to receive and send requests from client machine to database server and vice versa.

Explain distributed database system with example.

Description : Explain distributed database system with example.

Last Answer : A distributed database is a database that consists of two or more files located in different sites either on the same network or on entirely different networks. Portions of the database ... Ignite, Apache Cassandra, Apache HBase, Couchbase Server, Amazon SimpleDB, Clusterpoint, and FoundationDB

Explain merits and demerits of Object Oriented Database model.

Description : Explain merits and demerits of Object Oriented Database model.

Last Answer : Object oriented models were introduced to overcome the shortcomings of conventional models like Relational, Hierarchical and network model. An object-oriented database is collection of objects whose behavior, state, ... . * There is no view mechanism * There is no adequate security mechanism.

Explain components of database in detail.

Description : Explain components of database in detail.

Last Answer : A database system involves four major components. 1. Data 2. Hardware 3. Software 4. Users

Describe the three levels of data abstraction with diagram.

Description : Describe the three levels of data abstraction with diagram. 

Last Answer : Three levels of data abstraction are:  Physical level: This is the lowest level of data abstraction. It describes how data is actually stored in database. The complex data structure details ... highest level of data abstraction. This level describes the user interaction with database system.

State characteristics of Database.

Description : State characteristics of Database.

Last Answer : The Characteristics of Database are: 1. Persistent Data 2. Meta Data and Self-describing nature of a DB 3. Insulation between programs and data (Data Independence) 4. Support ... Sharing of data and multiuser transaction processing 6. Access flexibility and Security. 7. Controlled Redundancy

List types of Database languages.

Description : List types of Database languages.

Last Answer : Four types of database languages are: 1. DDL (Data Definition Language) 2. DML (Data Manipulation Language) 3. DDL (Data Control Language) 4. TCL (Transaction control language)

Define the term Database Schema

Description : Define the term Database Schema

Last Answer : The overall design of the database is called the database schema. A schema diagram displays only names of record types (entities) and names of data items (attributes) and does not show the relationships among the various files. 

Describe centralized database system with example.

Description : Describe centralized database system with example. 

Last Answer : Centralized Database System: 1. A centralized database consists of a single data server into which all data are stored and from which all data are retrieved. All the data reside at a single location and ... is cheaper than other types of databases as it requires less power and maintenance. 

Compare file system and database system.

Description : Compare file system and database system. 

Last Answer : File system Database system  1. File processing don't contain any self describing feature and neither posses metadata.  1. Presence of Self-describing nature of a database system and Metadata. ... own file.  5. Controlling Redundancy is one of most important feature to use DBMS

Distinguish between network database model and relational database model.

Description : Distinguish between network database model and relational database model. 

Last Answer : Network database model Relational database model Relationship between records is expressed in the form of pointers or links Relationship between records is represented by a relation that contains a key for ... logically in the form of rows and columns. Example:  Example: 

Define database model.

Description : Define database model. 

Last Answer : Definition of database model: A database model is a type of data model that determines the logical structure of a database. It also fundamentally determines in which manner data can be stored, organized and manipulated. 

Define Database. List advantages of database system.

Description : Define Database. List advantages of database system. 

Last Answer : A database is an organized collection of data so that it can be easily accessed, managed and updated. Advantages of database system are the following:  1. Controlling ... Providing Backup and Recovery facilities is provide by DBMS for recovering from hardware or software failures.

Differentiate between Hierarchical Database model and network database model.

Description : Differentiate between Hierarchical Database model and network database model.

Last Answer : Hierarchical Database Model  Network Model Network Model represents tree like structure with one root. Network Model represents tree like structure with many roots. Reflects 1:N ( ... the use of pointers Record relationship implementation is complex due to the use of pointers

Explain different types of attribute with example and their symbols used in ER diagram.

Description : Explain different types of attribute with example and their symbols used in ER diagram.

Last Answer : Different types of attributes are: 1. Simple attribute: A simple attributes are those which cannot be subdivided. Eg:Rollno-  symbol 2. Composite attribute: a composite attribute is ... value can be calculated or determined from another attribute Eg: age from dateofbirth  Symbol

Architecture of the database can be viewed as (A) two levels. (B) four levels. (C) three levels. (D) one level.

Description : Architecture of the database can be viewed as (A) two levels. (B) four levels. (C) three levels. (D) one level.

Last Answer : (C) three levels

List the Optional Flexible Architecture (OFA) of Oracle database? or How can we organize the tablespaces in Oracle database to have maximum performance ?

Description : List the Optional Flexible Architecture (OFA) of Oracle database? or How can we organize the tablespaces in Oracle database to have maximum performance ?

Last Answer : SYSTEM - Data dictionary tables. DATA - Standard operational tables. DATA2- Static tables used for standard operations INDEXES - Indexes for Standard operational tables. INDEXES1 - Indexes of ... - Temporary purpose tablespace TEMP_USER - Temporary tablespace for users. USERS - User tablespace.

Which model assumes that systems are created fromreusable components, scripting or database programming? a) An application-composition model b) A post-architecture model c) A reuse model d) An early design model

Description : Which model assumes that systems are created fromreusable  components, scripting or database programming? a) An application-composition model b) A post-architecture model c) A reuse model d) An early design model

Last Answer : a) An application-composition model

extendible architecture is A. Modular design of a software application that facilitates the integration of new modules B. Showing a universal law or rule to be invalid by providing a counter example C. A set of attributes in a database table that refers to data in another table D. None of these

Description : extendible architecture is A. Modular design of a software application that facilitates the integration of new modules B. Showing a universal law or rule to be invalid by providing a counter example C. ... of attributes in a database table that refers to data in another table D. None of these

Last Answer : A. Modular design of a software application that facilitates the integration of new modules

Explain the architecture of Bluetooth technology with suitable diagram.

Description : Explain the architecture of Bluetooth technology with suitable diagram.

Last Answer : Bluetooth is short range wireless technology. Range of Bluetooth is 10 meters. Bluetooth Architecture defines 2 types of networks. 1)Piconet 2)Scatternet Piconet: - It is a Bluetooth network that ... . This node is called bridge slave. This node cannot be the master of two piconets.

Explain architecture of Intel chipset 945G with Diagram.

Description : Explain architecture of Intel chipset 945G with Diagram.

Last Answer : Architecture of Intel chipset 945G The Intel 945G chipset family includes 3 members 945G, 945P and 945TL. It supports Intel new dual core Pentium. Processor & also supports ... incorporates Intel graphic media accelerator integrated on board. It uses ICH7 which is faster than ICH6.

Explains DCS architecture with the help of a block diagram.

Description : Explains DCS architecture with the help of a block diagram.

Last Answer : DCS architecture: Block diagram: Explanation: In DCS equipment is separated in functional area and is installed in different work areas of a process plant. The plant operator ... has flexibility of implementation of sequential control and integration among the various types of control. 

Briefly explain the three-tier quasi-judicial machinery set up under the Consumer Protection Act of 1986. -SST 10th

Description : Briefly explain the three-tier quasi-judicial machinery set up under the Consumer Protection Act of 1986. -SST 10th

Last Answer : The government enacted a specific law called the Consumer Protection Act, 1985. Most important feature of the Act is the provision for setting up a three-tier system as follows : ... consumers against the traders and manufacturers and provide the necessary relief and compensation to the consumers.

Explain briefly the three-tier quasi-judicial machinery set up under the Consumer Protection Act of 1986. -SST 10th

Description : Explain briefly the three-tier quasi-judicial machinery set up under the Consumer Protection Act of 1986. -SST 10th

Last Answer : Any consumer who receives a service in whatever capacity, regardless of age,gender and nature of service has the right to choose' whether to continue to receive the service. Example: Suppose you ... is denied. The consumer has every right to purchase only those things that he wants to purchase.

Explain the three services model commonly know as a three-tier application.

Description : Explain the three services model commonly know as a three-tier application.

Last Answer : Presentation (UI), Business (logic and underlying code) and Data (from storage or other sources).

Explain the three services model commonly know as a three-tier application.

Description : Explain the three services model commonly know as a three-tier application.

Last Answer : Presentation (UI), Business (logic and underlying code) and Data (from storage or other sources). 

Explain various types of Relational constraints.

Description : Explain various types of Relational constraints.

Last Answer : Relational Constraints Relational constraints are a set of rules. It is used to maintain the quality of information. Integrity constraints ensure that the data insertion, updating, and other ... - It establishes parent child relationship between two tables. For example :Foreign key constraints 

Explain advantages of centralized and distributed databases.

Description : Explain advantages of centralized and distributed databases.

Last Answer : Advantage of Centralized databases   * Data integrity is maximized -Data integrity is maximized and data redundancy is minimized because data is stored at a single place.  * Easier Database Administration - ... data is distributed, a group of users can easily share and use data of different sites

Explain Codd’s rules.

Description : Explain Codd’s rules.

Last Answer : Codd rules:  Rule 1: The information rule a has to be presented to the user should be in the form of table.  Rule 2: Guaranteed Access Rule Whole data should be available or ... interface cannot be used to subvert the system, for example, bypassing a relational security or integrity constraint

Explain functional dependency with example.

Description : Explain functional dependency with example.

Last Answer : A functional dependency occurs when one attribute in a relation uniquely determines another attribute. OR Consider a relation say R(X,Y), where X and Y are one or more than one attribute, ... sscper. That is, given rollno of a student, the name and sscper can be determined or searched.

Explain Domain constraints with Syntax and example.

Description : Explain Domain constraints with Syntax and example. 

Last Answer : Domain constraints are used to maintain value according to user specification Domain constraints are: 1. Not null-such constraints are applied to an attribute when we have to specify that the ... datatype(size),attr2 datatype(size) constraint nameofconstraint check(attr<value)); or

Explain Generalization with example.

Description : Explain Generalization with example.

Last Answer : Generalization uses bottom-up approach where two or more lower level entities combine together to form a higher level new entity if they have common attributes in common. The new generalized entity can ... Example, STUDENT and FACULTY can be generalized to a higher level entity called PERSON

Describe enhanced ER model with the help of example.

Description : Describe enhanced ER model with the help of example. 

Last Answer : Enhanced ER is a high-level data model that incorporates the extensions to the original ER model. It is created to design more accurate database schemas. EER reflects data properties and constraints more precisely ... example: Square, Circle, Triangle are the sub class of Shape super class. 

Name the three tier government system in India. What steps have been taken by the government to make the third tier more powerful and effective ? -SST 10th

Description : Name the three tier government system in India. What steps have been taken by the government to make the third tier more powerful and effective ? -SST 10th

Last Answer : Three tier system : 1. Union Government 2. State Governments 3. Local Governments. Steps : Now, it is constitutionally mandatory to hold regular elections to the local government bodies. ... powers and revenue with the Local government bodies. The nature of sharing varies from state to state.

Mention the three tier system prevailing in India. -SST 10th

Description : Mention the three tier system prevailing in India. -SST 10th

Last Answer : (i) Union Government (ii) State Government (iii) Local Government

Analyse the importance of the three-tier judicial machinery under Consumer Protection Act (COPRA), 1986 for redressal of consumer disputes. -SST 10th

Description : Analyse the importance of the three-tier judicial machinery under Consumer Protection Act (COPRA), 1986 for redressal of consumer disputes. -SST 10th

Last Answer : The Consumer Protection Act (COPRA) was enacted in 1986 in the light of increasing exploitation and unfair trade practices that took place in the market. Under COPRA, three-tier quasijudicial ... has enabled consumers to have the right to represent in the consumer courts at various levels.

What is the three-tier quasi-judicial machinery in India under COPRA? -SST 10th

Description : What is the three-tier quasi-judicial machinery in India under COPRA? -SST 10th

Last Answer : Under COPRA, a three-tier quasi-judicial machinery at district, state and national levels has been setup for redressal of consumer disputes. (i) The district level court deals with the cases involving ... the act has enabled us as consumers to have the right to represent in the consumer courts.

Describe the three-tier system of Indian federation ? -SST 10th

Description : Describe the three-tier system of Indian federation ? -SST 10th

Last Answer : Three-tier system means three levels of government. The Indian constitution was originally provided for a two-tier system of government: (i) The Union Government or the Central ... of Panchayats at rural level and municipalities at urban level. Every level enjoys separate jurisdiction.

How has a three-tier quasi-judicial machinery been Set-up for redressal of consumer disputes? -SST 10th

Description : How has a three-tier quasi-judicial machinery been Set-up for redressal of consumer disputes? -SST 10th

Last Answer : (i) A major step was taken in 1986 by the Indian government when it enacted the Consumer Protection Act, 1986, popularly known as COPRA. (ii) A three-tier quasi-judicial machinery, popularly known ... Thus, the Act has enabled us as consumers to have the right to represent in the consumer courts.

Which is at the apex of the-three tier system of Panchayati Raj ? -General Knowledge

Description : Which is at the apex of the-three tier system of Panchayati Raj ? -General Knowledge

Last Answer : The answer is 'ZilaParishad '

Which is at the apex of the-three tier system of Panchayati Raj ? -Do You Know?

Description : Which is at the apex of the-three tier system of Panchayati Raj ? -Do You Know?

Last Answer : answer:

Which is at the apex of the-three tier system of Panchayati Raj ? -General Knowledge

Description : Which is at the apex of the-three tier system of Panchayati Raj ? -General Knowledge

Last Answer : Gram Panchayat is at the apex of the three tier system of Panchayati Raj.

What is the system of governance in the Panchayati Raj set up? (1) Single tier structure of local self govt. at the village level (2) Two tier system of local self govt. at the village and block levels. (3) Three tier structure of local self govt. at the village, block and district levels. (4) Four tier system of local self govt. at the village, block, district and state levels.

Description : What is the system of governance in the Panchayati Raj set up? (1) Single tier structure of local self govt. at the village level (2) Two tier system of local self govt. at the village and block ... levels. (4) Four tier system of local self govt. at the village, block, district and state levels.

Last Answer : (3) Three tier structure of local self govt. at the village, block and district levels. Explanation: Part IX of the constitution envisages a 3-tier system of panchayats, namely (1) the village level (2) the district panchayat (district-level) (3) The intermediate panchayat (block-level)

The three-tier Panchayat Raj system in India was proposed by the – (1) Balwant Rai Mehta Committee (2) Ashok Mehta Committee (3) Royal Commission (4) None of the above

Description : The three-tier Panchayat Raj system in India was proposed by the – (1) Balwant Rai Mehta Committee (2) Ashok Mehta Committee (3) Royal Commission (4) None of the above

Last Answer : (1) Balwant Rai Mehta Committee Explanation: The Balwant Rai Mehta Committee was a committee appointed by the Government of India in January 1957 to examine the working of the Community Development ... village level, Panchayat Samiti at the block level, and Zila Parishad at the district level.

What is the system of Local Self Government in the Panchayati Raj set up? (1) Four tier system at the village, block, district and State level (2) Three tier structure at village, block and district level (3) Two tier system at village and block level (4) Single tier set up at village level

Description : What is the system of Local Self Government in the Panchayati Raj set up? (1) Four tier system at the village, block, district and State level (2) Three tier structure at village, block and district level (3) Two tier system at village and block level (4) Single tier set up at village level

Last Answer : (2) Three tier structure at village, block and district level Explanation: Panchayat Raj is a system of governance in which gram panchayats are the basic units of administration. It has 3 levels: Gram (village, though it can comprise more than one village), Janpad (block) and Zilla (district).

Three-tier system of Panchayati Raj consists of - (1) Grain Panchayat, Panchayat Samiti, Block Samiti (2) Grain Panchayat, Block Samiti, Zila Parishad (3) Gram Panchayat, Panchayat Samiti, Zila Parishad (4) Gram Panchayat, Zila Parishad, Block Samiti

Description : Three-tier system of Panchayati Raj consists of - (1) Grain Panchayat, Panchayat Samiti, Block Samiti (2) Grain Panchayat, Block Samiti, Zila Parishad (3) Gram Panchayat, Panchayat Samiti, Zila Parishad (4) Gram Panchayat, Zila Parishad, Block Samiti

Last Answer : (3) Gram Panchayat, Panchayat Samiti, Zila Parishad Explanation: Panchayati Raj is a system of governance in which are the basic unit of administrations . It has 3 levels: Gram panchayat ( ... Mandal Parishad or block samiti or panchayat samiti (block level) and Zila parishad (district level).

Which among the following legislation gives constitutional status to three-tier Panchayati Raj system? (1) 72nd constitutional amendment, 1992 (2) 73rd constitutional amendment, 1993 (3) 74th constitutional amendment, 1993 (4) 75th constitutional amendment, 1994

Description : Which among the following legislation gives constitutional status to three-tier Panchayati Raj system? (1) 72nd constitutional amendment, 1992 (2) 73rd constitutional amendment, 1993 (3) 74th constitutional amendment, 1993 (4) 75th constitutional amendment, 1994

Last Answer : (2) 73rd constitutional amendment, 1993 Explanation: The philosophy of Panchayat Raj is deeply steeped in tradition and culture of rural India and is by no means a new concept. Panchayati ... Amendment) Act, 1992 came into force to provide constitutional status to the Panchayati Raj institutions.

Which committee had first of all recommended three-tier Panchayati Raj in India in 1957? (1) Balwant Rai Committee (2) Ashok Mehta Committee (3) Setalwad Committee (4) Hanumantayaa Committee

Description : Which committee had first of all recommended three-tier Panchayati Raj in India in 1957? (1) Balwant Rai Committee (2) Ashok Mehta Committee (3) Setalwad Committee (4) Hanumantayaa Committee

Last Answer : (1) Balwant Rai Committee Explanation: Balwant Rai Mehta Committee had first of all recommended three-tier Panchayati Raj in India in 1957. The Act aims to provide a 3-tier system of Panchayati ... all States having a population of over 2 million, to hold Panchayat elections regularly every 5 years.

Which part of our Constitution envisages a three tier system of Panchayat? (1) Part IX (2) Part X (3) Part XI (4) Part XII

Description : Which part of our Constitution envisages a three tier system of Panchayat? (1) Part IX (2) Part X (3) Part XI (4) Part XII

Last Answer : (1) Part IX Explanation: Part IX of the constitution under article 243-C deals with Composition of Panchayats