请帮助我解决这些表,如下
product id product name quantity unit price
P01 Processor 50 8500
P02 Hard Disk 50 4500
P03 RAM 50 2500
Customer ID Customer Name Address
C001 Saman Kumara Galle Rd, Colombo 3
C002 Gamini Silva No 23,Nugegoda
C003 Samantha Perera Nawela Road,Nugegoda
Sales ID Customer ID Product ID Quantity
S01 C001 P01 10
S02 C001 P02 5
S03 C001 P03 3
S04 C002 P01 2
您应该为每个实体(表(引入扩展谓词作为Prolog事实:
% product(product_id, product_name, quantity, unit_price)
product('P01','Processor', 50,8500).
product('P02','Hard Disk', 50,4500).
product('P03','RAM', 50,2500).
etc etc
然后专注于完成作业所需的查询。