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
Enumerate or state the steps in creating a relevant database of a shop.

Explain current page table and shadow page table. The key idea behind the shadow paging method is to maintain two page tables during the life of the transaction: the current pa

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

Describe the various types of Online Analytical Processing (OLAP) tools and briefly discuss how the support common analytical operations.

What is a hashing function?  What are the properties of a good hashing function?  Describe the folding technique for hashing functions.      Ans:  Hashing function is a method

it can be possible to create any table without primary key

Describe integrity and security? a)      Domain constraint b)      Referential integrity A value that appears in one relation for a given set of attributes also appear fo

Conversion of entity sets: I)   For  every  strong  entity  type  E  in  the  ER  diagram,  we  make  a  relation  R containing all the easy attributes of E. The relation R pri

What are the advantages of having an index structure?      Ans: The index structures commonly provide secondary access paths, which offer alternative ways of accessing the reco

what is RDBMS? how it works? good example.