18 01 2022 E T

Pagina 1

SYSTEMS AND METHODS FOR BIG AND UNSTRUCTURED DATA Prof. Marco Brambilla January 17, 2022 Last Name ___________________ First Name __________ Codice Persona _________ Suppose you need a data storage solution for supporting the information system of a media production company. The company needs to track the production process of media products (shows of various types: TV programs, series, movies). Each show has a category (comedy, drama, etc.). The company keeps track of all its shows and of the people on its payroll. Each person has their personal data, bio, and detailed history of their activities with the company and other companies: the shows they worked in, their role, their paychecks, the period of work covered (date from-to). Each show has a title, description, production year, list of reviews, list of locations where the show was shot and is linked to all the people working at it. Both shows and people may win some awards. These are recorded too (type and date). Shows are also described by the various expenses recorded (equipment, services, rentals, and so on), with date, type of expense, invoice, amount and name of the company providing the service or product. For each show, all events are recorded in detail to keep track of the advancement of the production (each step of the writing, casting, shooting, contracts signed, and so on). Events may amount to tens per day. Shows have a script, which consists of the complete writing of the show's organisation (i.e., what it’s expected to happen, and how; which actor says what and who does what; and so on). The company also includes staff workers not associated with shows. Information about them is also available. Exercise 1 (3 PT) 1.1. Describe the conceptual model of the data using an Entity-Relationship model. Focus…