Tag: erd

Entity Relationship Diagram: What is a composite ID .Net Core 6

I have 3 tables in the database and I wanted to know what a composite primary key is. E.g: Table 1 is called superheroes Table 2 is called categories of superheroes and table 3 is called biography of superheroes I want to create an ERD (Entity Relations Diagram) The attribute key is supposed to retrieve the json file and display

How to assign the IDs to the referring table and how to display this correctly? (SSMS)

audit erd sql sql-server ssms

I am in the process of creating an audit plan using ERD, going off the below image you can see that there’s a permissions table with four FK columns referring to the other four tables PK column. I am just confused as to how the IDs will relate to the other tables and how will it show up correctly in

how to setup this diagram? (multiple selling methods)

diagram entity-relationship erd sql

I’m supposed to create a sort of second brand website. When someone wants to sell a product, he has the option to sell it for: a set amount free to bid can anyone give me an assist on how to continue? This is what i have so far, but i’m stuck and don’t know how to continue. (sorry for the

Pairing table query

erd join many-to-many mysql sql

I was wondering how I construct a query to get all articles with all their information, and for every article a list with their tags. I used a pairing table called ArticleTags to connect Article and Tags. Can anyone tell me what the query would be if I wanted to receive all articles along with their tags per article. My

Tag: erd

Entity Relationship Diagram: What is a composite ID .Net Core 6

How to assign the IDs to the referring table and how to display this correctly? (SSMS)

how to setup this diagram? (multiple selling methods)

Pairing table query

Export ER diagrams from SSMS

Search for and reverse engineer foreign key relationships in DB without foreign keys defined

Should there be a foreign key “to” an associative entity, or “from” the associative entity?