You get a bonus - 1 coin for daily activity. Now you have 1 coin

Sets, domains and attributes.

Lecture



Sets - a collection of properly identified objects that satisfy the conditions of ownership (domains).

This condition can be expressed both verbally and with the help of functional dependencies.
For example: integers from 0 to 100.
The set itself may be an element of other sets.
The database uses ordered sets .
In addition to ordered sets, there are extended sets .
The main formal object of extended sets is a complex .
The complex determines the basic relation of the i-th accessory.
For example: if X is the i-th element of the set Y, then X is in the i-th position of this set and is written in the set using the upper index (a1, b2, a3).
The set (a1, b2, a3) allows the use of duplicates, i.e. place identical values ​​in the set.
There are sets for which one and the same nature can be defined, such sets are called domains .
For example, the domain of integers can define a set of attributes: phone number, salary, student ID number, etc.
The main objective of this stage of conceptual design is the definition and coordination of all domains for database attributes.
Relationships, Entities, and Connections
Consider a series of sets, each of which defines a certain type of object.
For example: surname - {Ivanov, Petrov, Sidorov}
course - {2, 4, 3}
average ball {3.5, 4.5, 5}
Sets can be interpreted using domains, roles, and attributes.
{Ivanov, Petrov, Sidorov}
Personality - {2, 4, 3}
{3.5, 4.5, 5}
Aggregation of sets allows formulating more complex types.
A relation is an aggregate built on sets, that is, these are connections between sets that show the mutual influence of the elements of one set on another.
Attitudes can be given a different semantic meaning, that is, to relate each tuple of a relationship to a specific entity. In tables, a tuple is a record, and an entity is a table name.
Entity is a data element belonging to objective reality.
For example: employee, bargain, house.
As a rule, an entity is a noun, and an entity type can be defined as an aggregation of attributes.
An entity type may correspond to a generalization of one or more entity types.
For example:


Student:

Full name

Course

Average mark

Address

Seller:


Full name

Store number

...

Sets, domains and attributes.

Between individual types of entities, in addition to generalization, you can use a different interpretation, namely communication .

Let there be two entities: men and women, you can make a connection, which we call “married”, and this connection is called the type

See also

    created: 2014-12-18
    updated: 2024-11-10
    132426



    Rating 9 of 10. count vote: 2
    Are you satisfied?:



    Comments


    To leave a comment
    If you have any suggestion, idea, thanks or comment, feel free to write. We really value feedback and are glad to hear your opinion.
    To reply

    Databases - Data models

    Terms: Databases - Data models