2/14/13 WD2 SA
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
---|---|---|---|---|---|
database | A collection of data that can be sorted and searched using search algorithms
🗑
|
||||
table | a collection of data about a limited topic organized into rows and columns in a database
🗑
|
||||
field | A category of information in a database table
🗑
|
||||
record | a collectin of info in a database table consisting of one or more related fields about a specific entity such as a person product or event
🗑
|
||||
relational database | a database that contains multiple tables related through common fields
🗑
|
||||
common field | a field contained in two or more database tables that forms a connection between the tables
🗑
|
||||
relationship | a connection between two or more database tables that is based on a field that the tables have in common
🗑
|
||||
primary key | a filed containing a value that uniquely identifies each record in a database table
🗑
|
||||
foreign key | a field in a related database table that refers to the primary key in primary table
🗑
|
||||
one-to-one relationship | in a databases a relationship in which each record in the table A can have only one matching record in Table B and vice versa
🗑
|
||||
one-to-many relationship | In databases a relation in which a record in Table A can have multiple matching record in Table B but a record in Table B has only one matching record in Table A
🗑
|
||||
many-to-many relationship | In databases a relationship in which one record in Table A can relate to many matching records in Table B and vice versa
🗑
|
||||
junction table | a database table containing foreign-key fields that refer to the primary key fields from the primary tables in many to many relationships
🗑
|
||||
query | A questin posed by a user to a database to request database info. the database retuns the query results based on criteria supplied by the user in the query
🗑
|
||||
Structured Query Language (SQL) | a language used to create and maintain pro high performance corporate database
🗑
|
||||
database management system (DBMS) | a program used to store access and manipulate database info
🗑
|
||||
Common Gateway Interface | a program that processes data submitted by the user. allows a web server to pass control to a software program based on user request the app receives and organace data then returns in a consistent format
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
ash.sa2
Popular Computers sets