create relational database tables and Microsoft access data base for kudler frequent shopper program
dnely71
kudler.accdb
| Customer_ID | Last_Name | First_Name | Middle_Initial | Address | City | State | Zip_Code | Phone_Number | Fax_Number | Birth_Date | Anniversary_Date | Email_Address |
| Item_ID | Inventory_ID | Perishable_Indicator | Perishable_Date | Department_ID | Category | Description | Unit_of_Measure | Quantity_on_Hand | Unit_Cost | Master_Pack_Quantity | Supplier_ID | Assembly_Item | Substitute_Item | Tag_Along_Item |
| Item_ID | Item_Type | Taxable_Nontaxable | Short Description | Long Description | Quantity | Regular_Price | Promo_Price | Labor_Cost |
| Store_Code | Order_ID | Sales_Person_ID | Order_Source | Customer_ID | Tax_Amount | Pickup_Time |
| Store_Code | Order_ID | Order_Line_ID | Customer_ID | Item_ID | Price | Units_Purchased |
| Store_Code | Store_Name | Store_Address | Store_City | Store_State | Store_County | Store_Zip_code | Store_Phone_Number | Store_Fax_Number | Floor_Space | Store_Hours | Store_Lease_Rate | Lease_Owner | Emergency_Contact | Emergency_Contact_Phone |
| Supplier_ID | Supplier Name | Address | City | State | Zip_Code | Phone_Number | Fax_Number | Local_Indicator |
| Store_Code | Tax_Jurisdiction | Tax_Rate |
| Store_Code | Order_ID | Tender_Type | Payment_Amount |