09 06 2022 E T

Pagina 1

SYSTEMS AND METHODS FOR BIG AND UNSTRUCTURED DATA Prof. Marco Brambilla June 9, 2022 Last Name ___________________First Name __________ Codice Persona _________ The municipality of Milan would like to implement a database to keep track of the people borrowing books from the city library network. The system stores books (described by ISSN, title, description, publication date, and number of pages), their author (described by name, surname, birthdate, and a unique identifier). Each book has one author and a publisher (described by an identifier, a name, and an email). For each book, one or more copies can be available in one or more libraries of the network. Each book copy has an ID and a status (borrowed or available) and is associated with the respective book, the library and the shelf where it is stored. Each shelf has a book category (described by a name, a small description and an identifier). A book of a specific category can only be placed on a shelf with the same category. People can borrow books (up to 5 at a time). Notice that people search and want to borrow books, but actually one specific copy is associated with the borrowing. A person is described by name, surname, address, email, and library card number. When someone borrows a book copy, an entry is added to the system, storing the date in which the book copy has been borrowed and the date in which it should be returned. When a book copy is returned, the return date is also stored and the status is updated from “booked” to “returned”. Exercise 1 (3 PT) 1.1. Describe the conceptual model of the data using an Entity-Relationship model (in the next page). Focus on conceptualising the problem and avoiding redundancy. Add appropriate entities, relationships, cardinalities, and attributes (2 PT). 1.2. Highlight…