Types of attributes (160210107054)

types of attributes

1. Types Of Attributes Prepared by :- Ajay Umath (160210107054) Computer Eng. (GEC Bhavnagar)

2. Attributes An entity is represented by a set of attributes, that is descriptive. Graphical representation of attribute is ellipse. Example :- Customer = ( Customer_Name,Customer_ID Customer_Street,Customer_City) Loan = (loan_no,loan_amount)

3. Attribute Types Simple and Composite attributes If the attributs are not divided into subparts is called simple. If the attributs are divided into subparts is called Composite. Example : Simple - Salary, Balance Composite - Name Single Attributes Single data value for particular entity that describe entity itself is defined by Single attributes. Example : ID

4. Composite Attributes Name First_name middle_initial last_name

5. Attribute Types Multi-Valued attributes A multivalued attribute is one that holds multiple values for a Single entity. Example : Derived attributes The value for derived attribute can be derived from the values Of other related attributes. Phone_no

6. Derived Attributes Stored or Base attribute Birth_date Current_date Age

7. Thank You