FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Centralized DBMS: combines everything into single system including-DBMS software, hardware, application programs and user interface processing software.

Detailed explanation-2: -The centralized database system consists of a single processor together with its associated data storage devices and other peripherals.

Detailed explanation-3: -Centralized databases store data on a single CPU bound to a single certain physical/geographical location. Distributed databases, however, rely on a central DBMS which manages all its different storage devices remotely, as it is not necessary for them to be kept in the same physical and/or geographical location.

Detailed explanation-4: -The DBMS provides a centralized view of data that can be accessed by multiple users from multiple locations in a controlled manner. A DBMS can limit what data end users see and how they view the data, providing many views of a single database schema.

Detailed explanation-5: -Centralized architectures are simpler and easier to manage, but they can become a bottleneck as the system grows in size. Client-server architectures are more complex, but they are more scalable and fault-tolerant, making them a better choice for larger and more critical systems.