1. List and give an example of the three types of binary relationships (1:1, 1:N, N:M) other than the ones used in this book. Draw an IE Crow’s Foot E-R diagram for each.
2. Draw an IE Crow’s Foot E-R diagram for the entities DEPARTMENT and EMPLOYEE and the 1:N relationship between them. Assume that a DEPARTMENT does not need to have an EMPLOYEE, but that every EMPLOYEE is assigned to a DEPARTMENT. Include appropriate identifiers and attributes for each entity.
3. Create properties for the attributes in your E-R diagram for DEPARTMENT and EMPLOYEE in question 2 (type, length, etc). Create sample data.
4. Give an example of a business rule for your work for question 2.
5. Consider the following business rules: A course can generate many classes. Each class is generated by a course. A course may or may not generate a class. The following figure shows sample Instances of the COURSE Entity.
In the CLASS entity, we have attributes CLASS_CODE, CLASS_SECTION, and CLASS_TIME. Draw an IE Crow’s Foot E-R diagram.