Decomposition in DBMS removes redundancy, anomalies and inconsistencies from a database by dividing the table into multiple tables. The following are the types: Lossless Decomposition Decomposition…