Question: i have two tables one called names: it contian name , nameid ( primary key ) , and 4 attributes known as uni 1 uni

i have two tables one called names: it contian name , nameid (primary key), and 4 attributes known as uni1 uni2 uni3 uni4. for each of the records. the other table called universites the universitertable contain uniname uniid and each uni have 4 leaders and 5 deputy leaders and finaly they have got something called principle . so basically the attributes uni1 uni2 and uni3 and uni4 are basically matching to uniID in the universities table. ALSO leaders directors and principles are basically student id of studennt who are taking theses role in their uni. same uni might have multi different princiles. as you cn see there might be repetion in the number of recrords what i want is to have new table that called studentinuni to solve this probelm what i want from you is the migration querey in mysql to complete the question

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!