KEMBAR78
Attribute Types Exercise | PDF | Data Management | Data Management Software
Scribd
Upload
238 views1 page

Attribute Types Exercise

The document analyzes the attributes of a employee data table to determine if each field is single, composite, simple, multi-valued, or derived. It finds that Emp_Num is simple and single-valued, Fname and Lname are simple and single-valued, Age is simple and single-valued, Job_Code is composite and multi-valued, and Bonus_Dates is multi-valued and derived.

Uploaded by

apiratehooker
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
238 views1 page

Attribute Types Exercise

The document analyzes the attributes of a employee data table to determine if each field is single, composite, simple, multi-valued, or derived. It finds that Emp_Num is simple and single-valued, Fname and Lname are simple and single-valued, Age is simple and single-valued, Job_Code is composite and multi-valued, and Bonus_Dates is multi-valued and derived.

Uploaded by

apiratehooker
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Name: ___Jeff Hill____________________ Unique Number: ___120460905_____

Attribute composition: Given the layout of the data table below determine if each field is single,
composite, simple, multi valued or derived. Mark an “X” in the appropriate box. The first column,
Emp_Num is done for you.

Emp_Nu Emp_Fnam Emp_Ag Emp_Job_Code


Emp_Lname Emp_DOB Emp_Bonus_Pay_Dates
m e e s
12/15/198
10302 Joe Jones 22 SLS,MKT 6/12/09, 9/14/09, 12/20/09
7
3/3/08, 5/15/08, 9/20/08,
10303 Fred Smith 4/15/1986 23 SLS,WHS
1/3/09
10304 Sally Southerland 3/22/1991 18 WHS 10/20/08, 10/20/09
10305 Sue Cooper 5/3/1989 20 WHS,MKT 9/20/08, 12/5/09, 12/15/10
10/19/199 2/23/07, 3/21/07, 9/6/07,
10306 Fred Smith 29 MGT,SLS
0 2/9/08
10307 Bob Williams 9/30/1979 30 MKT,SLS 9/14/2009
10308 Sally Holtz 4/21/1984 25 SLS,MGT,WHS 5/9/06, 5/9/07, 5/6/09, 5/6/10
10309 Amanda Forman 5/3/1989 20 MKT,WHS 10/12/09, 12/1/10, 5/6/11

Emp_Nu Do
Fname Lname Age Job_Code Bonus_Dates
m b
Simple Valued X X X X X
Composite Valued   X X
Single Valued X X X X X
Multi-Valued   X X
Derived   X

What is the likely Primary Key? Emp_Num

You might also like