Supermarket+Relational+Database+for+Loyalty+Cards

Definition
====A relational database is a collection of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables. ====

Description
====These databases are used in different areas, especially in supermarkets for the loyalty cards, because it is easy to look for customers by using the relational database. Also, these databases can access different information, because it has relation between databases, which makes it easy to look for one information by having another information, which are related. ==== 

media type="youtube" key="hv4eEifsE08" width="420" height="315"
= CASE STUDY: Tesco = This video shows that Tesco's customers use the loyalty cards which means that Tesco have some information about each of its customers. For storing this information Tesco uses relational database for loyalty cards which makes it easy to store the information.

[[image:Loyalty card.png width="800" height="691" caption="Relational Database of a Loyalty card"]]
This is a great Example for Relational Database of Loyalty Card. The database consists of necessary datas for Card
 * 1) Time & date of giving following cards
 * 2) Type of Cards
 * 3) Rate
 * 4) E-mail of the consumer
 * 5) Last name
 * 6) First name
 * 7) Gender

Resources

 * Rouse, M. (n.d.). Relational database. Retrieved December 10, 2014, from http://searchsqlserver.techtarget.com/definition/relational-database
 * MySQL Sample Databases. (n.d.). Retrieved December 10, 2014, from http://www.ntu.edu.sg/home/ehchua/programming/sql/SampleDatabases.html
 * CASE STUDY: Tesco. (2011, October 10). Retrieved December 11, 2014, from https://www.youtube.com/watch?v=hv4eEifsE08