Database Kullanımı

[ucrayca]

• [x] MySql kullanımı
• [x] Yeni database oluşturma
• [x] Oluşturulan database içerisinde tablo oluşturma
• [x] Tabloya .csv uzantılı dosyaları import etme
• [x] Key atamalarını yapma
• [x] Tablolar arası foreign key ilişkisi
• [x] ER diagramı oluşturulması

[ucrayca]

Candidate Key :

• The minimal set of fields which can uniquely identify each record in a table.
• There can be more than one

Primary Key :

• A candidate key that is most appropriate to become the main key for any table.
• Uniquely identify each record in a table.

Foreign Key :

• Column which is added to create a relationship with another table.There are two different entities.
• The same attribute types
• Foreign keys are the columns of a table that points to the primary key of another table. They act as a cross-reference between tables.

ER Diagram :

• Entity–relationship model
• Shows the relationship among entity sets
• ER diagram shows the complete logical structure of a database