This is a case study with 3 questions to be answered.
Represent the following case study problem by means of an Entity Relationship model.
Regional Gardens Case Study
Regional Gardens Ltd is a company that runs a number of related gardening enterprises. It has a large display garden that it opens for public inspection a number of times a year. The company also owns the Regional Gardens Nursery which sells plants and garden supplies to the public as well as providing garden advice, design and consultancy services. The directors of Regional Gardens Ltd have decided that they need to modernise their business and finally install a database system to keep track of the design and consultancy aspects of their nursery business. You have been engaged to design the database for their garden design business.
The garden design and consultancy service gathers a number of facts from their clients. These details include the details of the client’s block of land, its features, structures and vegetation. The
designer then determines what the client is looking for in their garden plan. This could include features, such as paths, water features, rock gardens, etc. They should also be able to plan for structures, such as patios, terraces, fences, walls, etc. Both features and structures should be able to have their final size and shape adjusted when added to the garden plan. The plan should also be able to access the list of plants and shrubs that are usually available from the Regional Gardens Nursery.
1. Draw a complete EERD for the Regional Gardens Nursery database showing all attributes and primary keys
2. Normalise your EERD to BCNF and show the final dependency diagrams
3. Prepare a Relational Data Model (RDM) for the BCNF tables
8 freelancers are bidding on average $173 for this job
Hi, I am oracle certified developer and dba with more than 6 years of experience. I am expert in database design. I read you requirements. I can provide you best output. Please let me know. Rgds, Shafiq
Hi I am interested and I have experience in similar work. I can create the EERD and normalize them also, get the assignment from professional. Thanks