Question
Study the following Data Structure and re-design the attributes if necessary to allow future inquiry. Additionally, one student is assigned one advisor per year, one
Study the following Data Structure and re-design the attributes if necessary to allow future inquiry. Additionally, one student is assigned one advisor per year, one advisor can have several students as advisees.
STUDENT
Name | Address | Banner No | Gender | Phone No | Advisor | Degree | Degree date | Years_Since_Attending |
Adam J. Smith | 309 Snow Street, Fayetteville, NC, 28313 | 8307312988 | Male | 910-234-4123 | Dr. Lee James, Dr. John Deed | BS, MS | 2011, 2014 | 1.5 |
Mary F. Jones | 512 Gate Street, Spring Hill, NC, 29211 | 8308132900 | Female | 910-213-8970 | Dr. Ronald Masters, Dr. Jane Nee, Dr. Joy Walch | BA | 2017 | 2.4 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started