<html> <head> <title>Data Model for Frozen Yoghurt Shops</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link rel="stylesheet" href="../../styles/style.css"> </head> <body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <TABLE NAME="CHANGE MY WIDTH" WIDTH="100%" border=0 cellspacing=0 cellpadding=0><TR><TD> <!-- CHANGING THE WIDTH ABOVE WILL CHANGE ALL PAGE WIDTH --> <table NAME="HEADER" width="100%" border=0 cellspacing="0" cellpadding="0" bgcolor="#FFFFFF"> <tr> <td height="100" valign="middle"><img src="../../images/dba_400_home.jpg" width="400" height="58" alt="Database Answers"></td> <td ALIGN=right HEIGHT=95 ROWSPAN=2 width="100%" valign=middle> <A HREF="http://www.studioem.net/2011/10/choose-your-topping-5-cool-frozen-yoghurt-store-designs/" TARGET=_NEW> <IMG ALIGN=right ALT="Olo Yogurt Studio, Albuquerque (Click for Web Site)" BORDER=0 hspace="0" vspace="4" SRC="images/Olo_Yogurt_Studio_Albuquerque_sml.jpg"></A> </td> </tr> <TR> <td width="100%" align="LEFT"> <!--- <p class="time"><nobr><SCRIPT LANGUAGE="JavaScript">theDate();</SCRIPT> ---> <IMG ALT="Printer" SRC="../../images/printer_icon.gif"> <A HREF="print_version.htm"><FONT COLOR=blue FACE=Verdana SIZE=1>Printer-friendly version</FONT></A> <nobr></p> </td> </TR> </table> <!--- START OF DEC 5th. Menu Bar ---> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="32" background="../../images/nav_bg.jpg" align="left" valign="middle"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="1%"><img src="../../images/spacer.gif" width="15" height="15"></td> <td width="6%"><A STYLE="text-decoration:none" HREF="../../index.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Home</font></A></td> <td width="11%"><A STYLE="text-decoration:none" HREF="../../pi_ask_a_question/index.asp"><font color="#FFFFFF" FACE=Verdana SIZE=2> Ask a Question</font></A></td> <td width="10%"> <A STYLE="text-decoration:none" HREF="../../pi_best_practice_display/index.asp"><font color="#FFFFFF" FACE=Verdana SIZE=2>Best Practice</font></A></td> <td width="9%"> <!--- <A STYLE="text-decoration:none" HREF="../../pi_communities/boards.asp"><font color="#FFFFFF" FACE=Verdana SIZE=2>Communities</font></A> ---> <A STYLE="text-decoration:none" HREF="../../careers.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Careers</font></A> </td> <td width="9%"><A STYLE="text-decoration:none" HREF="../../contact_us.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Contact Us</font></A> </td> <td width="10%"><A STYLE="text-decoration:none" HREF="../../data_models/index.htm"><font color=yellow FACE=Verdana SIZE=2>Data Models</font></A></td> <td width="7%"><A STYLE="text-decoration:none" HREF="../../search.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Search</font></td> <td WIDTH=20% WIiiiDTH=10% wiIIIdth="30%"><A STYLE="text-decoration:none" HREF="../../site_map.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Site Map</font></A></td> </tr> </table> </td> </tr> </table> <!--- END OF DEC 5th. Menu Bar ---> <!--- START OF PAGE NAME ---> <FONT COLOR=blue FACE="Verdana" SIZE=2> <TABLE bgcolor="#B0D8FF" BGCOLOuuuR="#98CEFD" BORDER=0 CELLPADDING=5 CELLSPACING=5 WIDTH=100%> <tr> <td height="32" background="../../images/nav_bg.jUg" align="left" valign=top> <table width="10%" border="0" cellspacing="0" cellpadding="0"> <tr> <td background="../../images/nav_bg.jpg" valign=top width="1%"><img src="../../images/spacer.gif" width="15" height="15"></td> <td ALIGN=left background="../../images/nav_bg.jpg" height="32" width="7%"><PRE><FONT COLOR=yellow FACE=Verdana SIZE=2>Data Model for Frozen Yoghurt Shops&nbsp;&nbsp;&nbsp;</font></td> </tr> </table> </td> </tr> </TABLE> <!--- END OF PAGE NAME ---> <table NAME="MAIN CONTENT" width="100%" border=0 cellspacing="0" cellpadding="0"> <tr> <td width="100%" bgcolor="#B0D8FF" valign="top"> <table width="90%" border=0 cellspacing="0" cellpadding="0"> <tr> <td width="21"><img src="../../images/spacer.gif" width="31" height="1"></td> <td width="100%"> <FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF='mailto:dba_requests&#64;barryw.org?subject=Request for the Database for Frozen Yoghurt Shops'>An Access Database</A> is available on demand. <BR><BR>If you have any comments or suggestions <A HREF='mailto:dba_requests&#64;barryw.org?subject=Comments on the Data Model for Frozen Yoghurt Shops'> we would be glad to hear them</A>. <BR><BR>If you are new to Data Models, this page of my new Tutorial will help you <A HREF="../../tutorial4_db_schema/tutorial_slide_5.htm"><B>understand the Data Model</B></A>. <BR><BR>There is also a design for a <A HREF="data_mart.htm"><B>Sales Data Mart</B></A>, which is very useful for providng data for Reports and Business Intelligence. <BR><BR><A HREF="facts.htm">The Specifications</A> have been defined in a question to the Database Answers Web Site. <BR><BR><IMG ALIGN=left ALT="Data Model for Frozen Yoghurt Shops" BORDER=0 SRC="images/data_model.gif"> <!--- Subject Area Models have been created for each Area in this top-level Data Model:- <LI><A HREF="citizens_subject_area.htm">Citizens</A> <LI><A HREF="publications_subject_area.htm">Publications</A> <LI><A HREF="registered_users_subject_area.htm">Registered Users</A> <LI><A HREF="services_subject_area.htm">Services</A> <LI><A HREF="staff_subject_area.htm">Staff</A> <LI><A HREF="subscribers_subject_area.htm">Subscribers</A> <LI><A HREF="web_site_subject_area.htm">Web Site</A> <BR><BR><LI>And here is a <A HREF="kick_start_data_architecture.htm"><B>Kick Start Data Architecture</B></A> ---> <BR> <BR>Barry Williams <BR>Principal Consultant <BR>Database Answers Ltd. <BR>London, England <BR>July 1st. 2012 <BR> </td> </tr> </table> <CENTER><FONT COLOr=blue FACE=Verdana SIZE=1> <BR><BR><I> &#169 DataBase Answers Ltd. 2012</I></FONT> </CENTER> </TD> </TR> </TABLE> <!--- START OF MAY 21ST. BOTTOM MENU BAR ---> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="32" background="../../images/nav_bg.jpg" align="left" valign="middle"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="80%"><img src="../../images/spacer.gif" width="80" height="15"></td> <td align=LEFT WIDTH=10%><A STYLE="text-decoration:none" HREF="../../about_us.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>About Us</font></A> </td> <td align=LEFT WIDTH=15%><A STYLE="text-decoration:none" HREF="../../contact_us.htm"><font color="#FFFFFF" FACE=Verdana SIZE=2>Contact Us</font></A> </td> </tr> </table> </td> </tr> </table> <!--- END OF MAY 21st. BOTTOM MENU BAR ---> <!-- HERE BASE TABLE CLOSES, INSIDE WHICH ALL PAGE IS PLACED, AND WHICH WIDTH IS 90 PERCENTS --> </td> </tr> </table> </body> </html>