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
Bu iş için 8 freelancer ortalamada $173 teklif veriyor
Sure. I can design the required diagrams , Relationship model and then later normalize it.
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
I already finished more than one project like this and I work with SQL and PL/SQL since 1992, including ETL and Data Warehouse and I have Oracle Certified Professional (Internet Application Developer Rel. 6/6i). I was Daha Fazla
I have more than nine years experience in Database design and Administration. Please see PM. Thanks.
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
Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and t Daha Fazla
I have design database for banking application software. If you want I can show you the demo. I can do the job for you.