The attributes made up of more than one single attributes are called     Single Value     Composite      Multi-value     Derived

A "candidate key" is: any set of fields that determines the values of all other fields functionally dependent on non-key attributes an attribute or set of attributes that can be the primary key the primary key of a relation

Design an E-R model for garage repair shop based on the following order form: DATE: NAME DEPARTMENT LICENSE" YEAR CTY SUBLET UTD PART NO. TOTAL PARTS & LABOR Revised 8/00 MAKE (2) PARTS Labor Parts Labor UTD GARAGE REPAIR ORDER EXTENSION MILEAGE MODEL UNIT PRICE ACCOUNT # DESCRIPTION OF PROBLEM MECHANIC SIGNATURE WORK ORDER* SIGNATURE WITH AUTHORITY FOR ACCOUNT SERVICES PERFORMED

A candidate key is a characteristic that is part of a composite primary key.