Cloud Migration: Security
Transactional Database
Presentation Outline
Overview of the Database
Services
Features
Overview
Transactional data base involves all the actions that clients do when ordering goods using a platform that sells products
The current database deals with selling of products to web based clients.
The database will have various transactions that effect a given order.
Transactional database involves selling and buying of products via an online platform. Most e-commerce sites have to ensure that they have the required essentials to fit the specific demands of a client. The ecommerce database will have products on display that clients can easily purchase. These products are stored in the database. Therefore, before a product is fully sold, there have to be transactions. The transactions ensure the business remains relevant and is earning enough.
3
Database Options
Transactional Database is divided into five different phases
Supplier:
Ensures that the products are available
Provides products to companies
Customer
Purchases products
Makes Orders
Helps the business to grow
Staff
Manages databases
Links clients with their specific products
Maintains the clients details
Transactional Database is divided into six different phases; Supplier, Customer, Staff, Products, database and Shipping. Supplier ensures that the products are available and also provides products to companies. Customer purchases products, makes Orders and helps the business to grow. On the other hand, Staff manages databases, links clients with their specific products and maintains the clients details
4
Database Options
Products
Forms the main part of the business
Purchased from suppliers
Shipped to clients
Database:
Stores all the details of the company
Ensures all transactions are identified and stored.
Shipping:
Deliveries of products to the clients.
Transactional Database also contains other parts. These include; Products, database and shipping. Products form the main part of the business. They are purchased from suppliers and shipped to clients. On the other hand, the Database stores all the details of the company and ensures all transactions are identified and stored while shipping is the process of delivering products to the clients.
5
Purchasing
Shipping:
After purchasing, the order is confirmed
The products are then delivered to the clients
Purchasing is the process of acquiring a product from the company. It forms the main portion of the database.
Processing:
Clients sign up with the company
Clients are supposed to make an order from the online store
The transaction is processed and an ID offered
Storing:
All the order details and clients’ records are stored in the database
Purchasing is the process of acquiring a product from the company. It forms the main portion of the database. During processing: clients sign up with the company. Also, the clients are supposed to make an order from the online store. Then, the transaction is processed and an ID offered. After being processed, all the order details and clients’ records are stored in the database. The products are then confirmed before being shipped to the specific location of the client.
6
Features of the Database
Track Transactions:
The database has to ensure all the orders are tracked.
Other details that should be maintained include customer details as well as shipping details that the order will use.
Each data entry is separated to avoid confusion and mix up
Organize Products:
The database has to ensure all the products are arranged specifically with their details.
Features of the database include: Tracking Transactions and organizing products. While tracking transactions, the database has to ensure all the orders are tracked. Other details that should be maintained include customer details as well as shipping details that the order will use. Also, each data entry is separated to avoid confusion and mix up. The second feature of the database is to organize Products (Song et al. 2000). Through this, the database has to ensure all the products are arranged specifically with their details.
7
Features of the Database
Provide structure to the data
The database has to ensure all the products are arranged specifically with their details.
Each product has to have a code and a different structure that separates it from other products
The database also ensures each of the products represent the correct figures and the exact amounts it costs.
Other features of the database include providing structure to the data. Therefore, the database has to ensure all the products are arranged specifically with their details. Also, each product has to have a code and a different structure that separates it from other products and the database also ensures each of the products represent the correct figures and the exact amounts it costs.
8
References
Song, Il-Yeol & Whang, Kyu-Young & Korea, Taejeon. (2000). Database Design for Real-World E-Commerce Systems.