Beginning Database Design- P23:This book focuses on the relational database model from a beginning perspective. The title is, therefore, Beginning Database Design. A database is a repository for data. In other words, you can store lots of information in a database. A relational database is a special type of database using structures called tables. Tables are linked together using what are called relationships. You can build tables with relationships between those tables, not only to organize your data, but also to allow later retrieval of information from the database | Glossary Materialized view A physically preconstructed view of data containing data copied into the materialized view. Materialized views can be highly efficient in read-only environments and are often used for replication distribution and in data warehouses. Metadata The tables and the fields defining the structure of the data the data about the data. Method The equivalent to a relational database stored procedure except that it executes on the data contents of an object within the bounds of that object. Microsoft Windows The Microsoft Windows operating system. Multi-valued dependency A field containing a comma-delimited list or collection of some kind. A collection could be an array of values of the same type. Those multiple values are dependent as a whole on the primary key the whole meaning the entire collection in the comma-delimited list. Each individual value is not dependent on the primary key. Nested query A query executed from within another query. In theory queries can be nested up to any number of hierarchical layers. The only limitation is on complexity and the abilities of the programmer. Network A system of connected computers. A local area network LAN is contained within a single company in a single office. A wide area network WAN is generally distributed across a geographical area even globally. The Internet is a very loosely connected network meaning that it is usable by anyone and everyone. Network database model Essentially a refinement of the hierarchical database model. The network model allows child tables to have more than one parent thus creating a networked-like table structure. Multiple parent tables for each child allow for many-to-many relationships in addition to one-to-many relationships. Non trivial multi-valued dependency A multi-valued dependency with more than two fields in the table. See Multi valued dependency. Non-identifying relationship The child table is not dependent on the parent table such that the child table includes .
