help with erd diagrams

I would suggest to prepared clear diagram. in above diagram Lines are not clear. Diagram should be simple, so everyone understands.

For example:

In above Course table have dependency of Course_to_major and Department table so drag or draw the Course_to_major and Department table near Course table so it will give very clear view and line should be straight-line.

0

Laxmidhar Sahoo7y ago

Thanks Amit

0

Amit Gupta7y ago

I always use ID (autoincriment), TableNameID (like CourseID, DeptId), CreatedBy, CreatedDate etc and rest as per the requirement. Just play with these TableNameID for CRUD operations, so that each and every field would be customizable.

+2

Laxmidhar Sahoo7y ago

There is no primary key column .It is better for joining

0