Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 attributes known as uni uni uni uni for each of the records. the other table called universites the universitertable contain uniname uniid and each uni have leaders and deputy leaders and finaly they have got something called principle so basically the attributes uni uni and uni and uni 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
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