Normalized Database for OLTP
The Online Transaction Processing database. We have instead of having in common table , we will have separated tables. You just divided tables and you need to analyze them separately. For analytic purpose you need to join multiple tables . Once we normalized it it will be more simple in data warehouse.
The way of source data is
- provide an transaction
- database transaction
- Explain the transparency in transaction processing services
Transaction is coming from different sources and it has close connection with product management . Transaction management will contract with data despite product management which work with physical world . The example of transaction can be Banks, airlines with online reservations, universities