Order Entry Database Background The Order Entry database is used for practicing building a database, creating tables, and populating tables with values in Access. This is used for learning how to create CREATE TABLE and INSERT INTO statements in SQL. This document describes the tables and relationships. Table Description and Usage Table 1 lists the meaning of each table and Figure 1 shows the Oracle database diagram. After the relationship diagram, sample rows are shown for each table. In addition to the other documentation, here are some notes about the Order Entry Database The primary key of the OrdLine table is a combination of OrdNo and ProdNo. The Employee table has a self-referencing (unary) relationship to itself through the foreign key, SupEmpNo, the employee number of the supervising employee. In the relationship diagram, the table Employee I is a representation of the self-referencing relationship, not a real table. Table Name Customer Order Thi Employee OnLi Product Table 1: Tables of the Order Entry Database Description Last of customers who have placed onders Contains the beading part of an order, Internet onder de sot have an employee List of employees who can take onders Contains the product detail parts of orders List of products that may be ordered MacBo a ! @ # $ % 1 2 3 4 5 6