Here if check_txn contains its own attributes then during converting into a relational model where does its attributes will be placed either in account side ( strong entity set) or check side (weak entity set)? and why?
then relationship must have it's own table
http://www.learndb.com/databases/how-to-convert-er-diagram-to-relational-database
Because it's a many-to-one relationship, I can add the attributes of check_txn in the check table itself. I don't need a separate table for the relationship.
64.3k questions
77.9k answers
244k comments
80.0k users