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

Write a long note on computer languages, Question 1 Explain the importan... Question 1 Explain the importance of graphics in multimedia. What are few of the tips to keep in mind while using graphics for the web? Question 2 Write a long note on co

Unix shell and history problem, UNIX Shell and History feature. 1.Creating ... UNIX Shell and History feature. 1.Creating a child process. 2.Creating a history feature. Its exactly "programming project 1 - Unix Shell and History Feature (p.157-159)" in the Si

Why is the random class in the .net framework not suitable, QUESTION (a... QUESTION (a) (i) Why is the Random class in the .NET framework not suitable for generating random bytes for cryptography purposes? (ii) Mention two characteristics required

BUS STRUCTURE, Ask question #WHAT IS TWO BUS STRUCTURE Ask question #WHAT IS TWO BUS STRUCTURE

Memory management, Memory Management: The purpose of the memory mana... Memory Management: The purpose of the memory management system is to load programs into memory in such a way as to give each program loaded  the memory that it requires for

Logic and arithmetic functions, The instructions of the logic functions are... The instructions of the logic functions are: and not, or and xor. These act on the bits of their operators. To make sure the result of the operations we revolve to the cmp and test

Input and output devices, Input and Output Devices : The most common input... Input and Output Devices : The most common input devices that you will see in your PC are the keyboard and the mouse. The keyboard of the computer looks like the keyboard o

Concept of operating system, Concept of operating system: An operating... Concept of operating system: An operating system is an essential software component of a computer system. The basic  objectives of an operating system are to make the computer

Discuss the objectives of query processing, Question 1 Differentiate betwe... Question 1 Differentiate between PL/SQL functions and procedures Question 2 Draw the diagram of logical structure of oracle database and explain it in brief Question 3 D

Define jumps and loops , The unconditional jumps in a written program in a... The unconditional jumps in a written program in assembler language are specified by the jmp instruction; a jump is to moves the flow of the execution of a program by sending the co