Database Design: Database Architecture

A database is defined as an organized collection of data. Today most Database Management Systems use different database system architectures such as centralized and client-server systems, server system architectures, parallel systems, distributed systems and many others for system implementation. However, in this case, the database architecture being used for my subsystem is a three-level architecture that has external level, internal level and conceptual level (Hellerstein, Stonebraker & Hamilton, 2007).

In physical database, the users’ view of the data is defined. My subsystem is a customer relationship system (CRM) where customers interact with the system to purchase goods online. Conversely, the managers also interact with the system to manage the employees (Hopper, 2008). The following is an entity-relationship diagram (ERDs) of the subsystem for CRM. In the diagram;

Manager manages Employees

Manager manages Customers

Manager control Goods

Customer orders goods from website

Customer signs up in a website

5172710192405Goods name

Goods name

17081513970Employee name name

Employee name name

-914400170180Employee ID no.

Employee ID no.

1028700169545Managers ID no.

Managers ID no.

2723515163195Managers Name

Managers Name

3676650150495Controls

Controls

5229225215900Goods

Goods

646430215900Manages

Manages

-590550255270Employees

Employees

21443958255Manager

Manager

546735087630Goods no.

Goods no.

1885950200025Customer ID

No.

Customer ID

No.

715010200025Customers

Customers

3781425120015Warehouse

Warehouse

-208915103505Custome Name

Custome Name

The below diagram is a use case Diagram representation for the subsystem to be implemented. Use case diagram is the view of system that looks on the behavior of the system as it appears to external viewers.

Database architecture is essential for system implementation in that it maintains a catalogue of schemas, users as well as, applications. Database architecture also allow for the storage, retrieval along with the manipulation of data. The other significance include; authorization and security, integrity and consistency services as well as, promotion of Data interdependence (Connelly, 2001).

References

HYPERLINK “http://www.bibme.org/” o “Edit this item” Connelly, J. (2001). Architecture Database on DIALOG: a user’s manual. London: British Architectural Library, Royal Institute of British Architects.

HYPERLINK “http://www.bibme.org/” o “Edit this item” Hellerstein, J. M., Stonebraker, M., & Hamilton, J. (2007). Architecture of a database system. London: Now.

HYPERLINK “http://www.bibme.org/” o “Edit this item” Hopper, T. (2008). Distributed relational database architecture: connectivity guide (4th ed.). New York: Prentice Hall PTR.