if you want to remove an article from website contact us from top.

    select the attributes which made up of more than one single attribute.

    Mohammed

    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 :

    Question

    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

    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

    स्रोत : www.gkseries.com

    ER Model

    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.

    Entity

    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.

    Attributes

    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 Attributes

    Simple 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.

    Relationship

    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.

    Relationship Set

    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 Cardinalities

    Cardinality 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

    स्रोत : www.tutorialspoint.com

    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-

    Simple attributes

    Composite attributes

    Single valued attributes

    Multi valued attributes

    Derived attributes Key attributes

    1. Simple Attributes-

    Simple attributes are those attributes which can not be divided further.

    Example-

    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.

    Example-

    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.

    Example-

    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.

    Example-

    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).

    Example-

    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.

    Example-

    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.

    Summary

    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

    AuthorAkshay Singhal

    Publisher NameGate Vidyalay

    Publisher Logo

    स्रोत : www.gatevidyalay.com

    Do you want to see answer or more ?
    Mohammed 10 day ago
    4

    Guys, does anyone know the answer?

    Click For Answer