Question
The application is to provide farmers detailed information about plant species and diseases, pests, and suitable plant care and fertilizers. Above is the ERD. After
The application is to provide 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 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. 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 DateStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started