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