Hi i'm designing a database for a toy shop this shop offer many products with different categories. boystoys,girlstoys,puzzles,beds,stroller, etc i designed my database as it is consists of 5 tables (Customer,Order,order-details,product, product-category)
in the product category i added 2 columns one the primary key(ProductCategoryID) and the second for the (ProductCategoryName) i made it a unique so i can make relation between it and the product table.
My question : do you think that this design is True or not i'm still a beginner in designing a database and i want to know do you advice me to add another tables ?
note: i will not let the customer to pay here i just want from him to order his item and the shop will call him to confirm his order , the customer only will choose his products and then click Order and then a message come's to the shop owner with his details and order
i dont know why my client want to do this in his web site but im trying to develop it :D
Order
unless you really want to escape the name every time you reference it