中文网站
  Advanced Search
Read the latest Blogs from IT professionals in the field. Read and write community created documents. Need IT help? Ask our staff. Connect with your peers. Check our Tech Shop for posters, books and software tools. Home

2.9.1 Database Systems: Representation of Strong Entity Sets

We use a table with one column for each attribute of the set. Each row in the table corresponds to one entity of the entity set. For the entity set account, see the table of gure 2.14.We can add, delete and modify rows (to reflect changes in the real world).

A row of a table will consist of an n-tuple where n is the number of attributes.
Actually, the table contains a subset of the set of all possible rows. We refer to the set of all possible rows as the cartesian product of the sets of all attribute values.

We may denote this as

D1 × D2 or ×2 i+1 Di

for the account table, where D1 and D2 denote the set of all account numbers and all account balances, respectively. In general, for a table of n columns, we may denote the cartesian product of D1,D2, . . .,Dn by

×n i+1 Di  

Database System Structure: