What is an Attribute?

Each attribute has a name and is associated with an entity and a domain of legal values. However, the information about the attribute domain is not presented on the ERD

How do identify an attribute in ER diagram?

A quality or characteristic of an entity is called an attribute. Any amount of qualities can be found in a single entity. The primary key is one of the qualities. An ellipse shape is used to represent characteristics in an Entity-Relation model.

For instance, a student's qualities include his or her name, age, and ID number, among others. Because the primary key is unique, we utilize it as an ID number to identify the student. Attributes can also be separated into subsets.

Simple, Composite, Single-valued, Multi-valued, and Derived attributes are the five types of attributes available. Another characteristic that they have is Complex Attribute, which is a rarely utilized attribute.

Attributes of Salon BETA

Entity	Attributes
Cashier	Cashier_Name
	Cashier_ID *P.K.

Service	Service_Code *P.K.
	Price
	Service_Type (Facial, Hair_Style, Bridal) *C.A.

Inventory	Inventory_ID *P.K.
	Brand
	Quantity
	Consumable
	Tool

Employee	Emp_ID *P.K.
	Emp_Name
	Address
	DOB
	Tel_No *M.V.

Customer	NIC *P.K.
	Cus_Name
	Address
	Tel_No *M.V.

Notation
*P.K.	Primary Key
*M.V.	Multi-valued Attribute
*C.A.	Composite Attributes

In some times

Some attributes occur when a task is performed. There they are marked on the relevant relation. It means that the attributes describe the properties of that function.

For example, the date and time a payment was made and the date a payment receipt was issued.

In our project, we met several of these kinds of attributes.