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 Osokinafez uma citaçãohá 3 anos
SQL is a scripting language which means that SQL code is not required to be compiled before execution
Yana Osokinafez uma citaçãohá 3 anos
Front end or commonly referred to as user interface and backend which consists of code that interact with the database.
Yana Osokinafez uma citaçãohá 3 anos
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 Osokinafez uma citaçãohá 3 anos
Primary Key
Primary key is used to uniquely identify records within a table.
Yana Osokinafez uma citaçãohá 3 anos
When an application is being executed, it stores data in RAM (Random Access Memory)