Should I add new Table or new Row for each Manager and Developer.Is this a good design?
I am doing my term Project and I need to create a Performance Evaluation System.I have Created a UML and a proposed ERD. Nowalt text I am confused should I add new tables for each developer and Manager or i should add data in same tables.Please tell is this a good design and how I can do this Efficiently. ![alt text] ![alt text] : /storage/temp/2735-performance-evaluation-vp.jpg : /storage/temp/2736-erd.jpg
Instead of a Manager and Developer table, these are both a type of Person. I'd have a single table for them and then have a way of marking if it's a developer or a manager. And yeah, you add a developer or manager by adding rows to the table, not by adding additional tables. That's the whole idea of a database. I also wouldn't have the work time stored in the person table. It should be an aggregate from, I think, the logs table? I'm a little confused by the design, but I think that's right.