Based on the following business rules, draw a Crow's Foot Model:

1. Your department needs to track the course development their faculty are doing.
2. Multiple professors can collaborate on developing a course.
3. Course information must maintain a last revised date.
4. Courses can require students use up to 10 different resources, but at least one of them must be a textbook.
5. Resources can be web sites, journal articles, images, videos, and textbooks.
6. A course can have a prerequisite.
7. All course numbers are a combination of the dept code and course code.
8. All professor contact information needs to be available to ask questions.
9. Course names must be unique.

Your ERD needs to fulfill the following requirements:

1. Convert M:N relationship, if any, into two 1:M relationships through a composite entity
2. Specify all appropriate Relationship Participation (optional or mandatory)
3. Specify all appropriate CONNECTIVITIES
4. Specify the primary key and foreign key(s) (if applicable) for each entity
5. Name and list 1-3 major attributes other than the primary key and the foreign key(s) (if applicable) for each entity
6. If you need to make any assumption, please mention them
7. The ERD will be created using online drawing tools I mentioned in the syllabus or any other tools you prefer.

Answer rating: 100% (QA)

Here is the ERD Entities 1 Department Primary Key Dept Code Major Attributes Department Name Locatio... View the full answer