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 a view and a trigger, Define a view and a trigger. Construct a view ...

Define a view and a trigger. Construct a view for the above relations that have the information about suppliers and the elements they supply. The view holds the S#, SNAME, P# , PNA

In an e-r diagram how attributes are represented, In an E-R diagram how att...

In an E-R diagram how attributes are represented ? In an E-R diagram attributes are represented in a ellipse.

Homework, can you resolve this for me please? Database Management Systems ...

can you resolve this for me please? Database Management Systems Homework 1 The following relations are given (primary keys are underlined): PLAY-ACTOR(AId, Name, Nationality, Birt

Oracle, how oracle can be used

how oracle can be used

Explain the form of the create view command, We define a view in SQL throug...

We define a view in SQL through using the create view command. To describe a view, we must provide the view a name and must state the query in which computers the view. The form of

Physical dbms architecture, PHYSICAL DBMS ARCHITECTURE  The physical ...

PHYSICAL DBMS ARCHITECTURE  The physical architecture defines the software components used to process and enter data, and how these software components are related and interc

What is secondary index, What is Secondary Index While making the index...

What is Secondary Index While making the index, generally the index table is kept in the primary memory (RAM) and the main table, because of its size is keeps in the secondary

Advantages of database systems, Problem 1. Describe the following a)...

Problem 1. Describe the following a) Advantages of Database Systems b) Functions of a DBMS Explanation of part (a) and (b) 2. Explain the following concepts w

Case tools, explain at least five widly used case tools

explain at least five widly used case tools

What are the benefits of decomposing a system, What are the benefits of dec...

What are the benefits of decomposing a system? The benefits of decomposing a system into subsystems are that after decomposition, each individual component become smaller and e

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