aggregation:minimum number of tables

 

7Comments
shivani @shivani1234 10 Oct 2017 11:50 am

2 tables are required for this ER- diagram
One table for Works_On(employee, job, branch)
another table Manages(Workson, manager)

set2018 @setgate 10 Oct 2017 05:39 pm

Ma'am if we consider separate works-on relationship then we need two table (employee,branch) and for manger we need different table .m confused between above answer .why we are assuming 2 table .pls provide reference for this concept.it will be very helpful for me

shivani @shivani1234 10 Oct 2017 06:47 pm

in such type of aggregations, we consider relationship(works_on) as an attribute for new table manages.

set2018 @setgate 10 Oct 2017 07:05 pm

in such type of aggregations, we consider relationship(works_on) as an attribute for new table manages. 

u said attribute ,it should be entity ?

Manages(Workson, manager) how workson be attribute in this table ?

 

shivani @shivani1234 10 Oct 2017 10:49 pm

i mean it as column attribute in table

set2018 @setgate 10 Oct 2017 07:06 pm

according to ur reference Manages contain (Manager attributes ,primary keys of works-on ) Am i right?