The files fatty_food.txt and normal_food.txt contain a subset of the mouse transcriptome data we already used in Chap. 7.1. Figure 7.4 shows an Entity-relation (ER) model of the database we wish to construct. Boxes are entities, ellipses attributes, and the diamond denotes a relationship. Itâ€™s a oneto-one relationship, where each entry in fatty_food has a corresponding entry in normal_food. The underlined attribute is a unique primary key. Here is the code for constructing table normal_food
Create the directory RelationalDb, and copy the data files into it. Write the code for constructing table normal_food into the the file normal_food.sql, and then write the corresponding file fatty_food.sql.