Data System Report: Advanced Data Modeling and System Architecture

This report provides a comprehensive analysis of a data system, focusing on data modeling and system architecture. It details the requirements for user interfaces, including those for database administration, individual stores, and the warehouse. The report outlines the need for various authentication systems to secure different access points, such as physical stores, administrators, and customers. Furthermore, it describes the logical operations, including SQL queries and database processing, emphasizing the role of cloud storage and SQL servers. The report also discusses data integrity and server configurations, highlighting the use of internal and E-Tail servers with SQL Server security. It then covers the storage system, differentiating between physical storage for internal data and cloud storage for real-time data and customer-related data. The report also includes a graph model to visualize the data flow and system components, and references relevant academic sources.

Running head: DATA SYSTEM
Advanced Data Modelling
Name of the Student
Name of the University
Author note

2DATA SYSTEM
Data system requirements:
User Interfaces: For Data administration and system control one Database
Administration user interface is needed (Elmasri & Navathe, 2016). For 4 individual stores in
four individual cities 4 individual User Interface will be needed. For Warehouse one
Warehouse User interface are needed.
Authentication System: 4 types of authentication protocols or constrains are needed
to develop the outer layer of system security. Physical stores authentication system for 4 store
User Interfaces, Administration authentication for Admin access, Warehouse authentication
for Warehouse to access Internal Server, Customer Authentication for online customer
authentication will be needed
Logical operation: The SQL quarry and database processing and normalisation will
be connected to the Cloud storage and the SQL server Security protocol (Kimmel, Kleiman &
Miller, 2015). To store or fetch data from physical or cloud storage the data must be passed
through this logical layer for logical operations and data processing.
Data integrity and server: 2 types of server should be operated by the ABS database
Administrator, Internal Server for internal operations and E-Tail Server for E-commerce
operation. SQL Server Security system should be used for cyber security of both of these
severs (Coronel & Morris, 2016).
Storage System: 2 Types of storage should be used by ABC Clothing company.
Physical storage should be used for internal or administrative data storage, such as human
resource, business operations and finance. The Cloud storage will be used as real time data
storage unit. It will store all products, sales and customer related data (Abadi et al., 2016).
Administration and System Control: All the network connection can be used for bi-
direction read and write data flow. However, uni direction connections should also be
developed for system controlling operations by System Administrator.

3DATA SYSTEM
Administration Authentication
Physical Storage for Internal Data (HR/ACT...)
DB Admin user interface
Logical Layer
Logical Layer
SQL / Server Security
Cloud Storage
Physical Stores Authentication Warehouse
Authentication
E-Tail Server
Customer User Interface
Warehouse User Interface
Store 1UI Store 2UI Store 3 UI Store 3UI
Internal Server
One directional
System control
Read/Write data
flow
Customer
Authentication
Graph model:

4DATA SYSTEM
Reference: APA
Abadi, D., Bajda-Pawlikowski, K., Abouzied, A., & Silberschatz, A. (2016). U.S. Patent No.
9,495,427. Washington, DC: U.S. Patent and Trademark Office., 1124-1369
Coronel, C., & Morris, S. (2016). Database systems: design, implementation, & management.
Cengage Learning., 124-169
Elmasri, R., & Navathe, S. (2016). Fundamentals of database systems. London: Pearson., 43-
109
Kimmel, J. S., Kleiman, S. R., & Miller, S. C. (2015). U.S. Patent No. 9,134,917.
Washington, DC: U.S. Patent and Trademark Office., 84-169