locked
Is my database diagram relational? RRS feed

  • Question

  • Hello! I am adding the image of my made database diagram. So the general question is my database diagram relational? Do i need something extra and so on.. Thanks!
    Tuesday, April 19, 2016 10:41 AM

Answers

  • Hello,

    You using property values to create entities. That is not correct.

    If you want to have kind of dynamic attributes for customers for example, that is a many-to-many relationship between customers and attributes, and you need to create an associative entity between them, that will have as attributes the primary key of customers and the primary key of attributes, and these 2 attributes may be the composite primary key of that associative entity.


    This eliminates the need to create entities for attraction, place atmosphere, property price on holiday, and all those entities related with attributes.



    Hope this helps.



    Regards,



    Alberto Morillo
    SQLCoffee.com


    Tuesday, April 19, 2016 12:40 PM
    Answerer