<p>With the rise of big data, numerous large-scale applications have shifted away from relational databases (RDB) to NoSQL stores owing to enhanced performance and flexibility. However, migrating from RDB to NoSQL stores involves tedious schema transformation. This is because existing NoSQL schema design approaches mostly rely on rules of thumb or guidelines for manually choosing a good schema. We have proposed a novel workload-driven and service level agreement (SLA)-aware model for relational to document store schema transformation. The proposed model is simultaneously automatic, workload-driven, and SLA-aware. The proposed model has three phases: model input, midway transformations, and model output. The proposed model begins with an extended entity-relationship schema along with workload information and SLA specifications as inputs. The paper proposes two algorithms for the midway transformations phase: (i) entity and relationship transformations, and (ii) workload-driven and SLA-aware refinements and transformations. The third phase includes generating the document store schema as model output. To validate the effectiveness of our research, we conducted an experimental evaluation using a case study in the e-commerce sector. The performance of the proposed model (P) is compared with the four existing workload-driven models, namely, GAF(G), UAF (U), QPG (Q), and Hypergraph (H), for relational to document store schema transformation. Our results show that the proposed model consistently improves query execution time, reduces read and write latency, and enhances aggregation pipeline performance. Finally, our results illustrate that our proposed model requires less storage space, is highly scalable, and demonstrates improved throughput and latency compared to existing models.</p>