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

Python - Dictionary, A dictionary is variable and is one more container typ... A dictionary is variable and is one more container type that can store any number of Python objects, counting other container types. Dictionaries consist of pairs (identified items

Types of chat room, Types of chat room: Java Chat rooms: The most comm... Types of chat room: Java Chat rooms: The most common and popular chat scripts are based on java which is object oriented language. Java is freely available and comes with virt

Paper system, Paper System : When setting up a computer system you need to... Paper System : When setting up a computer system you need to ask yourself 'Does the system you plan to operate work manually, i.e., on paper?' It is a popular misconception that t

File organization, File Organization There are three types of fi... File Organization There are three types of file organization used in practice. Let us consider the example of a dictionary. The dictionary contains listing of English wo

COMputer fundamentals, explain the expression "A=5" explain the expression "A=5"

How will url services be affected, URL services has two divisions. Basic we... URL services has two divisions. Basic webpages and custom webpages. Ricky Vega, Custom's manager wants to find out why Custom is not profitable. He has prepared the following repor

Hardware, Hardware Hardware includes the cable and a Hub/Switch that... Hardware Hardware includes the cable and a Hub/Switch that will connect the participating computers together. Printers or any other peripherals connected to one computer can

Magnetic core memory, MAGNETIC CORE MEMORY: This type of memory is used... MAGNETIC CORE MEMORY: This type of memory is used extensively in airborne digital systems, although integrated circuits are being developed with most modern aircraft systems.

Moderns, Moderns: As it was explained earlier, communications channels... Moderns: As it was explained earlier, communications channels can operate in either the Analog or digital mode. However, a given circuit can operate only in one mode not both

What is Kernel-Level Thread in operating system?, In this technique, the ... In this technique, the kernel knows about and handles the threads. No runtime system is required in this case. In place of thread table in each process, the kernel has a thread tab