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.
