SQL third normal form (3NF) for database schema design.
Budget: ₹600 – ₹1,500 INR
Draw your model structure: tables, fields, mark primary keys, foreign keys, draw relationships between tables.
You should use third normal form (3NF) for database schema design.
It should be database to store information about bank customers, their addresses, and payments they are making.
Your model should not contain all possible fields, but please read carefully questions below. Your model should cover demanded analysis to get all needed answers.
For all questions below please write SQL scripts to get answer. You should use your tables and fields, please consider performance – try to provide effective queries.
Please find the list of customers, which are duplicated. Meaning when the bank has the same customer entered twice. Consider customer identity by: name, surname, personal code and date of birth.
Please find customers, who spent/payed more money in March 2020, than in February 2020.
How many customers do we have from Australia (country of residence), who made payments to Germany during the April 2020.
Find customers who is resident Latvia and never payed to Germany.
Please write script for customers deletion, in order to remove duplicates, meaning after deletion your script from 3rd point should return 0.
You should use third normal form (3NF) for database schema design.
It should be database to store information about bank customers, their addresses, and payments they are making.
Your model should not contain all possible fields, but please read carefully questions below. Your model should cover demanded analysis to get all needed answers.
For all questions below please write SQL scripts to get answer. You should use your tables and fields, please consider performance – try to provide effective queries.
Please find the list of customers, which are duplicated. Meaning when the bank has the same customer entered twice. Consider customer identity by: name, surname, personal code and date of birth.
Please find customers, who spent/payed more money in March 2020, than in February 2020.
How many customers do we have from Australia (country of residence), who made payments to Germany during the April 2020.
Find customers who is resident Latvia and never payed to Germany.
Please write script for customers deletion, in order to remove duplicates, meaning after deletion your script from 3rd point should return 0.