

0 / 2 embers
0 / 3000 xp
click for more info
Complete a lesson to start your streak
click for more info
Difficulty: 6
click for more info
Not enough gems
Cost: 6 gems
1: Table Relationships
incomplete
2: One to Many
incomplete
3: Many to Many
incomplete
4: Database Normalization
incomplete
5: Normal Forms
incomplete
6: Primary Keys
incomplete
7: Functional Dependencies
incomplete
8: First Normal Form (1NF)
incomplete
9: Second Normal Form (2NF)
incomplete
10: Third Normal Form (3NF)
incomplete
11: Boyce-Codd Normal Form (BCNF)
incomplete
12: Normalization Review
incomplete
13: Query Practice – Users & Banks
incomplete
Back
ctrl+,
Next
ctrl+.
This lesson's interactive features are locked, please to keep using them
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.
Given what you've learned about normalization and many-to-many relationships, do the following: