Describe centralized database system with example.

Describe centralized database system with example. 
by

1 Answer

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 all applications must retrieve all data from that location. 2. The centralized database system consists of a single processor together with its associated data storage devices and other peripherals. It is physically confined to a single location. 3. Data can be accessed from the multiple sites with the use of a computer network while the database is maintained at the central site 

Following are the advantages of centralised database system:

  • The data integrity is maximized
  • The data redundancy is minimal.
  • Centralized database is much more secure.
  • Data is easily portable because it is stored at the same place.
  • The centralized database is cheaper than other types of databases as it requires less power and maintenance. 

by

Related questions

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 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 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.

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

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.

Describe client server system with example.

Description : Describe client server system with example.

Last Answer : Client server system consists of two logical components. One is Client and the other one is Server . Clients are those who send the request to perform a specific task to the server. ... client's CPU and memory. But server runs a database management system which manages the whole database.

A database that contains tables linked by common fields is called a (a) Centralized database (b) Flat file database -Technology

Description : A database that contains tables linked by common fields is called a (a) Centralized database (b) Flat file database -Technology

Last Answer : (c) Relational database stores data in the form of tables which are linked by common fields.

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.

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. 

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. 

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.

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 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

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

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

Last Answer : 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 ... GUI format. Thus the user interfaces, application rules and the database acts as three tier. 

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. 

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.

Describe object-oriented data models.

Description : Describe object-oriented data models.

Last Answer : Object Oriented Model : 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 ... with other objects. It is also said to be semantic data model.

Describe benefits and drawbook of denormalization.

Description : Describe benefits and drawbook of denormalization.

Last Answer : Benefits of denormalization: * Reduce number of relations: It reduce the number of relations because it combines two relations into one new relation. * Reduce number of foreign keys: It reduce number ... : It is always application-specific and needs to be re-evaluated if the application changes. 

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 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

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

An organizational system in which responsibility and authority are delegated to lower levels of sales management is called 1. decentralized organization 2. centralized organization 3. both 1 & 2 4. regional organization 5. none of these

Description : An organizational system in which responsibility and authority are delegated to lower levels of sales management is called 1. decentralized organization 2. centralized organization 3. both 1 & 2 4. regional organization 5. none of these

Last Answer : decentralized organization

Distinguish between file processing system and DBMS.

Description : Distinguish between file processing system and DBMS.

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

Why is the world so America-centralized?

Description : Why is the world so America-centralized?

Last Answer : I think it's fairly simple: weaponry and borrowing. We have more military power by an order of magnitude than any other nation. If you're a kid on the playground, and the bully is there, too, you keep an eye on ... won't be a dog. It'll be a cat. A cat that knows it is the center of the universe.

Very distinct question: is there are a way to view your documents in pages for mac, the same way as you can in ms word - which means centralized?

Description : Very distinct question: is there are a way to view your documents in pages for mac, the same way as you can in ms word - which means centralized?

Last Answer : I don’t have pages, but under your Document settings, can you select “View Margins”?

Best spot in US for a centralized business meeting for people from all states?

Description : Best spot in US for a centralized business meeting for people from all states?

Last Answer : Check out Kansas City --should be pretty good in September. KCMO is a surprisingly cool city (was there for a wedding recently).

What program can I use to scan my HD for HTML templates I have and create a centralized thumbail catalog?

Description : What program can I use to scan my HD for HTML templates I have and create a centralized thumbail catalog?

Last Answer : Need this too, thanks.

Centralized or Distributed?

Description : Centralized or Distributed?

Last Answer : answer:To clarify, I've been thinking about a lot of different question systems: Ask-public, the questions that are asked on News.yc, reddit, the new programming forum proposed by Joel Spolsky, and was ... better to mix it all together in a soup of coal, nuclear, wind, solar, hydro, hamster?

What is a Centralized Network ?

Description : What is a Centralized Network ?

Last Answer : Answer : A centralized network is a main computer or host computer which we call a server and consists of some terminals. The main computer or server controls all processing and network and ... Intelligent terminals, on the other hand, have limited memory and storage and processing capabilities.

Who is the founder of centralized governance ?

Last Answer : Qing Sihuan, founder of centralized governance

Would you rather live in a highly centralized and powerful state such as Great Zimbabwe or the Kingdom of Mali or would you rather live in a more locally governed region such as the Congo Forest or th?

Description : Would you rather live in a highly centralized and powerful state such as Great Zimbabwe or the Kingdom of Mali or would you rather live in a more locally governed region such as the Congo Forest or th?

Last Answer : I would rather live in a highly centralized and powerfulstate.

What is the most widely held ideal of the US political culture belief in a limited government that protects individual liberties belief in a unitary government and centralized decision making belief i?

