Convert the database schema into a sql database and show tables

Normalize the database tables and explain how it was Normalized

 

Transcribed Image Text:

Index of Efficient Charities Governmental id Website Link Volunteers Volunteer id Doners IBAN Charities Governmental id Donation to index Donation reference Number Donate Donate id Rank of Charities Final impact Supervie supervise id First-name First-name IBAN Governmental_id Donation reference Number cost-efficient First-name Name Last-name Last-name IBAN Phone Number Governmental_id Charity Name Telephone Number Phone Number Last-name Donation Phone Number reference Number percentage of spending on operational overall score out of 100 costs out of total funds Address Volunteer_id IBAN transperancy Rank average spending per riyal on projects Governmental_id IBAN Volunteer_id Governmental_id Index of Efficient Charities Governmental id Website Link Volunteers Volunteer id Doners IBAN Charities Governmental id Donation to index Donation reference Number Donate Donate id Rank of Charities Final impact Supervie supervise id First-name First-name IBAN Governmental_id Donation reference Number cost-efficient First-name Name Last-name Last-name IBAN Phone Number Governmental_id Charity Name Telephone Number Phone Number Last-name Donation Phone Number reference Number percentage of spending on operational overall score out of 100 costs out of total funds Address Volunteer_id IBAN transperancy Rank average spending per riyal on projects Governmental_id IBAN Volunteer_id Governmental_id

Answer rating: 100% (QA)

Based on the diagram provided which appears to represent an EntityRelationship Model ERM for a database related to charities volunteers and donors we will first define the SQL statements needed to cre... View the full answer