Relational+Database+Terminology

Definition
====Relational Database is a collected information about items, which is orginized as a set of formally-described tables. This data can be accessed or reassembled in many different ways, without any reorginizing of tables.====

====In a specific table, there is data of one kind of objects (entities). In the example Car Rental database there are four tables: Customer, Rent, CarType and Car. In the Customer table there is the data of the customers, in the Rent table there is the data of the car rentals.====

====For example in the Car table the Model_id values refer to the Model_id of the CarType table. The car whose register number is 'ABC-111' is Ford Focus. The Cust_id in the Rent table refers to the Customer table Cust_id. The customer number 5 who has rented a car having register number CCE-326 is Patricia Smith.====

====For example the tables Car and CarType have a relationship. The foreign key (model_id) of the Car table refers to the CarType table primary key (model_id). The CarType table is the primary table and the Car table is the related table.====

====There is also a relation between the Car and Rent tables. The Reg_no of the Rent table (foreign key) refers to the Reg_no of the Car table (primary key). In this case the Car table is the primary table and the Rent table is the related table.====

media type="youtube" key="LwQoEr0PF44" height="348" width="567" Interesting and small "lecture" which explains all important features of relational databases(Contributor: Meruyert)

Another really useful and helpful video (really helpful and precise): media type="youtube" key="z5YnKt2aOCs" height="390" width="640" (Contributor: Meruyert)

Resources
Auer, L. (n.d.). // Concepts of relational database //. Retrieved from http://www2.amk.fi/digma.fi/www.amk.fi/opintojaksot/0303011/1146161367915/1146161783414/1146163033699/1146163141034.html Leffler, J. (2010, October 29). // What is a relation in database terminology? // . Retrieved from http://stackoverflow.com/questions/4045744/what-is-a-relation-in-database-terminology Rouse, M. (n.d.). // relational database //. Retrieved from http://searchsqlserver.techtarget.com/definition/relational-database Lynda.com (2010, 30september) //How relational databases work | lynda.com overview.// Retrieved from https://www.youtube.com/watch?v=z5YnKt2aOCs (Meruyert)