Consider the following relations: BOOKS (BookNo, Title, Author, ISBN, Stock, Price, Tax) STORE(StoreNo. City, State, Zip, Inventory) STOCK(StoreNo. BookNo.Qty) 4. Assume the attribute city in STORE...

Extracted text: Consider the following relations: BOOKS (BookNo, Title, Author, ISBN, Stock, Price, Tax) STORE(StoreNo. City, State, Zip, Inventory) STOCK(StoreNo. BookNo.Qty) 4. Assume the attribute city in STORE table takes three different values like "Muscat", “Nizwa" and "Sohar". i. Show the predicates by which STORE may be Horizontally partitioned by City. How would be a derived Horizontal partitioning of STOCK be defined based on the partitioning of the STORE? ii.