Question: Generally speaking, to implement a data model about the sales and cash collection processes in a relational database, the association between Customers and Sales would
Generally speaking, to implement a data model about the sales and cash collection processes in a relational database, the association between Customers and Sales would be implemented by?
1. Placing "customer ID" as a foreign key in the Sales table.
2. Placing "Sales invoice number" as a foreign key in the Customers table.
3. Creating a new linking table
4. Merging Customer and Sales into one table.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
