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