1. List & explain three different thick-client applications that can be created for Pick-up Arts where the database that is created for the case study can be utilised. For each of these applications, will thin-clients be a better alternative? (5 marks) 2. How can Pick-up Arts use a data mart? List three different data-mart scenarios (10 marks) 3. Explain in your own words, why Instagram might not use a relational database to store their data. What is an alternative solution for Instagram to store their data? (10 marks) Case Study: Sadia is the founder of Pick-up Arts. Her business is based in Sydney to provide top-quality artwork delivered to museums and retailers in and around Sydney area. She is passionate about providing maximum benefits for the clients who sell or lease their products through her business. As her business is growing rapidly, Sadia is interested in developing an IT system that requires a relational database. Below are her statements about the business and requirements of the system. Artist and Artwork: Every business is required to register with their ABN, this acts as a unique identifier. Other details of the registered businesses include the name of the business and its address. There are two types of businesses that may choose to register with Pick-up Arts: Artists, and Collectors. Artists have the names of the medium stored such as Watercolour, Acrylic, Charcoal (An artist may have more than one type of medium), whereas the collectors have their establishment date and each of their type of collections locations recorded. I Every artwork has a unique identifier. Other details of the artwork include the name of the artwork and its description which are stored. There are two types of artwork that are advertised through Pick-up Arts: they are artwork for sale and artwork for lease. In the future, they are planning to add different types of artworks. The artworks for sale (like paintings/canvases) are supplied by the artists. The price of the artwork is stored for this type of artwork. An artist may supply multiple sellable artworks. The detail of leasable artwork such as the quote is stored. Leasable artworks are supplied by collectors only Customer: Every customer needs to be uniquely identified in the system. Other details which the system needs to store about a customer include their name, address, and phone numbers. Some Museums could choose to become customers. In this case, the name of the manager and a tier number is recorded. Art Listing: Every week an art listing gets created (Think of this as the list of artwork that the customers can see to place an order). Every art listing has a unique identifier. Also, the date when the art listing is created is stored. An art listing has multiple artworks listed in them and an artwork could be in multiple listings. Description for each of the artwork, price, dates through which artwork is available, and if the type of listing (like for sale/discount/lease) is stored for every art displayed on the listing. Order & Payment: Every order that is placed has a unique identifier. Other details such as the date of the order and the customer who placed the order are stored. Orders can have multiple artworks listed in the listing and an artwork could be in multiple orders. For each of the artwork in the order, the quantity is stored. Multiple payments can be made for an order. Hence, for every order, a payment number is generated (Drder 1 can have Payment 1. Payment 2, ..., and Order 2 can also have Payment 1, Payment 2, ...). For every payment, the date of the payment and payment amount are also stored