In relational database, you can compare information because of the
way data is place  in columns. The relational database model uses
uniformity to build  new tables out of noted information from
existing tables. It uses the relationship of similar data to increase the
speed and versatility of the database.

By storing this information in another table, the database can create a
single small table with the locations that can then be used for a variety
of purposes by other tables in the database.

structured query language (SQL) is used to create DataBases.


Breaking stuff down a bit for my undestanding

Relational Database

 A database will contain one or more Tables. Tables contain Rows and columns.
 These alo have names Rows being "record" and columns being "fields".
 A Flat base is a table that is single in number. A Database with more than one
 table is called Relational Database.

 It is said to be easier to put your information into more than one table.

 Keep information in one Table will cause you to have to re-enter information.


 First Table

ID          Name      Location     Age
 1.         Ada        USA          16
 2.         Oxy       Russia        25
 3.         Zayn       Iran          21

 Say we wanted to add something that might Change like Phone Number and
 Relationship data. We would make another table

 Second Table

 ID          Phone#            Relationship Status
  1.       555-1234              Single
  2.       555-4321              Married
  3.       555-5555              Widowed

 What this is called is normalizing the Data. Goal, having a place for everything.
 Normalization is organizing data in a database. Creating tables and establishing
 relationships between those tables



 Repeat only the ID when you want to change something or relate something
 in the table Example : 1. Ada USA 16 555-1234 Single Would all be accosicated
 with ID 1.

 In this the ID is the Primary Key. Ada can only have one Primary Key which
 is 1. Oxy's Primary Key is 2,..and so on.

 Make sure ou name fields correctly, have fields named the same same can lead
 to a lot of issues.

 When two table have unequal relationshops,..you would have a Parent Table
 and a child Table. This wud be a Table that has maybe something unpopular information
 That never gets used. Like "Widow" for example (This would be going into adding
	more and more Tables, such as Hieght, weight, fave books. Those wouldalso be Child Tables

 CARDINALITY - the number of elements in a set or other grouping, as a property of that grouping.
 This is like, how many records you keep in one table that can be related to
 to another table.


 This could be explained by Making a Table about all the movies 1,2, and 3 have ben
 watched in the last week. Maybe all 3 of them watch all the same movie that
 week, and only one watched a certain movie.

 DataModle is basically making more and more tables to seperate.
 Data models define how data is connected to each other and how
 they are processed and stored inside the system.
 Data models define how data is connected to each other and how
 they are processed and stored inside the system.

 Basically Say for example 20 people live in one house, Instead
of having 20 rows of Data, you can limit clutter. Its easier to have table
 of all people living at the one address.

Relationship -  entities is called relationship.
Relationships are mapped with entities in various ways. Mapping cardinalities
define the number of association between two entities.


  Entity - An entity in an ER Model is a real-world entity having properties called
 attributes. Every attribute is defined by its set of values called domain.
 Basically,... in a Galaxy database, a User is considered as an entity.
 User has various attributes like name, age, Skills, Fave movie.