The sales database contains a customer table and an order table. For each order there is one and only one customer - and for each customer there can be zero or more orders. How should primary and foreign key fields be placed into the design of this database?

Practice this Upwork Skill Test. Freelancers take skill tests on Upwork to show their skills to potential clients and to make themselves more marketable. Upwork suggests you take as many tests as you want -  your skills are shown on your Upwork profile page.