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à)

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={}&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