We are focusing to create this physical data model with oracle as the database. So we have selected oracle 12c…