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

Explain FDM : Frequency Division Multiplexing, Frequency Division Multiplex... Frequency Division Multiplexing : FDM is an analog technique that is applied when he bandwidth of link is greater than the combined bandwidth of the signals to be transmitted. a

How should an ideal hospital software be? , How Should an Ideal Software be... How Should an Ideal Software be?  It should be easy to operate, with minimal training of nursing personnel.   Should be reliable, and thoroughly tested in various nur

Mainframe architecture, Mainframe Architecture: Till a few decades bac... Mainframe Architecture: Till a few decades back, all computing was controlled through the central mainframes server. Multiple users could connect to the central host through u

What is thread in operating system?, Regardless of of the fact that a thre... Regardless of of the fact that a thread must execute in process, the process and its associated threads are different notion. Processes are used to group resources together and thr

Languages, Languages The language is a program containing rules and... Languages The language is a program containing rules and guidelines to help us in making programs. There are various languages like C, Basic, COBOL, PASCAL, FORTRAN etc. Th

Note on hyper text markup language (html) with example, Problem A) The ... Problem A) The TCP/IP reference model is the network model used in the current Internet architecture. This model is derived from the OSI model and they are relatively same in n

C++ Programming, Help with MST algorithm Help with MST algorithm

Internet searching algorithm, Internet searching algorithm: Searching: Wh... Internet searching algorithm: Searching: When a user enters a query into a search engine, the engine examines its index and provides a listing of best-matching web pages accordin

Algorithm, solve three given number in ascending order through algorithm solve three given number in ascending order through algorithm

C++, Write a C++ program that declares three integers and three strings. Th... Write a C++ program that declares three integers and three strings. The program prompts the user for three characters and three integers and prints them all on one line.