Multivalued attributes, Database Management System

For every multivalued attribute 'A', we make a new relation R that contains an attribute corresponding to plus the primary key attribute k of the relation that shows the entity type or relationship type that has as an attribute. The primary key of R is then mixture of A and k.

For instance, if a STUDENT entity has RollNo, Name and PhoneNumber where phone number is a multi-valued attribute then we will make a table PHONE (RollNo, Phone-No) where primary key is the combination. Please also reminder that then in the STUDENT table we need not have phoneNumber, instead it can be easily (Roll No, Name) only.

Posted Date: 3/6/2013 6:28:26 AM | Location : United States







Related Discussions:- Multivalued attributes, Assignment Help, Ask Question on Multivalued attributes, Get Answer, Expert's Help, Multivalued attributes Discussions

Write discussion on Multivalued attributes
Your posts are moderated
Related Questions
A full discription of the new, a discription of its components, and the bebefit it will provide a company. A disscussion of the information usedin the system. A disscussion of any

What is a relationship called when it is maintained between two entities? A relationship is called Binary relationship when it is maintained between two entities.


Describe the algorithm for updating indices for a single level index when a record is    (i) Inserted  (ii)  deleted What will be the modification if there are multilevel in

let us consider a table having 2200 records and the fixed size of the table to be considered as 25.then how many numbers of table is requredto perform horizontal fragmentation

Having clause This clause is used for producing conditions on grouped information. Example: Find maximum salary and department number of those departments where maxim

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

Describes the several relationship constraints through giving suitable example? Constraints on relationships: There are two kinds of constraints on relationships. 1) Mapping

What are the authentication modes in SQL Server? How can it be changed? Windows mode and Mixed Mode - SQL and Windows. To alter authentication mode in SQL Server click Start, P

Why do so various organizations use MySQL? Advantages: Open source Highly efficient Offers a high scalability in terms of size and connectivity. Highly prote