You may have been assigned a CASE or a drawing tool to develop conceptual data models. Using this tool, attempt to redraw all the E-R diagrams in this chapter. What difficulties did you encounter? What E-R notations did not translate well to your tool? How did you incorporate the E-R notation that did not directly translate into the tools notation?

FIGURE 2-24 Data model for Pine Valley Furniture Company in Microsoft VIslo notation \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ PRODUCT LINE } \\ \hline PK & Product Line ID \\ \hline & Product Line Name \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ CUSTOMER } \\ \hline PK & Customer ID \\ \hline & CustomerNameCustomerAddressCustomerPostalCode \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ ORDER } \\ \hline PK & Order ID \\ \hline & Order Date \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ PRODUCT } \\ \hline PK & Product ID \\ \hline & ProductDescriptionProductFinishProductStandardPrice \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ ORDER LINE } \\ \hline & \\ \hline & Ordered Quantity \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ VENDOR } \\ \hline PK & Vendor ID \\ \hline & VendorNameVendorAddress \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ PRODUCED IN } \\ \hline & \\ \hline & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline \multicolumn{2}{|c|}{ RAW MATERIAL } \\ \hline & SUPPLIES \\ \hline & Supply Unit Price \\ \hline \end{tabular} \begin{tabular}{|c|l|} \hline \multicolumn{2}{|c|}{ WORK CENTER } \\ \hline PK & Work Center ID \\ \hline & Work Center Location \\ \hline \end{tabular} Is Supervised By \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ SKILL } \\ \hline PK & Skill \\ \hline & \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ EMPLOYEE } \\ \hline PK & Employee ID \\ \hline & EmployeeNameEmployeeAddress \\ \hline \end{tabular}