officina | Notion

Specifica

Definire uno schema Entità-Relazione che descriva i dati di un’applicazione relativa a una catena di officine, secondo le seguenti specifiche (semplificate rispetto a molte realtà)

ogni Officina ha un nome (che la identifica), un indirizzo e un numero di telefono e il numero di interventi effettuati sugli autoveicoli nell’anno in corso
l’officina effettua riparazioni di Autoveicoli che possono essere Automobili o Autocarri
per gli Autoveicoli è necessario memorizzare la targa (identificante), il modello, il tipo di alimentazione e i dati anagrafici e di contatto del proprietario
inoltre, per gli Autocarri andrà memorizzato il peso ed il numero di assi
mentre per le Automobili andrà memorizzata la categoria delle emissioni (Euro 4, Euro 5 o altri) ed il tipo di catalizzatore (con filtro antiparticolato auto-rigenerante, ad esaurimento, o altri tipi)
ogni Cliente può essere proprietario di più autoveicoli
gli “Interventi” di manutenzione vengono effettuati presso un’officina e per essi occorre memorizzare un numero progressivo (unico nell’ambito della rispettiva officina), date di inizio e di fine, pezzi di ricambio utilizzati (con le rispettive quantità) e numero di ore di manodopera

Analisi

Entità	Attributi	Identificatore
Officina	Nome, Indirizzo, Telefono, Num Interventi	Nome
Cliente	Nome, Cognome, CF, Indirizzo, Telefono	CF
Autoveicolo	Targa, Modello, Alimentazione	Targa
Autocarro	Peso, Num Assi	(Targa)
Automobile	Emissioni, Catalizzatore	(Targa)
Intervento	Num Progressivo, Data Inizio, Data Fine, Ore Manodopera	Num Progressivo, (Officina)
Ricambio	Codice, Prezzo, Marca, Tipo, Num Pezzi Disponibili	Codice

Relazioni	Componenti	Attributi
Riparazione	Autoveicolo, Intervento
Effettuazione	Officina, Intervento
Possesso	Autoveicolo, Cliente
Uso	Ricambio, Intervento	Num Pezzi Utilizzati

Traduzione nello schema ER

