Multi-valued attribute dbms, computer science, Basic Computer Science

Assignment Help:
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.

Related Discussions:- Multi-valued attribute dbms, computer science

Create email account, Create Email Account: For sending or receiving e...

Create Email Account: For sending or receiving email, you need to have to an email account. The email account may be provided by the organization for which you are working or

In-door patient department, In-door Patient Department Ideally all ...

In-door Patient Department Ideally all features of OPD.  Both OPD and IPD modules should be inter-linked.  In addition all details pertaining to the patient's medica

Define levels of abstraction in a dbms, Define Levels of Abstraction in a D...

Define Levels of Abstraction in a DBMS, explain briefly, Conceptual Schema, Physical Schema, External Schema

Theory of computation, If L is a regular language show that L U {a} is regu...

If L is a regular language show that L U {a} is regular

Syntax of a Macro, The divisions which make a macro are: • Declaration of t...

The divisions which make a macro are: • Declaration of the macro Code of the macro Macro termination directive The assertion of the macro is done the following way: Name Macro [par

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

Finding average marks, Problem In the Excel sheet, input the marks of a...

Problem In the Excel sheet, input the marks of any 5 students with 5 subjects and find the average marks, maximum marks, minimum marks obtained by the student. Using Excel s

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd