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
What is serialization? Where it is used and why?  Serialization is a basic term used for mechanisms which enable objects and object structures to be converted into portable for

Using the questions found at the end of Chapter 9 in your textbook, complete this homework activity. Students will submit a Word document answering questions 2, 3, and 4.


Question: In a multi-user database environment, locking mechanisms can be used to solve the three basic problems of concurrency. On the other hand, however, locking may also le

Implementing software control To implement software control designer must redesign strategy of state event model which is present in dynamic model. There are three basic ap

Gaps in sequence values can happen when: -     A rollback happens that is when a statement changes are not accepted. -     When the system crashes -     When a sequence i

give some example real-life situations where DBMS are most suiitabe

Security And Integrity After Reading the concepts of database recovery in the last section, let us now deal with a vital concept that helps in minimizing consistency errors in

Write a short note on oracle Instance? Oracle Instances: An instance is the (executed) Oracle software and the memory they use. It is the instance which manipulates the data s

Show, with the help of an example, that relatively high-level transitions result when system or program is stimulated by the outside events. In diagram below, we can observe i