Database definition

2. A field in a table that depends on part of the primary key is known as having ____________ dependency
3. Two possible relationships between tables are one to one and one to _______
6. The process of ordering information in alphabetical order
7. A PK made up of two fields is known as a __________ Key.
8. Database __________________ System
10. Creates a link between two tables
14. Can have varying degrees
16. The database we are studying is known as a _________ database.
17. Obtaining information from an external source or another database.
18. Usually used as the data type of PKs; it increments automatically
21. Not changing the size of a field can waste a lot of __________
22. Another name for Column heading
23. Represented by a rectangle in an ERD

1. Collection of related information
4. _________ View: Used to fill in the fields in a table
5. The process of removing repetition and data redundancy from the database
9. Three letters used as a prefix before the name of a table
11. Integrity Ensuring that the information is correct and that all values in a Foreign Key match those in a Primary Key is known as __________ __________
12. Another way to input information into a table
13. Number of Normal Forms
15. Every table should have one to identify each record
19. Also known as Tuple, contains all the information regarding
20. A way to obtain information from a database