(Solved) : Following Relational Schema Given Computer Store System Store Storeid Storename City Compu Q33388692 . . .
The following relational schema is given for a computer store system Store (storeID, storeName, city) Computer(computerID, mode1Name, price) Processor (processorID, modelName, numberOfCores, baseClockSpeed) Memory (memoryID, modelName, capacity) Sells (storeID, computerID, stock) In the Store table, storeID is an integer primary key, storeName is a string that corresponds to the name of the store and city is a string that corresponds to the name of the city where the store is located in. In the Computer table, computerID is an integer primary key, modelName is a string that corresponds to the model of the computer. (There could be different entries in this table with the same model name, but with different prices and internal parts, because of this model name is not unique.) Price is an integer, that corresponds to the cost in Turkish Liras. In the Processor table, processorID is an integer primary key, modelName is a string, numberOfCores is an integer that corresponds to the number of cores, baseClockSpeed is a double that corresponds to the processor speed in GHz. In the Memory table, memoryID is an integer primary key, modelName is a string, capacity is an integer that corresponds to the memory capacity in GB Sells table relates one store with a computer, storeID is a foreign key that references Store, and computerID is a foreign key that references Computer table. Stock is an integer that corresponds to the number of such computers this store sell. Has table relates one computer with one processor and memory. ComputerID is a foreign key that references Computer, processorID is a foreign key that references Processor and memoryID is a foreign key that references Memory table. Write the following queries in SQL, based on the given information. 5) Find the average cost of computers that have the processor with model name “i7-4800MQ. 6) Find name of stores that have at least 5 computers in stock that cost more than 15.000 TL. 7) Find the average base clock speed of processors with 16 cores. 8) Increase the price of computers, that either have a memory of 8GB capacity or have a processor with 2.8 GHz base clock speed, by 200 TL. Show transcribed image text
Expert Answer
Answer to Following Relational Schema Given Computer Store System Store Storeid Storename City Compu Q33388692 . . .
OR