Purchase Solution

Composite key vs. composite attribute

Not what you're looking for?

Ask Custom Question

Discuss the difference between a composite key and a composite attribute. How would each be indicated in an ERD?

Purchase this Solution
Solution Summary

Word document attached outlines the differences between a composite key and a composite attribute, including how an ERD would indicate which it was.

Purchase this Solution
Free BrainMass Quizzes
Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

View More Free Quizzes
Related BrainMass Solutions

  • database normal form

    Because the combined Address attribute will have composite value.

  • Composite and multivalued attributes, data redundancy

    A simple attribute cannot be broken down but a composite attribute can be broken down into different subparts. An example would be someone's address. The address can be broken down into street, city, state, and zip code.

  • unnormalized relation

    The original relation is already in 2NF, because ShowingID is the single-attribute key and every nonprime attribute depends on ShowingID. 3.

  • Improving Table Designs Using Normalization.

    attribute is fully dependent on the primary key. 3NF - A relation R is in third normal form (3NF) if and only if it is in 2NF and every non-key attribute is non-transitively dependent on the primary key.

  • Custom order entry system

    attribute is fully dependent on the primary key. 3NF - A relation R is in third normal form (3NF) if and only if it is in 2NF and every non-key attribute is non-transitively dependent on the primary key.

  • Handy Home: CVP analysis and break-even using composite unit

    One composite unit = 7 windows + 1 door Selling price per composite unit $ = 7*90+1*240=870 Variable costs per composite unit $=7*62+1*174=608 Break-even point in composite units=Fixed cost / (Selling price - variable cost) =460000/(870-608)=1756 composite

  • supporting data integrity in a database

    A composite key consists of more than one field. Data relationships: Data file relationships are generally recognized as "1:1"; "1:many"; or "many:many". How is integrity enforced?

  • Advantages of a database over electronic files to store data

    Yes, a primary key can be a combination of multiple columns and is called "composite key". "StudentCource" table will have a composite key "studentId","courceId" that uniquely identifies combination of student and courseId.

  • Calculating the Rate of Depreciation

    per year for plant assets under the composite method.

View More Related Solutions