The project is about ticketing system.Attached seating plan for arena.Task is to develop a ER model.Have to identify the entities,relations, each relation identify the attributes an attribute op a er model for the given data model. identify the constraints between the e relational database schema for datamodel. project deliverable : 1. ER diagram should be done in mysql workbench. 2. mysql rdbms schema exported as .sql file that includes database tables and views. ete design document describing entities relations,functional dependencies normalization steps attributes and their datatypes and views that will provide reporting data.
1. Identify entities, relations and relationships.
2. For each relation, identify functional dependencies and normalize to
3NF or BCNF, as needed.
3. In each relation, identify all attributes and attribute data types.
4. Develop a E-R diagram for your data model.
5. Identify constraints between entities.
6. Create a relational database schema from data model.