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


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

Login to reply

👍?
helpful
2:01pm Wed 4th Sep, ANONYMOUS

In the given project: 1. can there be relationships between more than one entity?For example;can there be a hired relationship between vehicles and depot? as well as between vehicles and client?Can we infer and add extra relationships on our own? 2.can we assume that client is an individual person and has their own table?can we also add representative as their own table?there is a bit of confusion as the paragraph does not clearly state this.


SVG not supported

Login to reply

👍?
helpful
7:52pm Thu 5th Sep, Mengxi L.

1.Yes, there can be relationships between multiple entities.For example, as per the case study, a vehicle can be related to a depot (where it is stored or picked up) and a client (who hires it).You are free to infer and add additional relationships as long as they logically follow from the case study description. 2.Yes, you can assume that the client is an individual person, and the case study provides enough information to treat clients as a separate entity with attributes like name, address, and contact information.The case study also states that if the client is a company, there must be a nominated representative whose details are recorded like those of an individual client.Representatives could be treated as a separate entity or as part of the client entity, depending on your design.You can document such assumptions in the optional PDF,, as suggested in the project instructions.


 UWA week 37 (2nd semester, week 7) ↓
SVG not supported

Login to reply

👍?
helpful
5:52pm Tue 10th Sep, ANONYMOUS

In Attribute Dictionary do I need to write down the Foreign Keys or not? Thank You


 UWA week 38 (2nd semester, week 8) ↓
SVG not supported

Login to reply

👍?
helpful
12:08pm Fri 20th Sep, ANONYMOUS

hi everyone, just wanted to check if we were meant to individually submit the part 1 of the project? Or was it sufficient for 1 person in the pair to submit for the two?

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