Draw an Entity Relationship Diagram for all of those below. (a simple one)Each lecturer is identified by a unique number, name and phone. A lecturer teaches several courses, and for each course there is a unique code and title (not necessarily unique). There might be several lecturers in a course.Each course requires one or more text books. Each text book is used in at least one course. A text book is identified by a unique ISBN, and its title, authors, publisher and year of publication are known. Each course has a unique code.The bank has many customers. Every customer has at least one account with the bank. An account may be shared by several customers. Each customer has a unique number, type, the opening date and the balance.A flight carries many passengers on a specific airplane. Each airplane has a unique number, while each flight has a code (unique), destination and origin. A passenger has a name, passport number and nationality

As per our guidelines, we are supposed to answer only 1st three parts. Kindly repost the remaining…

Answered: Draw an Entity Relationship Diagram for…

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%

Draw an Entity Relationship Diagram for all of those below. (a simple one)

Each lecturer is identified by a unique number, name and phone. A lecturer teaches several courses, and for each course there is a unique code and title (not necessarily unique). There might be several lecturers in a course.
Each course requires one or more text books. Each text book is used in at least one course. A text book is identified by a unique ISBN, and its title, authors, publisher and year of publication are known. Each course has a unique code.
The bank has many customers. Every customer has at least one account with the bank. An account may be shared by several customers. Each customer has a unique number, type, the opening date and the balance.
A flight carries many passengers on a specific airplane. Each airplane has a unique number, while each flight has a code (unique), destination and origin. A passenger has a name, passport number and nationality

Expert Solution