python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - erd

DBMS ERD Design

I am planning out an application's database. I have an employee table. I want to store every employee's education degree. Adding an education column to the employee table itself will cause redundancie...
test-img

Jenny Hillary D'cruz

php

sql

database

erd

Votes: 0

Answers: 1

Latest Answer

It probably makes sense to have a separate education table to keep track of degrees since, like you said, employees can have multiple degrees. Just add the employee id (or whatever the primary key is)...
test-img

Stefan Whittaker-Lee

Need to redesign this ER Diagram

I want to design them drawing an ER Diagram. I have already designed an ER Diagram but teacher told me that it has only 5 entities and I need at least 7 or 8 entities. Also told me that I must not add...
test-img

beytullahdanis

database

entity-relationship

diagram

erd

Votes: 0

Answers: 1

Latest Answer

I think the answer to your diagram questions is right there in your entity list. You have an entity named MOVIE_DIRECTOR but in the diagram you have a relationship named DIRECTS. You just need to ch...
test-img

Kurt

Are the tables in this ER diagram linked towards the employee table

The tables should be linked mainly towards the employee table. Is this fine? I need to make connection to employee using foreign keys. Is it good practice to have this many foreign keys? Are they pla...
test-img

Dragan Basa

mysql

database

erd

Votes: 0

Answers: 1

Latest Answer

it will be better to make the relation many-to-many between new_table and employee as you are doing: every employee has many new_table and every new_table has many employees SO (many-to-many) you can ...
test-img

K.D

Is it possible to export schema through Salesforce Schema builder?

I'm looking for an option to export ERD diagram from Salesforce Schema builder. Do we have any option/way to achieve it? Thanks in advance.
test-img

Rakesh

salesforce

schema

erd

Votes: 0

Answers: 2

Latest Answer

No, there's an idea to upvote, only 11 years old... https://ideas.salesforce.com/s/idea/a0B8W00000GdaatUAB/able-to-print-schema-from-schema-builder You might have some luck with https://salesforce.sta...
test-img

eyescream

Posts

Questions

Blogs

Jobs