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