Answered step by step
Verified Expert Solution
Link Copied!

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 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Server Query Performance Tuning

Authors: Sajal Dam, Grant Fritchey

4th Edition

1430267429, 9781430267423

More Books

Students also viewed these Databases questions

Question

LO2 Compare three types of individual incentives.

Answered: 1 week ago