初学者需要掌握的数据库设计词汇对照表（Beginners need to master the database design vocabulary comparison table）.docVIP

初学者需要掌握的数据库设计词汇对照表（Beginners need to master the database design vocabulary comparison table） Database basics: A reference table for beginners to master database design 1. Access method (Access Methods): This step includes storing and retrieving records from a file. 2. Alias: Another name for a property. In SQL, you can replace the table name with an alias. 3. Alternate keys (alternate key, er/relationship model): There is no candidate key selected for the main health in the Entity/table. 4. Anomalies (exception) See Update exception (update anomalies) 5. Application design (application design): A phase of the database application lifecycle, which includes designing the user interface and the application that uses and processes the database. 6. Attribute (attribute) (relational model): A property is a named column in a relationship. 7. Attribute (attribute) (ER model): a property in an entity or relationship. 8. Attribute inheritance (property inheritance): A subclass member can have its own properties and inherit the process of those attributes that are related to the superclass. 9. Base table: A named table whose records are physically stored in the database. Binary relationship (two-yuan relationship): An ER term used to describe the relationship between two entities. For example, Panch has staff. Bottom-up approach (bottom-up approach): For database design, a design methodology, he starts with identifying each design build, and then aggregates the components into a large unit. In database design, you can start the underlying design from the presentation properties, and then combine them together to form the tables that represent the entities and relationships. Business rules (Business Rules): An additional rule specified by a user or a manager of a database. Candidate key (candidate key, er relationship model): Contains only the keys that uniquely identify the minimum number of attributes/columns that an entity must have. Cardinality (cardinality): Describes the