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