The project is about ticketing system. Task is to develop a ER model. Have to identify the entities, relations, relationships. For each relation identify the attributes an attribute data types. Develop a er model for the given data model. Identify the constraints between the entities. Create relational database schemas for data model. Project deliverable:

1. Identify entities, relations and relationships.

2. For each relation, identify functional dependencies and normalize to NF or BCNF, as needed.

3. In each relation, identify all attributes and attribute data types.

5. Identify constraints between entities.

6. Create a relational database schema from data model

Answer rating: 100% (QA)

1 Identify entities relations and relationships Solution The entity relationship is between all variables which are student game and seat it The strin... View the full answer