\begin{frame}
\frametitle{Attributes}
An \emph{entity set is represented by a set of attributes},
that is, properties possessed by all entities of the entity set.
\begin{exampleblock}{}
\sql{Customer = (id, name, street, city)}\\
\sql{Loan = (loan-number, amount)}
\end{exampleblock}
%
% The \emph{domain} is the set of permitted values for each attribute.
\pause\medskip
\begin{goal}{Attribute types}
\begin{itemize}
\item \emph{simple} and \emph{composite} attributes
\begin{itemize}
\item e.g. street is composed of street name and number
\end{itemize}
\item \emph{single-valued} and \emph{multi-valued} attributes
\begin{itemize}
\item e.g. single-valued: age of a person
\item e.g. multi-valued: person can have multiple phone numbers
\end{itemize}
\item \emph{derived attributes}
\begin{itemize}
\item can be computed from other attributes
\item e.g. age can be computed given the date of birth
\end{itemize}
\end{itemize}
\end{goal}
\end{frame}