It's UWAweek 47

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 3 articles in this topic
Showing 3 of 684 articles.
Currently 126 other people reading this forum.


 UWA week 43 (2nd semester, study break) ↓
SVG not supported

Login to reply

👍?
helpful
5:27pm Fri 25th Oct, ANONYMOUS

For the theory test, I was under the assumption that the ERD drawing provided to us would be correct, however, many of the relationship type between entity questions are conflicting. For example: "" Question 2: In the case study, what type of relationship exists between Client and HiredVehicle? a. One-to-One b. One-to-Many c. Many-to-Many d. Recursive Relationship "" The correct answer is listed as b: One-to-Many. However, in the solution provided, the relationship is listed as One-to-One. I do not understand why either the solution provided is wrong, or we are being penalised for using the solution given to us. There are several more questions that follow this concerning logic (Q2, Q7, Q14, Q16, Q21, Q22). Please let me know if I have misunderstood.


SVG not supported

Login to reply

👍?
helpful
5:38pm Fri 25th Oct, ANONYMOUS

I also found this article that confirms that Mehwish told us to refer to the ERD to complete the take-home test.

Link


SVG not supported

Login to reply

👍?
helpful
7:13pm Fri 25th Oct, ANONYMOUS

Even if you follow the ERD the correct answer for Question 2 is b-One to Many. In the ERD it's given as Client(1..1) Hires (0..*)HiredVehicle. So it is One to Many as each client can hire 0 to MANY vehicles and each vehicle can be hired by ONE client only.

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