ERD is the graphical representation of database scheme. ERD contains tables in the database, the columns within those tables and relationships between the tables.
Yana Osokinaalıntı yaptı3 yıl önce
SQL is a scripting language which means that SQL code is not required to be compiled before execution
Yana Osokinaalıntı yaptı3 yıl önce
Front end or commonly referred to as user interface and backend which consists of code that interact with the database.
Yana Osokinaalıntı yaptı3 yıl önce
Foreign Key
Foreign keys are used to create relationship between two tables. Foreign key column contains values from the primary key column of some other table.
Yana Osokinaalıntı yaptı3 yıl önce
Primary Key
Primary key is used to uniquely identify records within a table.
Yana Osokinaalıntı yaptı3 yıl önce
When an application is being executed, it stores data in RAM (Random Access Memory)