This lesson's interactive features are locked, please to keep using them

Query Practice – Users & Banks

Someone added new columns to CashPal's users table that include information on the user's banking institution. Unfortunately, the developer that made these changes had assumed that a user could have only a single banking institution.

We know that a user can be a member of multiple banks, and that each bank may service a great number of CashPal users. You've been tasked with cleaning up the users table and creating any additional tables to properly support a many-to-many relationship between banks and users.

Assignment

Given what you've learned about normalization and many-to-many relationships, do the following:

Create a new table called banks that contains any bank-related columns that were incorrectly added to the users table and were prefixed with bank_. Be sure to omit the bank_ prefix when creating the table; we won't need it anymore. (Don't worry about altering the users table right now.)
Create a joining table named users_banks with user_id and bank_id columns. Add any constraints such that there is never a duplicate row with the same user_id and bank_id combination.
Add foreign keys so user_id references users(id) and bank_id references banks(id).