Multi-valued Attribute DBMS
Each multi valued attribute maps into a separate table.
Include also an attribute for the primary key of the entity and relationship type which the attribute belongs to.
The relvar has an attribute for each simple attribute of the multi valued attribute.
This is also a foreign key.
The primary key of this relvar is the combination of all the attributes if the multi valued attribute is simple.
If the multi-valued attribute is composite, the primary key of this relvar may be a combination of some of the attributes.

Posted Date: 2/14/2012 10:06:08 PM | Location : United States

Ask an Expert

Related Discussions:- Multi-valued attribute dbms, computer science, Assignment Help, Ask Question on Multi-valued attribute dbms, computer science, Get Answer, Expert's Help, Multi-valued attribute dbms, computer science Discussions

Write discussion on Multi-valued attribute dbms, computer science
Your posts are moderated

Write your message here..

Related Questions

Gui design, how to load a video using push button in gui design click how to load a video using push button in gui design click

Cai, What is CAI? Explain its pitfalls. What is CAI? Explain its pitfalls.

SQL 2008 Server Management Studio, 4. Provide a list of productid’s, the n... 4. Provide a list of productid’s, the name of the vendor and their credit rating. The results should be ordered by last name and then by credit rating. Write out the SQL that wo

03007201126, storage media? storage media?

Which port does FTP uses, Why is it called out of band protocol? A1) FTP us... Why is it called out of band protocol? A1) FTP uses port 20 and port 21; port 20 is used for data connection, whereas port 21 is used for control connection. FTP is known as out-of

Long term goal of artificial intelligence, Long term goal of artificial int... Long term goal of artificial intelligence: This is not to be complex with the applications of AI programs to other sciences, discussed later. Rather, it is just pointing out th

Scope of operation research , scope of operation research in science? scope of operation research in science?

Indexing and abstracting databases, Indexing and Abstracting Databases: ... Indexing and Abstracting Databases: A study of growth of indexing and abstracting services over the years would show that during the past two centuries, these services have be

Artificial intelligence research, Artificial Intelligence research: Art... Artificial Intelligence research: Artificial Intelligence research may be describe  in terms of how the following question has been answered: "How are we going to get a comp

Android database file not loading on real device, i have an android app whi... i have an android app which uses a database file called question db which is stored in the assets file. I have tried a database example called android application development but f