Ordonner les Mots Relational DatabaseVersion en ligne Key vocabulary for relational database par Monica Nash 1 How do relational databases store data ? database related data multiple tables Relational on store 2 What are tables in a spreadsheet? are and tables spreadsheet applications horizontal columns vertical In rows 3 What terms are used for database tables? fields records and have tables Database 4 Why are rows called records in a database? together Rows information row belongs because the all are called records a on 5 Why are columns called fields in a database? Columns because has same each are called of field kind fields the information . . 6 What is the purpose of the primary key field? unique The is field the give record primary each a purpose identifier to of 7 Why would you use an employee ID# as a primary key rather than the employee name? name unique two same Employee may have is though , Even employees each ID the . , . 8 What is a foreign key? another looks database the in relational A primary key field of in that table field table the a similar to 9 How does a relational database create relationships? number number in foreign to a having By the the correspond field key primary a in key field 10 What is an example of a one-to-many relationship in the relational database pictured? phone have phone each can Even to numbers person only one , many belong each though can person number . , .
Créer jeu