It's UWAweek 19 (1st semester, week 10)

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?
3 articles posted by this person
Showing 3 of 120 articles.
Currently no other people reading this forum.


 UWA week 18 (1st semester, week 9) ↓
SVG not supported
extra attributes 👍x1  (all 3)
2:53pm Sat 4th May, Neethu M.

is it okay to add some extra attributes to identify and to make the entities more identifiable. like is it okay to create an attribute called Appointment ID in appointment table. Also, can there be tables without a primary key?


 UWA week 15 (1st semester, week 6) ↓
SVG not supported 3:04pm Wed 10th Apr, Neethu M.

Answer by UC No references to attributes from other tables. You will eventually do that in second part of the project. ER diagrams do not have foreign keys.


SVG not supported 3:04pm Wed 10th Apr, Neethu M.

This is regarding the foreign keys. You mentioned that we are not supposed to mention the foreign keys in ERD. But if we want to make records unique in a table , we may need to use some foreign keys of other tables . For eg patient ID in the patient...

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