Define the terms entity, attribute, role and relationship, Database Management System

Assignment Help:

Define the terms entity, attribute, role and relationship between the entities, giving examples for each of them.       

 Ans: Entity:   An entity is a "thing" or "object" in the real world that is apparent from other objects. For instance, a person and bank account can be referred as entities.  

Attribute: Entities are explained in a database by a set of attributes, that is the characteristics of an entity are termed as attributes. For instance, name, age, date of birth, etc are attributes of the entity person. Likewise, nature of account, account number, balance, etc is attributes of the entity bank account.

 Relationship: A relationship is an association between the various entities. For instance, a depositor relationship relates the entity person with a bank account.

Role:   The function which an entity plays in a relationship is called that entity's role. For instance, in the relationship depositor defined above, the entity person plays the role of a customer in the relationship.


Related Discussions:- Define the terms entity, attribute, role and relationship

#, How to use Oracle

How to use Oracle

List some instances of collection types, List some instances of collection ...

List some instances of collection types? a) sets b) arrays c) multisets

What is meant by the degree of relationship set, What is meant by the degre...

What is meant by the degree of relationship set? The degree of relationship type is the number of participating entity types.

Short note on mid square method of hashing, Short Note on mid Square Method...

Short Note on mid Square Method of hashing? Mid square method of hashing: In the method midsquare hashing, the key is squared and the address selected from the center of the s

What is called bit-level striping, Normal 0 false false fal...

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

What are the advantages of using a dbms, What are the advantages of using a...

What are the advantages of using a DBMS? The benefits of using a DBMS are a) Controlling redundancy b) Restricting unauthorized access c) Giving multiple user interfac

Managing Data in Databases, Answer SQL Queries to extract data from data ta...

Answer SQL Queries to extract data from data tables and questions on mapping conceptual data models into relational data model.

With the help of a diagram defines typical element modules, With the help o...

With the help of a diagram defines the typical element modules of a DBMS? The functional elements of a database system can be widely divided into: 1) Storage manager and 2) q

Data modelling, Law Associates is a large legal practice based in Sydney.  ...

Law Associates is a large legal practice based in Sydney.  You have been asked to design a data model for the practice based upon the following specification: The practice emplo

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd