I need help to finalize the database like the picture below base on the 3rd Normal Form.

(Remember the purpose of Normalization is to remove any possible data inconsistencies in the model design to ensure data integrity.)

• Normalize the database design to the 3rdNormal Form as best as possible.
• Make sure the Data Diagram is added and complete with all necessary relations as a part of the model before forward engineering the database.
• Continue the steps to forward engineer the database to create it on the database server.
• Make sure there are no issues during the forward engineering operation and it completes successfully. A typical error you may receive during forwarding engineering may result from improperly defining a relation.

\f