help1402

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 99 other people reading this forum.

UWA week 37 (2nd semester, week 7) ↓

Some questions regarding the project (all 4)

7:10pm Tue 10th Sep, Jichunyang L.

ANONYMOUS wrote:

> 1. I understand we cannot put FKs as a listed attribute on the ER diagram/attribute dictionary, but what if this FK would be a part of a PK? Is it okay to not have an attribute identified as the PK or do we have to find some other PK?

PK and FK can be the same, but it is not a best practice. Can you find a better FK in your table?

> > 2. In the occerence column in the data dictionaries, is it advised to have a specific example or to use entity names? So far I have been using entity names e.g., 'vehicle resides in depot', but I feel a more specific example e.g., 'ford focus resides in depot 01' is clearer to the reader.

No. You can have your own decision.

> > 3. Should we include an alias that is the same as the entity name if there are no aliases? Or just leave it blank?

It can be blank.

> > Apologies if any of these have already been answered in the forums, I couldn't seem to find any answers on these.

help1402 articles all ANNOUNCEMENTS recent articles login to post a new article help1402 topics from today and yesterday from the past week from the past two weeks ALL topics, most recent first	login chapter0 unitinfo research projects csforum csse-feedback csbreakdown cssubmit csmarks 2nd semester help fora Algebra Advanced Algorithms Cloud Computing High Performance Computing Intelligent Agents Professional Computing Relational Database Management Systems Systems Programming