#203 Designing a Schema for Banks, Clients, and Accounts

Companies:

Bank of Russia

Themes:

SQLSQL BasicsPractice

Design a database that contains the following information:

Banks in the Russian Federation
Clients who are individuals
Accounts consisting of 20 digits

It is required to create:

Tables
Main fields, 2-3 for each
Constraints
Table relationships

Question review

Mentor

Answer as you would in a real interview. I’ll ask follow-up questions, then compare your answer with the reference answer and show your accuracy as a %.

Sign in to start the dialogue The mentor keeps the context of the current question and your previous messages.