Draw an Entity Relationship Diagram for all of those below.Draw an ER diagram to represent information about students. A student is identified by his/her student number. Student’s name (first and last), permanent address, phone number, gender and date of birth are also stored.An airplane has a registration number, type, number of economy class seats, number of business class seats and the year of production.Some students live in student halls. Each hall has a name (unique) and an address. Each student has a number (unique) and a name. Assume that there are students living in every hall.Each text book has a unique ISBN (International Standard Book Number), and contains several chapters. Each chapter has a chapter number (unique within a book), the number of pages and the number of references. A chapter covers a single topic, but the same topic may be covered in various books.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

Note: As per our guidelines I am solving Ques 1 for you. Kindly repost other questions separately.…

Answered: Draw an Entity Relationship Diagram for…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

100%

Draw an Entity Relationship Diagram for all of those below.

Draw an ER diagram to represent information about students. A student is identified by his/her student number. Student’s name (first and last), permanent address, phone number, gender and date of birth are also stored.
An airplane has a registration number, type, number of economy class seats, number of business class seats and the year of production.
Some students live in student halls. Each hall has a name (unique) and an address. Each student has a number (unique) and a name. Assume that there are students living in every hall.
Each text book has a unique ISBN (International Standard Book Number), and contains several chapters. Each chapter has a chapter number (unique within a book), the number of pages and the number of references. A chapter covers a single topic, but the same topic may be covered in various books.
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