The conceptual design for this database includes three tables: • Product(manufacturer_ID, model_nbr, group_ID, type_code

[answerhappygod]

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)
o The Product table contains data on the manufacturer, modelnumber, the ID number of the product group ('PC', 'Laptop', or'Printer') and the code number for the type of device (ink jet,laser, desktop, portable, hand-held, etc.).
o It is assumed that model numbers in the Product table areunique for all makers and product types.
o Each personal computer in the PC table is uniquely identifiedby a serialized code and its model number (foreign key referring tothe Product table), processor speed (in MHz) in the cpu_speedfield, RAM size in Mb, hard disk drive capacity (in Gb), and itscurrent sale price.
o Each printer in the Printer table is identified by aserialized code number and its model number and manufacturer.Attributes for the printer type ('Laser', 'Jet', or 'Matrix'), andcurrent sale price are also included in the Printer table.
1. Write T-SQL queries to list: 1. the PCs and Printers (onseparate queries) by product and manufacturer
2. all a manufacturer’s products (printer and PCs) in stock
3. all items in stock by sale price descending.