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.
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.
Principles of Information Systems (MindTap Course List)
12th Edition
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter12: Systems Development: Investigation, Analysis, And Design
Section: Chapter Questions
Problem 12SAT: Data modeling is most often accomplished through the use of a(n) __________________. a....
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Recommended textbooks for you
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning