Answered: One course may require none or one…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

100%

One course may require none or one other course as its prerequisite
One course can be a prerequisite for only one other course
One course can use as many as 10 resources. The resources can be Web sites, journal articles, images, or audios
One resource will be used by at least one course or many courses
One resource can have multiple creators, but only the first creator is recorded in the CREATOR table
One creator may develop multiple resources
One publisher can publish many resources
One resource is published by one publisher or hasn't been published yet.

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

Your ERD needs to fulfill the following requirements:

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

Expert Solution