Understanding basic database terminology
来源:互联网 发布:为什么会出现数据冗余 编辑:程序博客网 时间:2024/05/29 15:00
A database consists of tables and columns.
Database Design Terminology
Logical/RelationalLogical/Object-OrientedPhysical ImplementationEntityClassTableAttributeAttributeColumnInstanceObjectRowEntity: An entity maps something in the real world. For example, departments within an organization, employees, or sales.
Attribute: Represent information about an entity instance or an object. For example, the birth date or Social Security number of an employee.
Entities (classes) are implemented in the database as tables.
Attributes are implemented in the database as columns.
Instances (objects) are implemented in the database as rows.
A primary key uniquely identifies a specific instance of an entity.
No two instances of an entity can have the same primary key.
The values of all parts of the primary key must never be null.
The most common types of primary keys in relational databases are ID numbers.
Sometimes more than one attribute (or sets of attributes) can be used as a primary key.
- Understanding basic database terminology
- 《Understanding Linux networking 》1.1 Basic Terminology
- Basic Terminology
- Basic template terminology
- Understanding Basic Multithreading Concepts
- terminology
- Understanding basic of Report creation
- Understanding Bootstrap Of Oracle Database
- Understanding Bootstrap Of Oracle Database
- Database-basic knowledge(Oracle)
- Beginning Visual Basic Database Programming
- Beginning Visual Basic .NET Database Programming
- Mastering Visual Basic .NET Database Programming
- Oracle Database Compression 1 - Basic Compression
- Relational Database Management System(RDBMS) basic
- C++ Terminology
- Terminology Extraction
- Kernel Terminology
- Drawable资源
- 计算某个文件或文件夹的大小 文件夹内可能含有子文件夹
- 2011级同学加分通知(只针对河软高校俱乐部2011级同学)
- 类,对象和实例深入理解
- javascript 正则表达式
- Understanding basic database terminology
- 关于在线程中使用AfxGetMainWnd()出错的问题,终于找到了
- C++ 要点
- 更改linux默认启动的内核
- Hello Android - Android SDCard操作(文件读写,容量计算)
- 使用VS2005进行WEB功能测试
- 一个简单的图文混排控件
- VC UI 界面库
- CxImage