A business-to-consumer company (B2C), a kitchenware retailer, wants to set up an e-commerce site, but first wants to produce a prototype in Microsoft Access. The data analysis has been performed and is shown in the expanded entity relationship diagram in Figure 11.22. Produce this database in Access based on the ERD. Include 4 or 5 sample records for each table.

Table 11.7 Table from a relational database Product code Product description Product group Group description Cost Retail price Rack location Quantity 0942 Small Green KD Kiddy Doh 0.19 1.29 A201 16 0439 Large Red KD Kiddy Doh 0.31 1.89 W106 35 0942 Small Green KD Kiddy Doh 0.19 1.29 E102 0 0902 Small Green KD Kiddy Doh 0.19 1.29 J320 56 1193 Spinning Top PS Pre-School 1.23 12.49 X215 3 2199 Burger Kit KD Kiddy Doh 3.25 17.75 D111 0 Figure 11.22 The expanded ERD for a kitchenware retailer Customer • Customer id *
• Title • First name • Last name • Address line 1 • Address line 2 • City • Post / Zip code • County • Password • User id • E-mail • Registration date Primary key Secondary key one-to-many relationship Key *
+
1 M Order hdr • Order id *
• Order date • Dispatch date • Total amount • Shipping cost • Order credit card number • Customer id +
places contains contains Order line • Line id *
• Order id +
• Quantity • Price • Product id +
Product • Product id *
• Short description • Long description • Picture • Size • Category • Manufacturer id +
• Standard price • Number in stock • Reorder level • Next available date