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

Beceriler: Veri Tabanı Yönetimi, MySQL

Daha fazlasını gör: eerd, draw eerd, normalise eerd bcnf show final dependency diagrams, database eerd, eerd access, normalise eerd bcnf, what is data structures in c, what is data structures, what is a data structures, what are data structures in c, what are data structures, problem structures, nursery design, nursery business plan, need a garden designer, list of data structures, list in data structures, list data structures, garden service business plan, gardening services business plan, data structures questions, data structures list, data model design services, business plan it services company, business plan for a nursery

İşveren Hakkında:
( 0 değerlendirme ) Australia

Proje NO: #4425004

Bu iş için 8 freelancer ortalamada $173 teklif veriyor


Sure. I can design the required diagrams , Relationship model and then later normalize it.

in %bids___i_period_sub_35% gün içinde200%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(28 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde190%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde187%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

I have more than nine years experience in Database design and Administration. Please see PM. Thanks.

in %bids___i_period_sub_35% gün içinde140%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

I can finish all 3 tasks in the shortest time.

in %bids___i_period_sub_35% gün içinde132%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

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

in %bids___i_period_sub_35% gün içinde148%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde257%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

I have design database for banking application software. If you want I can show you the demo. I can do the job for you.

in %bids___i_period_sub_35% gün içinde132%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)