Help me with my Database project. Our task is to make an Application that provides farmers detailed information about plant species and diseases, pests, and suitable plant care and fertilizers. Above is the ERD. After ERD, we need to make the "Logical Database Design - Convert the E-R/EE-R diagram to a relational database schema and show the relationships between the entities and attributes. Schema should be normalized to 3NF. " Please help me develop it because I'm confuse. By the way, we dont have any information yet in the attributes. So, the data can be random if you need it but still related with the topic.

The format to write for Logical Database design:-

Customer(Customer_No, Name, Street, State, ZipCode, Telephone_No, DOB)

Primary Key Customer_No Reservation(Reservation_No, Total_Person, Date, Time, Table_No, Special_Order, Customer_No)

Primary Key Reservation_No

Foreign Key Customer_No reference Customer(Customer_No)

Above is just an example and guide on how to write. It is not related to our topic. We need to make it until 3NF.

1..1 Search Customer CustomerNo {PK FirstName LastName Email Username Country PhoneNo Plant PlantID {PK) NameOfPlant Species Plant Diseases_Plant PestsOfPlant PlantCare Fertilizers 0..1 Purchase Order OrderID (PK CustomerNo {FK) Package Payment Date