Designing and Demonstrating a Relational Database for a Business use case
by Designing and Demonstrating a Relational Database for a Business use case
Tag: Normalization
Case Studies from Finance, Marketing, HR, Retail, and e-commerce Sectors
Case Studies from Finance, Marketing, HR, Retail, and e-commerce Sectors
Use of Commercial and Open-source DBMS (e.g., MySQL, Oracle, SQL Server)
Use of Commercial and Open-source DBMS (e.g., MySQL, Oracle, SQL Server)
Online Transaction Processing (OLTP), Characteristics, Types, Challenges
Online Transaction Processing (OLTP), Characteristics, Types, Challenges
Online Analytical Processing (OLAP), Features, Operations
Online Analytical Processing (OLAP) is a technology that enables users to analyze large volumes of data from multiple perspectives quickly and efficiently. It supports complex …
Client-server Architecture, Working, Components
Client–Server Architecture is a fundamental distributed computing model where tasks are partitioned between resource providers, called servers, and service requesters, called clients. These two components communicate over a …
Database Security: Authentication, Authorization, Privileges, Threats; Auditing, Access Controls, Violation Handling
Database Security: Authentication, Authorization, Privileges, Threats; Auditing, Access Controls, Violation Handling
Transaction Management and ACID Properties
Transaction Management and ACID Properties
Concurrency control: Locking, Timestamping, Deadlocks
Concurrency control: Locking, Timestamping, Deadlocks
Backup, Recovery, and Disaster Management
Backup, Recovery, and Disaster Management
You must be logged in to post a comment.