https://viewer.diagrams.net/?border=0&tags=%7B%7D&highlight=0000ff&edit=_blank&layers=1&nav=1&title=officina.drawio&open=R7V3fd9o6Ev5rcs7dh%2BZYkm3Zjylp7%2FbsSZtze%2B9u%2B%2BiAE7wLOGtMmuavvzJYYI9E7LjWD6LkJWBABs3Mp5lvRqMzMlk%2B%2Fl4k9%2FOrfJYuzrA3ezwjl2cYIw8T9q%2B68nN3JSDx7sJdkc3qNx0ufM2eUv7J%2Buomm6Xr1hvLPF%2BU2X374jRfrdJp2bqWFEX%2Bo%2F2223zRvut9cpcKF75Ok4V49T%2FZrJzXV1EYH174Z5rdzetbR5juXlgm%2FM31L1nPk1n%2Bo3GJfDgjkyLPy92j5eMkXVSTx%2Bdl97mPR17df7EiXZV9PlD%2B66L4L%2F786Wr2Lc2%2B57H%2FbvHlXT3KQ7LY1D%2F4DIcLNt7725wNy751%2BbOeivD%2Fm5y%2F8G69FdQFewPy75mw3x9eZ4%2Fu6v%2FbgW74hYtNmT%2Bk2TRf5Pw19m1v4PvZtd29%2BWXc%2Bhq4yDerWVr9KI%2B9%2FGOelenX%2B2RavfqD6SC7Ni%2BXC%2FYM7T%2FdnCT%2Bi9OiTB8bl%2BpJ%2Bz3Nl2lZ%2FGRvqV8NsL%2F7SK3BOKoF%2BqOhD1zI84YqhPW1pFbBu%2F3QBymxB7WgXiA0LBEamKTGFOz1rpquWbKe7%2BcuWWR3K%2FZ4yiYnLdiFalIypvsX9QvLbDarRqzGuK9GXj7eVWZ%2BvrMsvPtfDVvNjXceVg%2BrafO398oKZpFZXo20zjfVXL1f5eV0Xt%2F%2BNlssJkwZiu1XJt72bySZ%2BXFLZkgiMyoRGfJUyczvllm6ml3s5vNyla%2FStiK3tf7oFKWzFpyJE9SYgEAyAfxakS6SMntog6BsUuo7XOfZFi7q%2Bfd9Tz7%2FfAimD8U0rT%2FVBC0wECUdA5VJcZeWwkBbGe1%2F9nCxBW9iGyI2YSCsV2yhU2LrNJLB1qZZbFQiNpXeyDK%2Fydh4J%2BSMkKgtodC0LxJpFtm0cjlOSWIhtUxi8ajYWM11HbUh%2FwSwMvTb3jzx4nMfjDIULtlYWuGSx8gNUV7n63W6Xuei2s%2Fz5c1m3a3yUKDAS%2F%2B4%2FRvHNOD87V3ypm34El2A69totoFk8bA7xhEBrCJooCMRBx0DqbYMWYgMVpPJIqviXvla8iuLhkYLgvNsnptApHvmv9zeZtNslZz01O%2BpAnumflyOAc5l%2BpiV36rXzoP62ff6c9Xjy8f6Y9snP886IqcdkDz3Y6wCxgACIxkIjEHUdj%2F2gbIuYByX0Di1BQ6F3vPT31eOcCCiW44iw%2FHh9jYty03ylFVCOwX%2FLz4iDHPun0hA%2FJGxn3hCcxqgIwBjblJlFIG7kBMMJeeEgTSTc8ht4gCu3IPlKAykWY78ds956J%2BqhOADk8QRqu1EfPR92MmnOpCAod7UrVqCgU1V8fMb98SrJ98PHnv19OCmb591%2Buk7XeyhTZZY6WhoC50TYSDVVipjMMYP5nj41lATBcGcZUoSkDYCh2NFc9qVRCRb%2FjoR7hf6qaEsL6LVT8Vq6ZOjc2aJURBAcVBYCtPXKOBAoWbuF4%2Bb%2FLdgiSWvU1ECr2Mg1YoiKzfQYPDdAo%2BsEngY%2BOMInHoA8wPNAj9erLCPbf7IpsnyJjvtuIeC8qswjM%2Fjxl8kLrV6oyC1VMIhU4GbqYq9Qzt2qsIufN4XnPPEVBAMM1cEomdBHxSbK%2FfKlWsJ7a8la%2FabS3DH4ZpDsF2aAwU%2BVHMwLOzQnB3h8%2Fqs5iwW2f067cbtZH2%2F21hymz1WytQF5GPWsQu2zCe2oRAy5IaU4mjITWTpfcM2%2BevI3emRWWaoCJBTQlB8MoYqxtyfVrOsyJ6eRBqD2UwJTLP3BpYiXWdPyc12qEpn7qtftP2Nwfuz4LIaa1Pm61oVt0Bf5P9LuVnP0ttks6tqbRh7rd1QiQ8qvv2ON%2Bt8sSnTi2L69TD8CNgAS38k0BBJVBByXeNBg1ha8JkNbZMYucC6ZTgGdsMCIU8UUKhVQLqIkdrt5twI6mBGRvap4p6YbpnbDiCdDE4Tw6JkzUE26RPbqfK9xgyiwU4LIilO1up68Sr1xsT%2BmS5SNiNWLZVaMRaWGceG10BfbQ5BhpQN2KUvgt2j039qyAmd2MHQSQBtprtq3e9TnKkcOpvbttNkXY5jqTCSNQ%2BnIvv%2FebNkF%2Fa1L5mzsIpo0Imre3ZQD7CqLSIcxBiP67fyjgWWgGoM3J%2FBFEMMQFU3xRAorrjSzFhZRkR5ULqDwxYPVG7pzjb4ryVuiSGnZ5ozDrB92H10njud3zecVoTTancm6WGnukMnu%2FAbCn1w6BRTfB7jKCYYRRGCLbOIT889yiCeRghFPg2oXtXqQ3yeIrQbD6ICtSVUevgOS2wReZBxHO5LQbPWjeV9orVTMDjkwY2%2Fpi2Oe8U6LC5nN%2BHXPmbV9zwNQxqrHRbMskN2Q3UTM7WRax9RHzOtBgi3MNg7cQwOXonmqI24fgkkumttfKtUIh5JJaJDnyk%2BlOZ691CWnHphrzZ8pFfbv7OkbwM2V0h0uApJ9p7K9jcpo9BDMcCeXFyfnnjwOOIJg07xyFBFnXjEIHWaleXZhJxdeM5KCYEtI%2BbFJEa8bxWLvYXZo5xZa71GqDat%2BCqiKdjobLAHJKZ4dLvFarcdvQVUMpnj16I9nPmxESs6gyq%2BbFmjFuFoahEYD6yojKh5C6yUVSd5cEUyHVpRkW9xObRCHrEsuKLitrXJW3CFPGpZdEVHoKiOHSdwKJZ%2FJXA6khbEPfYpaQ3KqNpKkBenC63xmWAusjq6wGu0dQBVFf33%2BSNhYL3%2Bk9L6jDa5cZQl0bepG0FSi0gsTmtSmYqk1uTj6QHiaP5lDOSDDfuXkRh6Or21NoaAJdmfoHVrbSRGgJP8buWyjMQiJNOb8yIxStPhVxxrGIe7OsaNu7%2BEt6rsLlG1yuvxYX0zBeoxtNvcPrGvycmJ1HZOean2UXX9Cu1WIAL3lfQ%2B0xLu0NfMMkay2NguL3nM0ksfRDuyg%2FO0OsmR%2FVGKyvknEm5I7%2FyrrTXvBFD0QgAdefmOThJ9QwiaQ9GXQpdfc0l7pLSk3TqOIoSrpnHrV5u7H936h7tPkWXdf8eyYOHkVQy6Syq2YP47mv1z2B0TQY1cidBDeIaZZG%2BLVhYlFlmUq3zGPmhVZZ1WGfl%2BO5Mqq5ijWmUkkihsgpfsFx45JM0ZSWHQM0V2mLHWnilxn4DRIr5r%2BJJpV3ETbCMFG%2FD1bkcFqigg86V6vTSThjVAWNmtPggCRG%2F9gTV2mtuZxW4RJgRs%2BJEcvKk1Yor78CWvd%2FqRJGmrd%2F5FxuDDMluvmZfkbmc5Aks3DecEY5FWmCQlm%2Funp6TMC3fdWRyBEk7ZOcJa3dl9Vbduh0R6VCJ%2B%2FqzEcclf5GGrXJQIYC0deE4IHEdzq2rkqe2w8DKNono1KrBLo0C2afg2e%2BgGaM4T7E3VEbcrwnZ5vcgzVGcxZJUYbr%2B9s4GWrRw0fiUrh8itXaeSo3ddcRejbr9eayphv745CsPGo1%2FkqT1tZlTfSgcO2%2BVvQRzef7%2FT87eO9fG%2FWK%2Fd5VkE%2BUr8Mq1EC%2FJEpkUnHhg85RMhu2qyfJifGppgEAaCq4lq2%2BdehjGdMnZaBLLsDJ7RdAoSxPp1qg8n9HocRx8GUhLPXa%2FjyFukn8JCMdyA%2Bfx1e462rR7QQIeWN5hfPfowRa%2FH0mFGxwJLN1SgNOqBIWNaul1rOvG9c6%2FxB0oRBxu%2B%2BSXedGWT0QNyEaI9FZLLxRZ9BHoTDlZAQJaFujkLZJYbAy4Oehb4xlY%2Bu45P8qEqDN4d6ncop3Kdsr%2Fca8wNSrAve2g88Yj6EFyvx52EgaN5AfCRTwFVhyPoC9xJy6AWLt%2Bo7V7ikYDXj88bPbF4FaYuGMZiTLNLR1wX%2BV2RrtfZg7tZYgx2NISSPf37cnc9aQlsyBVjNvm1vkNelPP8Ll8liw%2BHq%2B%2Bnm%2BJhj%2FdH594S24Z7FgSPuq81w2U90HwKLMJuuVGwaj40fVgswmLZ%2FJciPatuuOvbeVPwlp1XySqf5fdp4e4eXgxIGV%2BGqN4zhj%2B%2BAInohl0mJROR92mVPWXurn4kBrKKRFnFWhc%2FIua6alF9zFzeygs9VYlR6S2eINiIl9LyQaSVVTqpI2IXPR6CjjSD6ciwy3lS7fMQtxJhIT9h0Bqfh5hJhP2ieQ83ZVwrXDeHYZ3Nx23Voc%2BSDYMRgBjlMIiYH6s5jPTpKRP98L%2FKbLdh0t16yyBuK0bQ07dT6IabITakmGKyUI5Y1k4LHDEsJL97N8QTMEO312CmH%2BMRBTNX3evbRcUJCga7fvSu7A9NK5hbLRcppOKMb%2BHhCGOHhesp1uq9oceydYWCDdRhOIpnKqwy2Khn6ouElW2QMOquvsA6SLCIiNJVqd0bEizzBODWvJEgQfALDEOCSF5dF6llp3Hr3YsNOlFSSSyqtWco8kV%2B6yoppu6m7YT2BaYPMEK%2B2pPQewH7yIEZtauvI3SlqBoPrWNY5XAsVkH%2Bmd27C8YUdYOx1iNWUWCm6VXbhTtshaAmt0IEuKdvh%2B2K9qAPRoeeigUPf6W6SR4uAUcjOmr6VCMUiL7ZJJ9lU3fLP6gHNrpJnDO9%2FnNgZsNad374XFVfHcvwNoarODz7rTfegqIRYSDleOtWU24436HEljXj7bF%2BRUeS65fZ%2Bj5fZTfZwt3segyZLN420Fh2PRDDZeSsePY%2BBC9sldDUend1BGIU%2BvlNPM80ftArHu70NsTzG7s0%2BfwPd4XEmz88Y0N6eYJQ5Al%2BY5cmyGUhdVuSZiGJ4bO761AADq00vw6FYnLK3XUIiseCdUjkPrYQ5%2FA6FIAtuhasQyL54fo6BIVkwTok0grurkOQ5CXmgU5COjgrHpiSs0A8IpvgOsRRkJjCxvOmocgpuO4sQKAzLySel3kTUmO7I9yzZlxIEmbBcfrHj4htQhKZhSt3xQOPLfJE8fh6xfPGLByHOJl49Hp0VMIslAziUnchDm6RReadBQu2yLpW84rPY9IepXehK2WfxVFMmOZEzNHD7ZFJ1U0QeSGNEIowP3tcV1kFtb9t2JhlFXCvosIyNva0yPOyKS82YfOrfJZW7%2Fgb