Hotelchaindiagram.erdplus

{"version":2,"www":"erdplus.com","shapes":[{"type":"Entity","details":{"name":"Employee","type":"regular","x":176,"y":114,"id":1}},{"type":"Entity","details":{"name":"Department","type":"weak","x":538,"y":115,"id":2}},{"type":"Relationship","details":{"name":"Works for","isIdentifying":false,"x":380,"y":115,"slots":[{"slotIndex":0,"minimum":"","maximum":"","participation":"mandatory","cardinality":"one","role":"","entityId":1},{"slotIndex":1,"minimum":"","maximum":"","participation":"mandatory","cardinality":"many","role":"","entityId":2}],"id":6}},{"type":"Relationship","details":{"name":"Exists in","isIdentifying":true,"x":689,"y":116,"slots":[{"slotIndex":0,"minimum":"","maximum":"","participation":"mandatory","cardinality":"one","role":"","entityId":2},{"slotIndex":1,"minimum":"","maximum":"","participation":"mandatory","cardinality":"many","role":"","entityId":13}],"id":12}},{"type":"Entity","details":{"name":"Hotel","type":"regular","x":857,"y":118,"id":13}},{"type":"Entity","details":{"name":"Room","type":"regular","x":913,"y":693,"id":16}},{"type":"Relationship","details":{"name":"Contains","isIdentifying":false,"x":886,"y":235,"slots":[{"slotIndex":0,"minimum":"","maximum":"","participation":"mandatory","cardinality":"many","role":"","entityId":13},{"slotIndex":1,"minimum":"","maximum":"","participation":"mandatory","cardinality":"one","role":"","entityId":16}],"id":17}},{"type":"Relationship","details":{"name":"Has facility","isIdentifying":false,"x":1079,"y":118,"slots":[{"slotIndex":0,"minimum":"","maximum":"","participation":"optional","cardinality":"many","role":"","entityId":13},{"slotIndex":1,"minimum":"","maximum":"","participation":"mandatory","cardinality":"one","role":"","entityId":21}],"id":20}},{"type":"Entity","details":{"name":"Facility","type":"regular","x":1275,"y":118,"id":21}},{"type":"Entity","details":{"name":"Reservee","type":"regular","x":276,"y":644,"id":25}},{"type":"Entity","details":{"name":"Gym","type":"regular","x":1108,"y":277,"id":28}},{"type":"Entity","details":{"name":"Restaurant","type":"regular","x":1447,"y":264,"id":29}},{"type":"Entity","details":{"name":"Booking Agency","type":"regular","x":193,"y":388,"id":30}},{"type":"Entity","details":{"name":"Guest","type":"regular","x":394,"y":394,"id":31}},{"type":"Attribute","details":{"name":"Price","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":914,"y":787,"id":36}},{"type":"Attribute","details":{"name":"Room_ID","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":958,"y":586,"id":38}},{"type":"Attribute","details":{"name":"View","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":1075,"y":603,"id":40}},{"type":"Attribute","details":{"name":"Available","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":1093,"y":668,"id":42}},{"type":"Attribute","details":{"name":"Location","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":820,"y":25,"id":48}},{"type":"Attribute","details":{"name":"Room number","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":1116,"y":731,"id":58}},{"type":"Attribute","details":{"name":"Name","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":176,"y":30,"id":60}},{"type":"Attribute","details":{"name":"ESSN","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":267,"y":61,"id":62}},{"type":"Attribute","details":{"name":"Name","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":488,"y":39,"id":66}},{"type":"Attribute","details":{"name":"Department_ID","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":604,"y":40,"id":70}},{"type":"Attribute","details":{"name":"Salary","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":58,"y":72,"id":72}},{"type":"Attribute","details":{"name":"Location","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":50,"y":345,"id":76}},{"type":"Attribute","details":{"name":"SSN","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":516,"y":297,"id":80}},{"type":"Attribute","details":{"name":"Gender","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":416,"y":281,"id":82}},{"type":"Attribute","details":{"name":"Date of birth","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":572,"y":343,"id":84}},{"type":"Attribute","details":{"name":"Name","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":728,"y":52,"id":86}},{"type":"Attribute","details":{"name":"ID","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":1018,"y":64,"id":88}},{"type":"Attribute","details":{"name":"Rating","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":924,"y":32,"id":90}},{"type":"Attribute","details":{"name":"ID","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":309,"y":722,"id":92}},{"type":"Attribute","details":{"name":"Room Type","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":1023,"y":784,"id":95}},{"type":"Attribute","details":{"name":"Discount","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":50,"y":403,"id":99}},{"type":"Attribute","details":{"name":"Equipment","isDerived":false,"isMultivalued":true,"isOptional":false,"isComposite":false,"isUnique":false,"x":1005,"y":337,"id":101}},{"type":"Attribute","details":{"name":"Name","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":1112,"y":352,"id":103}},{"type":"Attribute","details":{"name":"Working hours","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":1224,"y":340,"id":105}},{"type":"Attribute","details":{"name":"Name","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":1611,"y":275,"id":107}},{"type":"Attribute","details":{"name":"Price range","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":1564,"y":350,"id":109}},{"type":"Attribute","details":{"name":"Rating","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":1477,"y":394,"id":111}},{"type":"Attribute","details":{"name":"Food type","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":1362,"y":371,"id":113}},{"type":"Attribute","details":{"name":"Facility_ID","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":1296,"y":47,"id":115}},{"type":"Entity","details":{"name":"Activities","type":"regular","x":822,"y":386,"id":152}},{"type":"Relationship","details":{"name":"Offers","isIdentifying":false,"x":823,"y":278,"slots":[{"slotIndex":0,"minimum":"","maximum":"","participation":"optional","cardinality":"many","role":"","entityId":13},{"slotIndex":1,"minimum":"","maximum":"","participation":"optional","cardinality":"many","role":"","entityId":152}],"id":153}},{"type":"Relationship","details":{"name":"Participates in","isIdentifying":false,"x":614,"y":391,"slots":[{"slotIndex":0,"minimum":"","maximum":"","participation":"optional","cardinality":"many","role":"","entityId":31},{"slotIndex":1,"minimum":"","maximum":"","participation":"optional","cardinality":"many","role":"","entityId":152}],"id":156}},{"type":"Attribute","details":{"name":"Date","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":646,"y":448,"id":159}},{"type":"Attribute","details":{"name":"Price","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":763,"y":456,"id":161}},{"type":"Attribute","details":{"name":"Activity_ID","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":703,"y":325,"id":163}},{"type":"Relationship","details":{"name":"Manages","isIdentifying":false,"x":172,"y":238,"slots":[{"slotIndex":0,"minimum":"","maximum":"","participation":"optional","cardinality":"many","role":"","entityId":1},{"slotIndex":1,"minimum":"","maximum":"","participation":"mandatory","cardinality":"one","role":"","entityId":1}],"id":165}},{"type":"Entity","details":{"name":"Reservation","type":"regular","x":590.2000045776367,"y":643.4000091552734,"id":241}},{"type":"Relationship","details":{"name":"Made","isIdentifying":false,"x":436.2000045776367,"y":644.4000091552734,"slots":[{"slotIndex":0,"minimum":"","maximum":"","participation":"mandatory","cardinality":"many","role":"","entityId":25},{"slotIndex":1,"minimum":"","maximum":"","participation":"mandatory","cardinality":"one","role":"","entityId":241}],"id":242}},{"type":"Relationship","details":{"name":"For","isIdentifying":false,"x":748.2000045776367,"y":644.4000091552734,"slots":[{"slotIndex":0,"minimum":"","maximum":"","participation":"mandatory","cardinality":"one","role":"","entityId":241},{"slotIndex":1,"minimum":"","maximum":"","participation":"optional","cardinality":"one","role":"","entityId":16}],"id":245}},{"type":"Attribute","details":{"name":"Date","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":true,"isUnique":false,"x":559.2000045776367,"y":819,"id":248}},{"type":"Attribute","details":{"name":"Start date","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":493.2000045776367,"y":880,"id":250}},{"type":"Attribute","details":{"name":"Duration","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":621.2000045776367,"y":878,"id":252}},{"type":"Attribute","details":{"name":"Paid amount","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":646.2000045776367,"y":570.4000091552734,"id":254}},{"type":"Relationship","details":{"name":"Has","isIdentifying":false,"x":508.2000045776367,"y":484,"slots":[{"slotIndex":0,"minimum":"","maximum":"","participation":"mandatory","cardinality":"one","role":"","entityId":31},{"slotIndex":1,"minimum":"","maximum":"","participation":"mandatory","cardinality":"many","role":"","entityId":241}],"id":256}},{"type":"Attribute","details":{"name":"Board type","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":637.2000045776367,"y":775.4000091552734,"id":259}},{"type":"Attribute","details":{"name":"children number","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":772.2000045776367,"y":813.4000091552734,"id":261}},{"type":"Label","details":{"text":"Manager","x":66,"y":217,"width":52,"height":55,"id":263}},{"type":"Label","details":{"text":"Employee","x":226,"y":218,"width":59,"height":53,"id":264}},{"type":"Attribute","details":{"name":"Reservation id","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":425.2000045776367,"y":785.4000091552734,"id":306}},{"type":"Attribute","details":{"name":"Agency id","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":true,"x":229,"y":312,"id":308}},{"type":"Attribute","details":{"name":"Name","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":120,"y":300,"id":352}},{"type":"Attribute","details":{"name":"Name","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":342,"y":326,"id":398}},{"type":"Attribute","details":{"name":"Name","isDerived":false,"isMultivalued":false,"isOptional":false,"isComposite":false,"isUnique":false,"x":826,"y":504,"id":441}}],"connectors":[{"type":"RelationshipConnector","details":{"slotIndex":0,"id":7},"source":1,"destination":6},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":8},"source":2,"destination":6},{"type":"RelationshipConnector","details":{"slotIndex":0,"id":14},"source":2,"destination":12},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":15},"source":13,"destination":12},{"type":"RelationshipConnector","details":{"slotIndex":0,"id":18},"source":13,"destination":17},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":19},"source":16,"destination":17},{"type":"RelationshipConnector","details":{"slotIndex":0,"id":22},"source":13,"destination":20},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":23},"source":21,"destination":20},{"type":"Connector","details":{"id":442},"source":36,"destination":16},{"type":"Connector","details":{"id":443},"source":38,"destination":16},{"type":"Connector","details":{"id":444},"source":40,"destination":16},{"type":"Connector","details":{"id":445},"source":42,"destination":16},{"type":"Connector","details":{"id":446},"source":48,"destination":13},{"type":"Connector","details":{"id":447},"source":58,"destination":16},{"type":"Connector","details":{"id":448},"source":60,"destination":1},{"type":"Connector","details":{"id":449},"source":62,"destination":1},{"type":"Connector","details":{"id":450},"source":66,"destination":2},{"type":"Connector","details":{"id":451},"source":70,"destination":2},{"type":"Connector","details":{"id":452},"source":72,"destination":1},{"type":"Connector","details":{"id":453},"source":76,"destination":30},{"type":"Connector","details":{"id":454},"source":80,"destination":31},{"type":"Connector","details":{"id":455},"source":82,"destination":31},{"type":"Connector","details":{"id":456},"source":84,"destination":31},{"type":"Connector","details":{"id":457},"source":86,"destination":13},{"type":"Connector","details":{"id":458},"source":88,"destination":13},{"type":"Connector","details":{"id":459},"source":90,"destination":13},{"type":"Connector","details":{"id":460},"source":92,"destination":25},{"type":"Connector","details":{"id":461},"source":95,"destination":16},{"type":"Connector","details":{"id":462},"source":99,"destination":30},{"type":"Connector","details":{"id":463},"source":101,"destination":28},{"type":"Connector","details":{"id":464},"source":103,"destination":28},{"type":"Connector","details":{"id":465},"source":105,"destination":28},{"type":"Connector","details":{"id":466},"source":107,"destination":29},{"type":"Connector","details":{"id":467},"source":109,"destination":29},{"type":"Connector","details":{"id":468},"source":111,"destination":29},{"type":"Connector","details":{"id":469},"source":113,"destination":29},{"type":"Connector","details":{"id":470},"source":115,"destination":21},{"type":"RelationshipConnector","details":{"slotIndex":0,"id":154},"source":13,"destination":153},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":155},"source":152,"destination":153},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":158},"source":152,"destination":156},{"type":"Connector","details":{"id":471},"source":159,"destination":152},{"type":"Connector","details":{"id":472},"source":161,"destination":152},{"type":"Connector","details":{"id":473},"source":163,"destination":152},{"type":"RelationshipConnector","details":{"slotIndex":0,"id":166},"source":1,"destination":165},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":167},"source":1,"destination":165},{"type":"RelationshipConnector","details":{"slotIndex":0,"id":204},"source":31,"destination":156},{"type":"RelationshipConnector","details":{"slotIndex":0,"id":243},"source":25,"destination":242},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":244},"source":241,"destination":242},{"type":"RelationshipConnector","details":{"slotIndex":0,"id":246},"source":241,"destination":245},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":247},"source":16,"destination":245},{"type":"Connector","details":{"id":474},"source":248,"destination":241},{"type":"Connector","details":{"id":475},"source":250,"destination":248},{"type":"Connector","details":{"id":476},"source":252,"destination":248},{"type":"Connector","details":{"id":477},"source":254,"destination":241},{"type":"RelationshipConnector","details":{"slotIndex":0,"id":257},"source":31,"destination":256},{"type":"RelationshipConnector","details":{"slotIndex":1,"id":258},"source":241,"destination":256},{"type":"Connector","details":{"id":478},"source":259,"destination":241},{"type":"Connector","details":{"id":479},"source":261,"destination":241},{"type":"Connector","details":{"id":480},"source":306,"destination":241},{"type":"Connector","details":{"id":481},"source":308,"destination":30},{"type":"Connector","details":{"id":482},"source":352,"destination":30},{"type":"Connector","details":{"id":483},"source":398,"destination":31},{"type":"Connector","details":{"id":484},"source":441,"destination":152}],"width":2000,"height":1000}