Chapter 1: (10 points each)

1. Give an example of two related tables other than one in the textbook. Use the STUDENT and GRADE tables in Figure 1-1 of the textbook as an example pattern for your tables. Name the tables and columns using the conventions in the textbook. * I used MysqL workbench to create 2 tables 1- Customers that has customers with some of their information(primary key is “Customer ID”) * CREATE TABLE IF NOT EXISTS `mydb`.`Customer` ( * `CustomerID` INT NOT NULL, * `Name` VARCHAR(45) NULL, * `Email` VARCHAR(45) NULL, * PRIMARY KEY (`CustomerID`), * UNIQUE INDEX `Email_UNIQUE` (`Email` ASC)) * ENGINE = InnoDB 2- Purchases that has number of purchases that has been done by the customers(Pkey is PurchaseID, and foreign key is “CustomerID” from Customer table. * CREATE TABLE IF NOT EXISTS `mydb`.`Purchases` ( * `PurchasesID` INT NOT NULL, * `productID` INT NULL, * `PricePaid` INT NULL, * PRIMARY KEY (`PurchasesID`)) * ENGINE = InnoDB * * *note I made the customerID as the foreign key and the relationship is (1 to many) * * * Figure1 the Customer and Purchases tables’ relationship. * 2. For the tables you created in Question 1, what are the primary keys of each table? Do you think that any of these primary keys could be surrogate keys? * In Customer table the Primary key is CustomerID * In the Purchases table the primary key is PurchaseID * Both of them can be generated by the database management system (MySQl). They can be surrogate keys by adding 1. 3. Explain how the two tables you provided in Question 1 are related. Which table contains the foreign key, and what it is the foreign key? * The Customer table has customers that make purchases, the relation between the tables is 1 to many and the primary key for