Just Decorate Pty. Ltd.

Just Decorate Pty. Ltd. is a local store that sells decorative items for home and office in
Melbourne metropolitan area. The owner of the company, Sandy Foster, has envisaged the
importance of technology in supporting business operations and decision making. At the
moment, there are four stores in Chadstone, Box Hill, Richmond and Melbourne CBD, and
there are about 50 staff including part-timers employed by Sandy.
Sandy is keen to keep a track of the customer profiles and their purchase details. Currently,
each store purchases the decorative items from over 20 different suppliers across the
world. The stores stock a wide range of elegant decorative items, mainly focussing on vases,
artificial plants, mirrors, clocks, paintings and photo frames. The store managers are
responsible for the purchases and they deal directly with the suppliers. Once purchases are
made, these items are then delivered by the suppliers directly to the stores.
While all brands are displayed in the shopfront of each store, each store also has a storeroom
to keep extra stock (for example, items in different sizes, shapes and colours). In the
storerooms, each brand of item is stored in distinct spots and shelf locations. Items are
delivered using various mediums including ship, air, rail, and courier van. Sandy would like the
database management system to be able to collect data and produce business reports that
could support her and her employees for their business decision-makings. The database
should be able to encapsulate current sales, invoice details, customer profiles, supplier
details, shipping details, item details, and employee details.
To date, Sandy has managed this all herself using Google Sheets and emails to keep track of
all of the details. However, as her business has expanded, it has become difficult to manage
everything and extract valuable insights about her business. As such, she wants a dedicated
database management system built specifically to her needs, which has the capability of
capturing all of the current and future data associated with the business. She has contracted
Best Innovative Solutions (BIS) Pty. Ltd. to carry out this work, with you assigned to design and
build a database that meets her specification.