[Year 12 IT Apps] Another Questions: VITTA Practice Exam 2 Question 56

[Mark Kelly]

Yep.  A primary key is just a field in a table that is used to hold a 
unique record identifier, such as an ID or a customer/part/account 
number.  It can be of any sensible data type such as text or numeric.

Geoff Moss wrote:
> Hi Jo
> 
> 15-ALL
> 
> While not having seen the Practice Exams, and using the information you provide, your reasoning is IMHO correct.  The primary key defines a quality on the data type, in that the data in that field must be unique for each record.
> 
> On its own the primary key cannot be a data type.
> 
> Hope this helps
> 
> Geoff Moss
> RMIT
> 
> 
> 
>> jtabone at aitkencollege.edu.au wrote:
>>
>> Sorry guys for doing this piecemeal, but can I please have your
>> opinion to the following 
>>
>> The Answer to Question 5 VITTA Exam 2 suggests that a primary key is
>> a data type
>>
>> My understanding of a primary key is that it is a key that is
>> designated to a field therfore ensuring that the field holds a unique
>> value for each record - within this field however a data type would be
>> text,number, date etc
>>
>> Thanks for your help
>>
>> Cheers
>> Joyce Tabone
>> Aitken College
>>
>>
>>
>>>
>>>
>>> ---------------------------------------------
>>> Privileged or Confidential information may be contained in this
>> message. 
>>> If you are not the addressee indicated in this message (or
>> responsible for 
>>> delivery of this message to such person), you may not copy or
>> distribute this
>>> message. In such case destroy this message and please notify the 
>>> sender by email, or call Craig Brooks (LAN Administrator) at Aitken
>> College 
>>> on (+61 3) 9333 1866. Thank-you
>>> _______________________________________________
>>> http://www.edulists.com.au - FAQ, resources, subscribe,
>> unsubscribe
>>> IT Applications Mailing List kindly supported by
>>>
>> http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html
>> - Victorian Curriculum and Assessment Authority and
>>> http://www.vitta.org.au  - VITTA Victorian Information Technology
>> Teachers Association Inc

-- 
Mark Kelly
Manager - Information Systems
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: 8520 9085
School Phone +613 8520 9000
School Fax +613 95789253
kel AT mckinnonsc.vic.edu.au

Webmaster - http://www.mckinnonsc.vic.edu.au
IT Lecture notes: http://vceit.com
Moderator: IT Applications Mailing List

It's 'i' before 'e' except after 'c'.
Spelling is not an art, it's a sceince.