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 selected article
Showing 1 of 684 articles.
Currently 126 other people reading this forum.


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

Login to reply

👍?
helpful

Does a paragraph have to be a relation? If not, are book(5th paragraph) and hire(4th paragraph) allowed to be designed with the same relationship? In addition, if there are attributes not mentioned in this paragraph, can I add them myself? For example: There is no mention of the need to record the fuel consumption type of the vehicle in the first paragraph, but in the fifth paragraph of the booking, it is mentioned that this attribute is required. Does that mean that I should add the fuel consumption attribute to the Car table in the first paragraph? If not, does this mean that each vehicle make can only represent one fuel consumption type? (Because it seems that only the car make is related to the car in the first section) Also, depots do not have attributes to connect to the cars in the first segment. Should we record the car IDs in each depot?

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