Database - A collect of data in a formal structure, e.g. tables, but without any formally defined relationship between those tables., Relational database - Allows the user to specify information about multiple tables and the relationship between those tables, Table - A collection of records within a database, Record - A collection of fields from a database table relating to a single entity., Primary key - A field that uniquely identifies a record in a table, Foreign key - The linking field in the foreign table formed when a relationship is made., SQL - The language and syntax used to write and run database queries, SELECT - A key word in the SQL programming language used for the querying, ORDER BY - A key word in the SQL programming language used to sort the output from a SELECT query, FROM - An SQL key word used to signify which table(s) we are using., Join - A relationship between two tables, whereby a primary key one table links to a foreign key in another,

GCSE.U7.SQL-Definitions Flashcard

प्रिंट
एम्बेड

लीडरबोर्ड

फ्लैश कार्ड एक ओपन एंडेड टेम्पलेट है। यह लीडरबोर्ड के लिये स्कोर उत्पन्न नहीं करता है।

दृश्य शैली

विकल्प

टेम्पलेट स्विच करें

ऑटो-सेव पुनःस्थापित करें: ?