New answers tagged

0

The only sure answer I can give to you is that you should be using a TEXT or BLOB datatype and not a varchar. Varchar leaves you with a chance that there wont be enough room for your data and your data can contain any type of information you require. Also (not really a problem) I would think you might be able to remove the recursive relationship in your ...


0

It looks to me as though child_1 and child_2 are two instances of a single entity type. If so, then you have a (second) relationship such that Every parent must have one and only one favourite child Every child may be the favourite of zero or more parents. The (first) relationship being A parent may have zero or more children (unless, of course ...


0

Your relationships are correct, however, they would allow for a customer to have records of products they've never bought. Is this something you want? Otherwise, you'd be better off establishing the relation between Review and OrderDetails (the intermediate table for Order-Product which in your ERD doesn't have a name), rather than to Product directly. That ...



Top 50 recent answers are included