PT 1: You have been asked to begin the database design for a Wedding Planner com

PT 1:
You have been asked to begin the database design for a Wedding Planner company. Convert the following ERD into a dependency diagram that is in at least 3NF.
App_Num:System-generated number
Planner_ID:Indentification number of the wedding planner
App_Date: The date of the appointment                                                                          Planner_FirstName: Wedding Planner’s first name.
App_Time: The time of the appointment.                                                                        Planner_LastName: Wedding Planner’s last name.
App_CustomerID: The ID number of the customer who made the appointment.            Planner_Phone: The planner’s phone number.
App_Name: The name of the customer.
App_Phone: The phone number of the customer.
App_Street: The customer’s street address.
App_City: The city the customer lives in.
App_State: The state the customer lives in.
App_Zip: The zip code for the customer’s address.
App_Status: The status of the appointment (active, closed, cancelled)
PT 2:
You are to begin the relational database design process for an invoicing system for a company that sells home improvement equipment. Use the table below to answer the questions listed below the table:
1) Write the relational schema, draw its dependency diagram, and identify all dependencies, including all partial and transitive dependencies.  Assum that an invoice number references more than one product (Hint: This table uses a composite primary key.). Also assume that the table will never contain repeating groups. Clearly label your drawing.
2)  Now, remove all partial dependencies, write the relational schema, and draw the new dependency diagrams. Identify the normal fomrs for each table structure you created.
Note: You can assume that any particular product is provided by one vendor; however, a vendor may provide many products, Thus, you can assume that the following dependency exists:
PROD_NUM –> PROD_LABEL, PROD_PRICE, VEND_CODE, VEND_NAME
You should produce three dependency diagrams.