Drawing database tables in tikz

I am bit confused about how can i draw a table like this using tikz. Any ideas please?

• Welcome to TeX.SX. Questions about how to draw specific graphics that just post an image of the desired result are really not reasonable questions to ask on the site. Please post a minimal compilable document showing what you've tried to produce the image and then people will be happy to help you with any specific problems you may have. See minimal working example (MWE) for what needs to go into such a document. – Benedikt Bauer Sep 24 '13 at 9:22
• This question appears to be off-topic because it is a typical "how do I draw this graphic" question. Although asked to elaborate more and/or show his own attempts there was nor reaction within three days. – Benedikt Bauer Sep 27 '13 at 20:05
• @BenediktBauer and to any other close voters: I sort of agree, but if this one is closed, then over half of the tikz questions should also go – cmhughes Sep 27 '13 at 20:50

• my positioning-plus library,
• my node-families library (note that the key Text Width is not perfect and needs to be removed for one compilation pass if one of the nodes of the node family changes),
• my paths-ortho library (DL 1, DL 2),
• the matrix library,
• a redefinition of the anchor key from another answer of mine,
• a redefinition of the left delimiter key from the matrix library
(left delimiter=\{ will still work), and
• a few keys/styles.

Code

\documentclass[tikz]{standalone}
\usetikzlibrary{matrix,node-families,positioning-plus,paths.ortho}
\colorlet{myRed}{red!20}
\tikzset{
rows/.style 2 args={/utils/temp/.style={row ##1/.append style={nodes={#2}}},
/utils/temp/.list={#1}},
columns/.style 2 args={/utils/temp/.style={column ##1/.append style={nodes={#2}}},
/utils/temp/.list={#1}}}
\makeatletter
\tikzset{anchor/.append code=\let\tikz@auto@anchor\relax,
\expandafter\def\expandafter\tikz@textfont\expandafter{\tikz@textfont#1},
left delimiter/.style 2 args={append after command={\tikz@delimiter{south east}
{south west}{every delimiter,every left delimiter,#2}{south}{north}{#1}{.}{\pgf@y}}}}
\makeatother
\begin{document}
\begin{tikzpicture}[
>=latex, node distance=2cm,
my matrix/.style={
draw, matrix of nodes,
left delimiter=\{{label={[anchor=south,rotate=90]left:Relation}},
nodes={
Text Width/.expanded=\tikzmatrixname-\the\pgfmatrixcurrentcolumn,
inner xsep=+.5\tabcolsep, inner ysep=+0pt, align=left},
inner sep=.5\pgflinewidth,
font=\strut\ttfamily,
rows={1}{fill=myRed}}
]
\matrix[my matrix] (m1) {
branchNo & street        & city     & postcode \\
B005     &  22 Deer   Rd & London   & SW1 4EH \\
B007     &  16 Argyll St & Aberdeen & AB2 3SU \\
B003     & 163 Main   St & Glasgow  & G11 9QZ \\
B004     &  32 Manse  Rd & Bristol  & BS99 1NZ \\
B002     &  56 Clover Dr & Lond     & NW10 6EU \\
};
\matrix[
my matrix,
west below=of m1,
columns={6,...,8}{align=right},
columns={5}{align=center}
] (m2) {
staffNo & fName & IName & position   & sex & DOB       & salary & branchNo \\
SL21    & John  & White & Manager    & M   & 1-Oct-45  & 30000  & B005     \\
SG37    & Ann   & Beech & Assistant  & F   & 10-Nov-60 & 12000  & B003     \\
SG14    & David & Ford  & Supervisor & M   & 24-Mar-58 & 18000  & B003     \\
SA9     & Mary  & Howe  & Assistant  & F   & 19-Feb-70 &  9000  & B007     \\
SG5     & Susan & Brand & Manager    & F   & 3-Jun-40  & 24000  & B003     \\
SL41    & Julie & Lee   & Assistant  & F   & 13-Jun-65 &  9000  & B005     \\
};

\path[->] node[above=+1cm of m1] (attrib) {Attributes}
\foreach \col in {1,...,4} {edge (m1-1-\col)};
\path[node distance=.25em, font=\bfseries] node[west above=of m1] {Branch}
node[west above=of m2] {Staff};

\path[<->] (m1-6-1) edge[|-|=.65, above] node[pos=.3333] {Primary key}
node[pos=.6667] {Foreign key} (m2-1-8)
([yshift=-.25cm] m1.south west)    edge node[below]           {Degree}
([yshift=-.25cm] m1.south east)
([xshift=.25cm] m1-1-4.south east) edge node[rotate=90,below] {Cardinality}
([xshift=.25cm]  m1.south east);
\end{tikzpicture}
\end{document}