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