Description : What is the most widely held ideal of the US political culture belief in a limited government that protects individual liberties belief in a unitary government and centralized decision making belief i?

Last Answer : What is the answer ?

Would you rather live in a highly centralized and powerful state such as Great Zimbabwe or the Kingdom of Mali or would you rather live in a more locally governed region such as the Congo Forest or th?

Description : Would you rather live in a highly centralized and powerful state such as Great Zimbabwe or the Kingdom of Mali or would you rather live in a more locally governed region such as the Congo Forest or th?

Last Answer : I would rather live in a highly centralized and powerfulstate.

If both the 'high level' and 'low level' alarms come on for the same address of a centralized control console, the most likely problem is a/an ____________. A. sensor failure B. failed alarm C. low level D. extremely high level

Description : If both the 'high level' and 'low level' alarms come on for the same address of a centralized control console, the most likely problem is a/an ____________. A. sensor failure B. failed alarm C. low level D. extremely high level

Last Answer : Answer: A

Which of the followings is not a feature of centralized government

Description : Which of the followings is not a feature of centralized government

Last Answer : Judicial review

Which of the followings is not a feature of centralized government

Description : Which of the followings is not a feature of centralized government

Last Answer : Judicial review

Benefits to using computer-aided software engineering (CASE) include faster task completion and alteration, centralized development information, and illustration of information through diagrams.

Description : Benefits to using computer-aided software engineering (CASE) include faster task  completion and alteration, centralized development information, and illustration of  information through diagrams.

Last Answer : Ans: True

The abbreviation CTMO stands for a) Central Transit Mail office b) Centralized transit mail office c) Computerized transit mail office d) Circle transit mail office

Description : The abbreviation CTMO stands for a) Central Transit Mail office b) Centralized transit mail office c) Computerized transit mail office d) Circle transit mail office

Last Answer : d) Circle transit mail office

Which of the following is not a characteristic of Indian planning? a. developmental planning b. indicative planning c. democratic planning d. centralized planning

Description : Which of the following is not a characteristic of Indian planning? a. developmental planning b. indicative planning c. democratic planning d. centralized planning

Last Answer : d. centralized planning

Who said that ‘‘dispersed solar sources are more compatible than centralized technologies withsocial equity, freedom and cultural pluralism.’’ a. Mumford. b. Denis Hayes. c. Louise. d. None of the above.

Description : Who said that ‘‘dispersed solar sources are more compatible than centralized technologies withsocial equity, freedom and cultural pluralism.’’ a. Mumford. b. Denis Hayes. c. Louise. d. None of the above.

Last Answer : b. Denis Hayes.

Who said that ‘‘dispersed solar sources are more compatible than centralized technologies withsocial equity, freedom and cultural pluralism.’’ a. Mumford. b. Denis Hayes. c. Louise. d. None of the above.

Description : Who said that ‘‘dispersed solar sources are more compatible than centralized technologies withsocial equity, freedom and cultural pluralism.’’ a. Mumford. b. Denis Hayes. c. Louise. d. None of the above.

Last Answer : b. Denis Hayes.

A devicethat connects toa network without the useof cables is said to be– (A) distributed (B) free (C) centralized (D) open source (E) None of these

Description : A devicethat connects toa network without the useof cables is said to be– (A) distributed (B) free (C) centralized (D) open source (E) None of these

Last Answer : free

With Slotted Aloha, a …………. sends out small clock tick packets to the outlying stations. A. distributed clock B. synchronized clock C. centralized clock D. Digital clock

Description : With Slotted Aloha, a …………. sends out small clock tick packets to the outlying stations. A. distributed clock B. synchronized clock C. centralized clock D. Digital clock

Last Answer : C. centralized clock

A device that connects to a network without the use of cables is said to be: a) Distributed b) Free c) Centralized d) Open Source e) None of The Above

Description : A device that connects to a network without the use of cables is said to be: a) Distributed b) Free c) Centralized d) Open Source e) None of The Above

Last Answer : e) None of The Above

Which capabilities are offered by Web Content Management Tools? a)Centralized version control b)Simplification through templates c)Integration with enterprise applications d)all Answer: d

Description : Which capabilities are offered by Web Content Management Tools? a)Centralized version control b)Simplification through templates c)Integration with enterprise applications d)all Answer: d

Last Answer : d)all

Which of the following is not a storage of storage area network? A. Direct attach storage. B. Centralized but still Direct attach storage. C. Shared Storage. D. Distributed Storage

Description : Which of the following is not a storage of storage area network? A. Direct attach storage. B. Centralized but still Direct attach storage. C. Shared Storage. D. Distributed Storage

Last Answer : Distributed Storage.