1. SQL code to create tables: ---------------------------------------------------------------------- Create table Project (ProjectID INT NOT NULL AUTO_INCREMENT, Type VARCHAR(10) NOT NULL, Name VARCHAR(20) NOT NULL, Location VARCHAR(10), DateOfFunding DATE, AmountOfFunding DOUBLE, PRIMARY KEY (ProjectID)); Create table Event (EventID INT NOT NULL AUTO_INCREMENT, Description VARCHAR(20) NOT NULL, Location VARCHAR(10) NOT NULL, Date DATE, Sponsor VARCHAR(10), EventFundingGoal VARCHAR(10), CollectedFunds DOUBLE, PRIMARY KEY (EventID)); Create table Donors (DonorsID INT NOT NULL AUTO_INCREMENT, FirstName VARCHAR(10) NOT NULL, LastName VARCHAR(10) NOT NULL, Address VARCHAR(50) NOT NULL, City VARCHAR(10) NOT NULL, State VARCHAR(10), ZipCode VARCHAR(6), Phone VARCHAR(11), Email VARCHAR(255) PRIMARY KEY (DonorsID)); Create table Donations (DonationID INT NOT NULL AUTO_INCREMENT, Amount DOUBLE, Date DATE, TransactionNum VARCHAR(20), DonorsID INT, ProjectID INT, EventID INT, PRIMARY KEY (EventID), FOREIGN KEY (DonorsID) REFERENCES Donors(DonorsID), FOREIGN KEY (ProjectID) REFERENCES Project(ProjectID), FOREIGN KEY (EventID) REFERENCES Event(EventID), ); ----------------------------------------------------------------------- 1. Insert statement: Syntax of 'Insert' statement to add a record to a table is as follows: INSERT INTO (,,...................) VALUES (,,.............................) Ex.: INSERT INTO Project(Type,Name,Location,DateOfFunding,AmountOfFunding) VALUES ("Software","Billing System","Boston","2016-01-01",340.50); Similarly you can insert other records also. 3. Add a new column for fax number to donor table: See the command below: ---------------------------------------------- ALTER TABLE Donors ADD Fax VARCHAR(11); ------------------------------------------------ 4. Select query: ------------------------------------------------------- Select Donor.FirstName, Donors.LastName, Donations.Amount from Donors, Donations where Donors.DonorsID = Donations.DonorsID