accounting information systems

fill out the blanks

Basic steps in implementing an REA diagram in a relational database Implemention an REA diagram in a relational database con of three steps: Step 1: Create a table fori Each distinct entity in the d agtam. Each many to many relationship, seep 2 Assigo attributes to appropriate tables. The primary key is usually a single attribute. (e.g., Inventory table ProductID) For M:N relationships the primary key consists of two attributes that represent the primary keys of each entity linked in that relationship. (e.g., Sales tory table -Invoice No & ProductID) Step 3: Use foreign keys to implement one-t one and one-to-many relationships e Mandatory one-to-one 10 relationship o Collapse two entities to create one table. Optional one-to-one (:1) relationship o Both optional one-to-one relationship When there are two sequential events, the primary key of the event that occurs first is usually the foreign key in the event that occurs second. o Optional and mandatory one-to-one relationship Insert the primary key of the entity that can occur a minimum of one time as a foreign key in the entity that can occur a minimum of zero times. One-to-many relationship Place the primary key of the entity that can occur only once as a foreign key in the entity that can occur many times