#Conversion #ER #Table
COURSE is the strong entity related to SUBJECT. Hence the primary key COURSE_ID of COURSE is added to SUBJECT table as foreign key.
If you want to change selection, open document below and click on "Move attachment"
Convert ER Diagram into Tables - Generalization - Specialization - Aggregation - Transform ER Diagram into Tablesle. Although SUBJECT_ID is represented as key attribute in the diagram, it cannot be considered as primary key. In order to add primary key to the column, we have to find the foreign key first. <span>COURSE is the strong entity related to SUBJECT. Hence the primary key COURSE_ID of COURSE is added to SUBJECT table as foreign key. Now we can create a composite primary key out of COURSE_ID and SUBJECT_ID. Representing 1:1 relationship Imagine SUBJECT is not a weak entity, and we have LECTURER teaches SUBJECT relat Summary
status | not read | | reprioritisations | |
---|
last reprioritisation on | | | suggested re-reading day | |
---|
started reading on | | | finished reading on | |
---|
Details