Assignment: Crow's Foot E-R Diagrams
Include the questions with your answers. Answer in complete sentences where applicable.
1. Give an example of a data constraint and an example of a business rule. Be sure to label which is which so I can tell you know the difference.
2. Explain the difference between an entity class and an entity instance, and give an example other than those used in the text or the lectures.
3. Define the term "weak entity" and give an example other than those used in the text.
4. Define supertype, subtype and discriminator.
5. Explain the difference between and inclusive subtype relationship and an exclusive subtype relationship.
6. Using Microsoft Visio (available through Microsoft Azure Dev Tools) draw an IE Crow's Foot E-R diagram for the entities DEPARTMENT and EMPLOYEE. A DEPARTMENT may have more than one EMPLOYEE, but an EMPLOYEE is only assigned to one DEPARTMENT. Assume that a DEPARTMENT does not need to have an EMPLOYEE, but that every EMPLOYEE is assigned to a DEPARTMENT. Include at least three appropriate identifiers and attributes for each entity.
7. Explain the following crow's foot E-R diagram. Be sure to include entities, keys, attributes, cardinality. What is the special type of entity represented by COMMISSION_RATE?
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.