Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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 Date

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions