TerminologiesDataNames&DefinitionClassificationofAttributes

• Database: A database can be one, stand-alone table that can contain many fields of information. This is the simplest, yet least powerful type of database and is often referred to as a 'flat' database
• Relational Databases: Many tables that are linked through common fields and can ensure greater accuracy and less input of data. Relational databases increase flexibility of data and allow ease of collecting and maintaining historical data
• Relationships: Relational databases are databases in which common fields of information join tables. The relationships are one-to-one and one-to-many relationships. A one-to-one relationship ensures that one record in one table has a (and only one) matching record in another table. One-to-many relationships allow one record in one table and many records in another table
• Table (Entity Type) - contains or holds the data. It can limit the types of data in fields and can assist in integrity and accuracy of data. Generally, tables do not perform calculations and are simply data collectors for input or other means of acquiring data.
• Record - is a collection of fields for an item you are tracking. In addition, a record is a single row which consists of multiple fields
• Attribute (Fields) - are the different characteristics (attributes) within a table. Tables usually contain multiple fields. A field is the lowest level of data in a database. Fields consist of information about the item you are tracking / It is a defined property of an entity. In the school example of an attribute of student (which is an entity) might be name or student ID. Attributes are the same thing as fields in a flat file database. It is (often corresponds to a field in a table).
• Data Names and Definitions - Data objects must be named and defined before they can be used unmistakably in a model of organizational data