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

Ask an Expert

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

Write your message here..

Related Questions

Explain the timestamps for read operations, Timestamps For Read operations:... Timestamps For Read operations: If TS (T) If TS (T) >= W-timestamp (Q), then the transaction T is trying to read a value of data item Q which has been written and committed

Illustrate the class diagram for class room scheduling, Illustrate the clas... Illustrate the class diagram for class room scheduling system If in any college, the number of classrooms are limited which have to be allocated to various classes and instruct

Define lock, Define lock? Lock is the most common used to execute the r... Define lock? Lock is the most common used to execute the requirement is to permit a transaction to access a data item only if it is currently holding a lock on that item.

Data warehouse, XYZ is a large chain of home entertainment rental over 100 ... XYZ is a large chain of home entertainment rental over 100 stores distributed over all states in Australia. XYZ lends entertainment products such as movies, TV shows and games on v

What is a relationship called when it is maintained entities, What is a rel... 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.

Explain cascade and restrict clauses of drop schema command, Explain severa... Explain several types of constraints that can be specified using CREATE TABLE command. Explain CASCADE and RESTRICT clauses of DROP SCHEMA command? Constraint Description PRIM

Triggers and Stored Procedures, 10A.53 Code an Oracle Database trigger to e... 10A.53 Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department. 10A.54 Code an Oracle Database trigger to allow the delet

desirable properties of decomposition, Desirable Properties Of Decompositi... Desirable Properties Of Decomposition Decomposition is a process of dividing a relation into its projections that will not be disjoint. Please remind the Relational projection

Two approaches to store relations in distributed database, What are the two... What are the two approaches to store relations in distributed database? a) Replication b) Fragmentation

design the logic using looping structure, 1. Design the logic, using a loo... 1. Design the logic, using a looping structure, for a program that outputs every even number from 1 through 25 along with its square and cube. 2. Mr. Sanchez owns 12 apartme