1. We want to create a Database application to record Chess games. Consider the following requirements: Each game has tw

[answerhappygod]

1 We Want To Create A Database Application To Record Chess Games Consider The Following Requirements Each Game Has Tw 1 (278.59 KiB) Viewed 24 times

1. We want to create a Database application to record Chess games. Consider the following requirements: Each game has two players, white and black; and a result. Each game has several moves. Each move is described by: the player taking the move, the piece involved in the move, the starting position and the ending position. Draw the ER/EER diagram for this scenario following the rules below: Marks] Try to create as less entity types and relationship types as possible. This means if there is a way to avoid creating new entity type or relationship type then you must avoid creating it. Use the same names as used in this description. For each relationship type, you must mention the cardinality and participation. For each entity type you must select/add a suitable key attribute. ● ● ● Do not add anything that is not described above to make your ERD more comprehensive. It must be a precise representation of the above description, as precise as possible.