You are a database developer for an online book retailer.
Customers use the company’s web site to place orders for books.
As orders are entered, they are inserted into a database named BookOrders.
During a nightly batch process, the order information is transferred to a database named Reports.
The Reports database includes a table named Order and a table named LineItem.
The Order table contains basic information about the orders. The LineItem table contains information about the individual items in the orders.
The Order and LineItem tables are shown in the exhibit. Customers must be able to use the company’s web site to view orders stored in the Reports database.
Customers should be able to see only their own orders. Customers should not be able to modify the orders. The primary key values of the orders are not relevant to the customers and should not be visible.
What should you do?