Case 3 (5%) Based on the following tables, Required a. Draw the most likely underlying conceptual model. b. Enter each of the tables into a database in Microsoft Access; create the relationship layout and enforce referential integrity where it seems appropriate. Sale Sale# Date ITA Terms Salesperson ID Customer ID 2543 2 10, net 30 5/11 2 10, net 304 635 COD 1845 Sale-Inventory Sale# Inventory Item # 876 674 451 887 513 736 001 302 224 | Quantity Sold | Price each item 10 30 54 188 36 58 16 114 MOP12.50 MOP8.75 MOP9.95 MOP14.75 MOP5.25 MOP249.95 MOP78.75 MOP80.00 MOP87.50 Salespersorn Salesperson ID Last Name Au Bu Chen Du First Name Ada Bernard Cathy David Cashier Cashier ID Last Name Xu Young First Name Xesia Yvonne Cash Receipt CashRec | Date | Check# | Cashier | Sale# | Customer Cash 1001 6/11 110971 Amount ID Account Received 110146758 MOP178.35 ID 635 Customer Customer ID Last Name First NameAddress 101 183 635 1845 2543 Mou Ngan Ou Pang Moms Nancy Oliver Patrick Queenie Taipa Hangqin Wanchai Coloane XiangzhouZhuhai Macau Zhuhai Hong Kong Macau Cash Type of Account Regular checking Payroll checking account|XYZ Bank Bank Name Cash# 110146758 1203948102 ABC Bank Inventory Inventory item # 001 224 302 451 513 674 736 876 887 Description T- Shirt XL Sweatshirt XL T-Shirt XXL Felt pennant Table tennis ball Golf ball Polo Shirt XL Bumper sticker Foam football