Guys, does anyone know the answer?
get select the attributes which made up of more than one single attribute. from screen.
The attributes made up of more than one single attributes are called :
multiple choice questions and answers on DBMS e.g. The attributes made up of more than one single attributes are called :
The attributes made up of more than one single attributes are called :
A Derived attribute
B Composite attribute
C Single value attribute
D Multi value attribute
Answer & Explanation
Option: [B] Advertisement
Miscellaneous GK Questions
Q. The process of removing calcium and magnesium from hard water is known as
Q. Polythene is a polymer o
Q. Which body framed the Constitution of Independent India ?
Q. Who amongst the following was awarded Nobel Prize for developing the technology used in integrated circuits used in PCs ?
Q. The winning candidate in the Election of President of India should secure
Q. In the 1907 Session of the Congress at Surat, whose name was proposed by extremists group as the next President of the Congress ?
Q. BCG vaccination is to be given to a new-born child
Q. The horizontal layers of soils are known as
Q. One property of ammonia is-
Q. The Residuary Powers (not mentioned in the Union, State or Concurrent lists of the Constitution) are vested in
Today's Top Current Affairs
‘Naanera’ bagged ‘Golden Kailasha’ Award in Ajanta-Ellora Film Festival 19 January 2023
Padho Pardesh scheme discontinued by Ministry of Minority Affairs 19 January 2023
NCERT Launched India’s First National Assessment Regulator “PARAKH” 19 January 2023
A Book Come! Let’s Run Authored by Tamil Nadu Health Minister Released 19 January 2023
Leading Scientist A.D. Damodaran passes away 19 January 2023
Writer K Venu received Federal Bank Literary Award 2023 19 January 2023
Former BSF chief Pankaj Kumar Singh appointed as Deputy NSA 19 January 2023
B-20 inception meeting to be organised in Gandhinagar, Gujarat 19 January 2023
Viktor Axelsen wins men’s singles Malaysia Open title 2023 19 January 2023
RBI proposes expected loss-based approach for provisioning by banks 19 January 2023
PM Modi Inaugurated Second Phase of Sansad Khel Mahakumbh 2022-23 19 January 2023
Pakistan is South Asia’s Weakest Economy, World Bank report 19 January 2023
World’s oldest person, Lucile Randon passes away at the age of 118 19 January 2023
18th National Disaster Response Force Day celebrates on 19th January 2023 19 January 2023
Current Affairs MCQs
Current Affairs Quiz November 2022
Current Affairs Quiz October 2022
Current Affairs Quiz September 2022
Current Affairs Quiz August 2022
Current Affairs Quiz July 2022
Current Affairs Quiz June 2022
Current Affairs Quiz May 2022
Current Affairs Quiz April 2022
Current Affairs Quiz March 2022
Current Affairs Quiz February 2022
Current Affairs Quiz November 2021
Current Affairs Quiz October 2021
State-wise Current Affairs
Andhra Pradesh Current Affairs
Arunachal Pradesh Current Affairs
Assam Current Affairs
Bihar Current Affairs
Chhattisgarh Current Affairs
Delhi Current Affairs
Goa Current Affairs
Gujarat Current Affairs
Haryana Current Affairs
Himachal Pradesh Current Affairs
Jammu & Kashmir Current Affairs
Jharkhand Current Affairs
Karnataka Current Affairs
Kerala Current Affairs
Madhya Pradesh Current Affairs
Maharashtra Current Affairs
Manipur Current Affairs
Meghalaya Current Affairs
Mizoram Current Affairs
Nagaland Current Affairs
Odisha Current Affairs
Puducherry Current Affairs
Punjab Current Affairs
Rajasthan Current Affairs
Sikkim Current Affairs
Tamil Nadu Current Affairs
Telangana Current Affairs
Tripura Current Affairs
Uttarakhand Current Affairs
Uttar Pradesh Current Affairs
West Bengal Current Affairs
ER Model - Basic Concepts, The ER model defines the conceptual view of a database. It works around real-world entities and the associations among them. At view level, the ER model is cons
ER Model - Basic Concepts
Advertisements Learn more Previous Page Next Page
DBMS For GATE Exams
178 Lectures 14.5 hours
Arnab Chakraborty More Detail
The ER model defines the conceptual view of a database. It works around real-world entities and the associations among them. At view level, the ER model is considered a good option for designing databases.
An entity can be a real-world object, either animate or inanimate, that can be easily identifiable. For example, in a school database, students, teachers, classes, and courses offered can be considered as entities. All these entities have some attributes or properties that give them their identity.
An entity set is a collection of similar types of entities. An entity set may contain entities with attribute sharing similar values. For example, a Students set may contain all the students of a school; likewise a Teachers set may contain all the teachers of a school from all faculties. Entity sets need not be disjoint.
Entities are represented by means of their properties, called attributes. All attributes have values. For example, a student entity may have name, class, and age as attributes.
There exists a domain or range of values that can be assigned to attributes. For example, a student's name cannot be a numeric value. It has to be alphabetic. A student's age cannot be negative, etc.
Types of AttributesSimple attribute − Simple attributes are atomic values, which cannot be divided further. For example, a student's phone number is an atomic value of 10 digits.Composite attribute − Composite attributes are made of more than one simple attribute. For example, a student's complete name may have first_name and last_name.Derived attribute − Derived attributes are the attributes that do not exist in the physical database, but their values are derived from other attributes present in the database. For example, average_salary in a department should not be saved directly in the database, instead it can be derived. For another example, age can be derived from data_of_birth.Single-value attribute − Single-value attributes contain single value. For example − Social_Security_Number.Multi-value attribute − Multi-value attributes may contain more than one values. For example, a person can have more than one phone number, email_address, etc.
These attribute types can come together in a way like −
simple single-valued attributes
simple multi-valued attributes
composite single-valued attributes
composite multi-valued attributes
Entity-Set and Keys
Key is an attribute or collection of attributes that uniquely identifies an entity among entity set.
For example, the roll_number of a student makes him/her identifiable among students.Super Key − A set of attributes (one or more) that collectively identifies an entity in an entity set.Candidate Key − A minimal super key is called a candidate key. An entity set may have more than one candidate key.Primary Key − A primary key is one of the candidate keys chosen by the database designer to uniquely identify the entity set.
The association among entities is called a relationship. For example, an employee works_at a department, a student enrolls in a course. Here, Works_at and Enrolls are called relationships.
A set of relationships of similar type is called a relationship set. Like entities, a relationship too can have attributes. These attributes are called descriptive attributes.
Degree of Relationship
The number of participating entities in a relationship defines the degree of the relationship.
Binary = degree 2 Ternary = degree 3 n-ary = degree
Mapping CardinalitiesCardinality defines the number of entities in one entity set, which can be associated with the number of entities of other set via relationship set.One-to-one − One entity from entity set A can be associated with at most one entity of entity set B and vice versa.
One-to-many − One entity from entity set A can be associated with more than one entities of entity set B however an entity from entity set B, can be associated with at most one entity.
Many-to-one − More than one entities from entity set A can be associated with at most one entity of entity set B, however an entity from entity set B can be associated with more than one entity from entity set A.
Many-to-many − One entity from A can be associated with more than one entity from B and vice versa.
Previous Page Next Page Advertisements Learn more
Types of Attributes
Attributes in DBMS are the descriptive properties owned by each entity of an entity set. Types of attributes in DBMS- Simple attributes, Composite attributes, Single valued attributes, Multi valued attributes, Derived attributes, Key attributes
Types of Attributes | DBMS
Database Management System
Attributes in ER Diagram-
Before you go through this article, make sure that you have gone through the previous article on Introduction to ER Diagrams.
Attributes are the descriptive properties which are owned by each entity of an Entity Set.
There exist a specific domain or set of values for each attribute from where the attribute can take its values.
Types of Attributes-
In ER diagram, attributes associated with an entity set may be of the following types-
Single valued attributes
Multi valued attributes
Derived attributes Key attributes
1. Simple Attributes-
Simple attributes are those attributes which can not be divided further.
Here, all the attributes are simple attributes as they can not be divided further.
2. Composite Attributes-
Composite attributes are those attributes which are composed of many other simple attributes.
Here, the attributes “Name” and “Address” are composite attributes as they are composed of many other simple attributes.
3. Single Valued Attributes-
Single valued attributes are those attributes which can take only one value for a given entity from an entity set.
Here, all the attributes are single valued attributes as they can take only one specific value for each entity.
4. Multi Valued Attributes-
Multi valued attributes are those attributes which can take more than one value for a given entity from an entity set.
Here, the attributes “Mob_no” and “Email_id” are multi valued attributes as they can take more than one values for a given entity.
5. Derived Attributes-
Derived attributes are those attributes which can be derived from other attribute(s).
Here, the attribute “Age” is a derived attribute as it can be derived from the attribute “DOB”.
6. Key Attributes-
Key attributes are those attributes which can identify an entity uniquely in an entity set.
Here, the attribute “Roll_no” is a key attribute as it can identify any student uniquely.Next Article- Converting ER Diagrams to Tables
Get more notes and other study material of Database Management System (DBMS).
Watch video lectures by visiting our YouTube channel LearnVidFun.
Article NameTypes of Attributes | DBMS
DescriptionAttributes in DBMS are the descriptive properties owned by each entity of an entity set. Types of attributes in DBMS- Simple attributes, Composite attributes, Single valued attributes, Multi valued attributes, Derived attributes, Key attributes
Publisher NameGate Vidyalay