(NOTE: Please read the questions before posting. The lastresponse had answers from a completely different set of questionfor the problem. This is not the same set of questions as theprevious requests.)
The conceptual design for this database includes threetables:
Product(manufacturer_ID, model_nbr, group_ID, type_code)
PC(code, model, cpu_speed, ram_size, hd_size, price)
Printer(code, manufacturer_ID, model, ptr_type, price)
Write T-SQL queries to list: the PCs and Printers (on separatequeries) by product and manufacturer all a manufacturer’s products(printer and PCs) in stock all items in stock by sale pricedescending.
(NOTE: Please read the questions before posting. The last response had answers from a completely different set of questi
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am