The project is about ticketing system. Task is to develop a ER model. Have to identify the
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Related Book For
Construction accounting and financial management
ISBN: 978-0135017111
2nd Edition
Authors: Steven j. Peterson
Posted Date: