How to make good E-R diagram?

Question

I have found the following E-R diagram in page 18 of Database System Concept book.

You will find more E-R diagram in that book. How can I draw similar design and colored E-R diagram?
If you want MWE you can see marmot's solution because I don't know how to do this before he answered.

[You can recommend better color combination]

Answer 1

All these diagrams are basic, and @Zarko already kindly told you the keywords you might want to look up if you are not already familiar with them. Even though the larger diagram can be straightforwardly be drawn, I am not in the mood to type in the text of your screen shot. So here comes a realization of the upper picture.

\documentclass[tikz,border=5pt]{standalone}
\usetikzlibrary{positioning,shapes.multipart,shapes}
\begin{document}
\tikzset{basic/.style={
        draw,
        rectangle split,
        rectangle split parts=2,
        rectangle split part fill={blue!20,white},
        minimum width=2.5cm,
        text width=2cm,
        align=left,
        font=\itshape
    },
    Diamond/.style={ diamond, 
                        draw, 
                        shape aspect=2, 
                        inner sep = 2pt,
                        text centered,
                        fill=blue!10!white,
                        font=\itshape
                      }}
\begin{tikzpicture}
\node[basic] (instructor) {instructor
\nodepart{second}
\underline{ID}\\
name\\
salary};
\node[basic,right=5cm of instructor] (department) {department
\nodepart{second}
\underline{dept\_name}\\
building\\
budget};
\draw (instructor) -- (department) node[midway,Diamond]{member};
\end{tikzpicture}
\end{document}