Question

Create a feasibility study (initial proposal).

You need to:
1. Justify why a database is needed for this business
2. Benefits / drawbacks of having the database system for this business

• Describe any business assumptions you needed to make corresponding to the business rules.

Business Information:

The Orange Blossom is a local plant nursery that specializes in providing hard to-find plants to contractors and homeowners. The company also carries most of the common plants and trees, but the owners take pride in their ability to grow more unusual varieties and colors. Contractors and landscape design firms within a couple hundred miles come to the Orange Blossom for unique specimens, often used as highlights in their designs. Prices reflect the uniqueness and high quality of items offered by the firm.

Despite the company’s reputation, Orange Blossom faces the same pressures of any nursery. Weather can be a problem—particularly dry spells or unexpected cold winter. Such weather can boost sales. Homeowners and businesses lose plants during difficult times and they come to Orange Blossom to replace them. The biggest challenge is trying to forecast the demand for new housing and landscaping. It takes time to grow many of the plants to the size requested by contractors and landscapers, so Orange Blossom managers have to plan ahead and estimate the number of plants that will be needed. If the local economy slumps, rates fall, and the company is left with unsold plants. Fortunately, most of them can be protected and sold in future years, but the costs of growing the plants cuts into current-year profits.

Company has done Client Order Forms, Billing Order Forms, and Purchase Order Forms.

Answer 1

A database is needed for The Orange Blossom plant nursery to manage and organize data. The benefits include improved data accuracy and streamlined operations, while drawbacks include setup costs and data privacy concerns. Business assumptions may include growth rate and customer demand.

Step-by-step explanation:

Feasibility study (initial proposal)

Justification for a database: A database is needed for The Orange Blossom plant nursery as it helps in managing and organizing a large amount of data related to client orders, billing, and purchase orders. It allows for efficient tracking of inventory, customer information, and sales records. By having a database, the nursery can quickly access the required information, analyze trends, and make data-driven decisions.

Benefits and drawbacks of a database: The benefits of having a database system for The Orange Blossom include improved data accuracy, streamlined operations, better inventory management, and enhanced customer service. It also allows for personalized marketing and targeted analysis. However, there are some drawbacks such as initial setup and maintenance costs, potential technical issues, data privacy concerns, and the need for proper training of employees.

Business assumptions: Some business assumptions that may be necessary include assuming a certain growth rate of the business, estimating customer demand based on past sales data, and assuming the availability of resources to implement and maintain the database system.