Design a physical ERD for a two-table database to store student contact information and advisor information. The
Question:
Design a physical ERD for a two-table database to store student contact information and advisor information. The student table should include a student id, first and last name, phone number, and email address. The advisor table should include an advisor ID, first and last name, phone number, and email address. Each student has one advisor. Each advisor has many students. A student is assigned an advisor when entered into the system.
Determine the following:
• an appropriate primary key for each table and identify it
• an appropriate foreign key to create the relationship and identify it
• the cardinality of the relationship and note it using crow's foot notation
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi