Category "entity-relationship"

How to select multiple Columns in SQL with inner join

as you can see in my picture i have got an eer-model with 6 tables. Now I want from the table "catalog" the "ItemID", from "Users" the "UserID" and from "Roles

Are attributes mandatory in Chen's ERD diagram?

Is it mandatory to add the attribute symbols in an ERD diagram when using Chen's notation? I'm asking because in my current ERD there are already so many tables

Confused on the difference between One, and One and Only One in ERDs

Sorry for the links I'm new! I'm confused on the difference between one and one and only one and where they would be used. I just started the class so I apologi

How can I generate an entity–relationship (ER) diagram of a database using Microsoft SQL Server Management Studio?

I want to generate an ER diagram of an SQL database using Microsoft SQL Server Management Studio (SMSS). However, I don’t know how to. I found this techni

EF4 code-first: defining object relationships, foreign keys

< RANT_MODE > EF code-first approach is meant to save lots of time but for the time being I've only seen toy examples and spent hours trying to understand