Discuss along with examples about several types of er model, Database Management System

Assignment Help:

Discuss along with examples about several types of attributes present in the ER model?

Types of Attributes are:
• SIMPLE attributes are attributes which are drawn from the atomic value domains
E.g. Name = {John} ; Age = {23}
• COMPOSITE attributes: Attributes that consist of a hierarchy of attributes
E.g. Address may consists of "Number", "Street" and "Suburb" → Address = {59 + ‘Meek Street' + ‘Kingsford'}
• SINGLE VALUED attributes: Attributes which have only one value for each entity E.g. Name, Age for EMPLOYEE
• MULTIVALUED attributes: Attributes that have a set of values for each entity E.g. Degrees of a person: ‘ BSc' , ‘MIT', ‘PhD'
• DERIVED attributes: Attributes Contain values which are computed from other attributes
Eg. Age can be derived from attribute DateOfBirth. In this situation, DateOfBirth might be known as Stored Attribute


Related Discussions:- Discuss along with examples about several types of er model

Define object-relational systems, Define object-relational systems? Sy...

Define object-relational systems? Systems that give object-oriented extensions to relational systems are known as object-relational systems.

Graphical user interface tools, These are interactive interfaces, graphical...

These are interactive interfaces, graphical that hide the difficulty of the DBMS and query language behind an intuitive, simple to understand, and convenient interface. This permit

Applications and goals of dbms, What do you mean by DBMS? What is its need ...

What do you mean by DBMS? What is its need and what are its goals. Explain?        OR   Explain Data Base Management System? Sol.  Database management system is a

What is deadlock, What is deadlock? Neither of the transaction can ever...

What is deadlock? Neither of the transaction can ever proceed with its normal implementation. This situation is known as deadlock.

List the requirements needed to design a trigger, List the requirements nee...

List the requirements needed to design a trigger. The requirements are:- Specifying when a trigger is to be implemented. State the actions to be taken when the trigger im

In e-r diagram how generalization is represented, In E-R diagram how genera...

In E-R diagram how generalization is represented? in E-R diagram generalization is represented by Triangle shape.

What is storage manager, What is storage manager?  A  storage  manager ...

What is storage manager?  A  storage  manager  is  a  program  module  that  gives  the  interface  between the Low level data  kept in a database and the application programs

Explain in detail about collaboration diagrams, Explain in detail about Col...

Explain in detail about Collaboration Diagrams Collaboration diagrams are interaction diagrams which emphasize structural organisation of an object that transmit and receive m

What is a select operation, What is a SELECT operation? The select oper...

What is a SELECT operation? The select operation selects tuples that please a given predicate. We use the lowercase letter σ to denote selection.

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