Discussion: Project and Employee Relationship
The type of relationship that exists in an instance where each employee can work on many projects and a project can get worked on by many employees is the many to many relationship in which a new table gets created with the primary key being the combination of the ID of the project and the ID of the employee (Yu et al., 2018). Many to many relationships add confusion and complexity to the process of developing the application. It is, therefore, necessary that it gets implemented in a manner that helps reduce complexity. This can get done by breaking the relationship into two separate one to many relationships by making use of a join table (Yi et al., 2017). Every record in a join table is made up of a match field that has the main key values that are in the two tables which get joined by it. The table collections include the table for the project which includes the target date, the name, and ID of the project; the table for the employee that has the names, ID, and address of the employee; and the Works For table which has the ID of the project and the ID for the employee.
References
Yi, N., Li, C., Feng, X., & Shi, M. (2017, November). Design and implementation of a movie recommender system based on the graph database. In 2017 14th Web Information Systems and Applications Conference (WISA) (pp. 132-135). IEEE.
Yu, M., Zang, Y., Dai, S., Zheng, D., & Li, J. (2018, June). Evaluating Graph Database Systems for Biological Data. In Workshop on Big Scientific Data Benchmarks, Architecture, and Systems (pp. 27-42). Springer, Singapore.