September 2017
Beginner to intermediate
446 pages
9h 17m
English
From our inspection of the individual tables, we have seen that ID in the Customer table is logically the same variable as Customer_ID in the Orders table. These fields can serve as a primary key for matching; however in order for the match to work, they must have the same name.
In addition, we must understand whether the relationship between the records in the two files is one-to-one or one-to-many.
The Customer table has one record per customer with ID ranging from 1 to 29 consecutively.
The Orders table has all orders placed in the first six months of 2006. Not all customers have placed orders in this time period. Of those customers who placed orders, the number of orders ranges from 2 to 6. Therefore, ...
Read now
Unlock full access