1. A flat file database stores data in a ______ table structure. A relational database uses _______ table structures, cross-referencing records between tables
2. The relational database model was developed and implemented in the early 1970's, primarily by ____
3. Flat file databases were a natural development early in computing history.
4. The primary feature of a relational database is its_________, which is a unique identifier assigned to every record in a table
5. An example of a good primary key is a registration number. It makes every record ______, facilitating the storage of data in multiple tables, and every table in a relational database must have a primary key field.
6. Another key feature of relational databases is their ability to hold data over ______ tables.
7. The primary key can ________ in a one-to-one relationship, one-to-many relationship or many-to-many relationship
8. Relational databases enable users to delete, update, read and create data entries in the database tables. This is accomplished though structured query language, or _____________
9. In addition to the data tables, relational databases use _______ to quickly find records based on search criteria
10. Relational databases generally require a relational database management system (RDBMS) to ______________________
11. Flat file databases are simple and portable, and typically can be used without requiring special software
12. Relational databases are faster, more efficient and more powerful than flat files. Most RDBMSs provide database access over networks.
13. What is a disadvantage or potential difficulty that will arise for Company A as orders are placed?
14. What are some of the disadvantages of duplication (that may arise in a flat file database)?
15. Repeating data unnecessarily causing the creation of a database in which several rows have the same (repeating) data is called: