/*1. Define a table named 'Customer' with the following fields. Assign the datatypes you think are appropriate. ID should be the main identifer of the table:
ID
FirstName
LastName
DateOfBirth
Active
*/
/*2. Define a table named 'Product' with the following fields, etc.
ProductName
/*3. Define a table named 'Purchases' with the following fields, etc. This table contains data of all customers who have purchased a specific product.
How would you relate 'ProductID' to the product table, and 'CustomerID' to the Customer table?
ProductID
CustomerID
PurchaseDate
/*4. Write a query that will return the
FirstName,
LastName,
ProductName,
For customers who have only purchased a product with the Id 1
/*5. How would the output change if I modified the query to...*/