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

Define query optimization, Define query optimization. Query optimizatio... Define query optimization. Query optimization refers to the process of search the lowest -cost method of evaluating a given query.

Explain what is rdbms, Explain what is RDBMS ? RDBMS - RDBMS is a datab... Explain what is RDBMS ? RDBMS - RDBMS is a database management system (DBMS) which stores data within the form of relations. Relational databases are powerful since they need f

Example-revoke all on emp from mca12, Example:  //REVOKE ALL ON EMP FROM MC... Example:  //REVOKE ALL ON EMP FROM MCA12;                              (All permissions will be cancelled) You can also cancel only some of the permissions. Drop: A user-

What is relationship instance, What is relationship instance ? Relation... What is relationship instance ? Relationship Instance - A relationship is a relation between two or more entities. An instance of relationship set is a set of relationships.

What is a transaction? and how does it differs from update, wh wh

Define database management system, Normal 0 false false fal... Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Sorting field groups we cannot use more than one key field, While sorting f... While sorting field groups we cannot use more than one key field False.

What is the aim of logical schema, What is the aim of logical schema ? ... What is the aim of logical schema ? The main motive of the logical schema is to ensure the portability of procedures and models on various physical schemas at runtime.

What are the object-oriented approaches, What are the object-oriented appro... What are the object-oriented approaches Software systems which are designed with structured design methodology never support some of desired quality attributes for example reus

MYSQL, i have a homework assignment identical to one you have listed i have a homework assignment identical to one you have listed