Consider a STUDENT and ADVISOR database. Students have a student number and student name. Advisors have names,
Question:
Consider a STUDENT and ADVISOR database. Students have a student number and student name. Advisors have names, of ce numbers, and advise in some major. Te major the advisor advises in is designated by a major code (e.g., Chemistry, CHEM; Biology, BIOL; Computer Science, COMPSC; . . .). Draw the ER diagram using the Chen-like model. Follow the methodology and include all English descriptions of your diagram. Map the ER diagram to a relational database and include some sample data.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Database Design Using Entity Relationship Diagrams
ISBN: 9781032017181
3rd Edition
Authors: Sikha Saha Bagui, Richard Walsh Earp
Question Posted: