Answered: Using Crow’s foot notation, draw an ER…

Computer Networking: A Top-Down Approach (7th Edition)

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...

See similar textbooks

Related questions

Question

Using Crow’s foot notation, draw an ER diagram of the conceptual schema for another part of a University database, described as follows: You must show connectivity, cardinality, participation and relationships strength. Academic staff, general staff and students are the only persons at the university. Each person is either an academic staff, or a general staff, or a student. A person is uniquely identified by a PerId (person's ID), and has a Name and an Address. An Address is composed of HouseNo, Street, and City. A characteristic property of a student is that she/he has at least one Major and one NoOfPts (number of points) for each major. An academic staff has a Position and an AcQual (academic qualification). A general staff has a GenPos (general position). An academic staff teaches at most one course, whereas a student takes at least one course. A course is uniquely identified by a CourId (course ID), and has a CourName (course name). Each course is taught by at least one academic staff, and can be taken by many students, but there may be courses that are not taken by any students. Each course can use more than one textbook, but there may be courses with no textbook. A textbook is uniquely identified by the course which uses the book, and by an OrdNo. The attribute OrdNo is the ordinal number of the book in the list of the textbooks of a particular course. A book also has a Title.

Expert Solution