Chapter $3$ and Chapter $4$

$($Data Modeling and Relational Databases and Enterprise Systems$)$

$1.$ What do the initials $$ERP$$ stand for? To integrate a company$$s operations what are the five most common ERP modules that a company would implement? What are the advantages of a relational database model over the traditional hierarchical model?

$2.$ What do the initials $$REA$$ stand for? What does REA modeling allow us to determine in database design?

$3.$ What role does multiplicity analysis play in database design? Describe one real world business example for each of the following:

$$ One$-$to$-$one relationships

$$ One$-$to$-$many relationships

$$ Many$-$to$-$many relationships

Which relationship is most common? Which does a relational database handle most easily? How is a many$-$to$-$many relationship resolved?

$4.$ What are the advantages and disadvantages of a cloud based computer system?