It's UWAweek 18 (1st semester, week 9)

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 the 4 articles in this topic
Showing 4 of 107 articles.
Currently no other people reading this forum.


 UWA week 13 (1st semester, week 5) ↓
SVG not supported

Login to reply

👍?
helpful
11:18am Thu 28th Mar, ANONYMOUS

Hi, I know that we do not include foreign keys within our ER diagrams, but do we include them within our attribute data dictionary's, or should we consider them later when making our databases (ie. part 2 of the project)? Thanks


SVG not supported

Login to reply

👍x1
helpful
10:41pm Fri 29th Mar, Mehwish N.

No, please do not include them. The first part is the conceptual model. We will take care of them in logical modelling i.e., in part 2 of the project.


 UWA week 14 (1st semester, non-teaching week) ↓
SVG not supported

Login to reply

👍?
helpful
12:30pm Mon 1st Apr, ANONYMOUS

"Mehwish Nasim" <me*w*s*.*a*i*@*w*.*d*.*u> wrote:
> No, please do not include them. The first part is the conceptual model. We will take care of them in logical modelling i.e., in part 2 of the project.
lots of the "questions your model should be able to answer" become impossible to answer if forign keys aren't used in the dictionary EG: Who has booked the most appointments? without a forign key for the patient that booked it, how can we answer this, even theoretically. Are these questions also relating to the second part of the project?


SVG not supported

Login to reply

👍?
helpful
3:07pm Mon 1st Apr, ANONYMOUS

I could be wrong, but I think those are just questions for consideration in the interim before we actually include all the foreign keys in our logical modelling.

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  5:07AM Sep 06 2023
Privacy policy