\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}