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.

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
Looking for a Similar Assignment? Our Experts can help. Use the coupon code SAVE30 to get your first order at 30% off!

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp