It's UWAweek 42 (2nd semester, week 12)

help1402

This forum is provided to promote discussion amongst students enrolled in CITS1402 Relational Database Management Systems.

Please consider offering answers and suggestions to help other students! And if you fix a problem by following a suggestion here, it would be great if other interested students could see a short "Great, fixed it!"  followup message.

How do I ask a good question?
Displaying selected article
Showing 1 of 612 articles.
Currently 119 other people reading this forum.


 UWA week 36 (2nd semester, mid-semester break) ↓
SVG not supported

Login to reply

👍?
helpful
4:19pm Tue 3rd Sep, Adam W.

Hi Jieh Chia, When identifying primary keys, you may encounter a situation where there are no natural primary keys, or the ones available aren't suitable, so you can essentially make a surrogate key (which is what you're suggesting). A surrogate key is a primary key created by the database designer to simplify the identification of entity instances. Surrogate keys are useful in the following situations: When there is no natural key. When the selected candidate key has embedded semantic contents (or is unusable due to privacy concerns). When the selected candidate key is too long. I hope this helps. Thanks, Adam. "Jieh Chia" <24*1*5*4@s*u*e*t*u*a*e*u*a*> wrote:
> Hi, I would like to know if the case study does not mention about a unique identifier for an entity (e.g. Vehicle Make / Nominated driver), are we allowed to make a unique identifier ourselves (e.g. Nominated Driver ID, etc.)? Thank you.

The University of Western Australia

Computer Science and Software Engineering

CRICOS Code: 00126G
Written by [email protected]
Powered by history
Feedback always welcome - it makes our software better!
Last modified  8:08AM Aug 25 2024
Privacy policy