Figure 2: Definition of ORDERS table

 
CREATE TABLE orders(custno INT, 
                        type CHAR(10), 
                        ordernum INT generated always as Identity)