Write the business rules that are reflected in the ERD shown in Figure (Note that the ERD reflects some simplifying assumptions. For example, each book is written by only one author. Also, remember that the ERD is always read from the “1” to the “M” side, regardless of the orientation of the ERDcomponents.)
Answer to relevant QuestionsCreate a Crow’s Foot ERD for each of the following descriptions. (Note: The word many merely means “more than one” in the database modeling environment.)a. Each of the MegaCo Corporation’s divisions is composed of ...Which relational algebra operators can be applied to a pair of tables that are not union-compatible?What are homonyms and synonyms, and why should they be avoided in database design?A database user manual notes that, “The file contains two hundred records, each record containing nine fields.” Use appropriate relational database terminology to “translate” that statement.Draw the ERD to show the relationships among EMPLOYEE, STORE, and REGION.
Post your question