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 99 other people reading this forum.


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

Login to reply

👍?
helpful
9:54pm Thu 19th Sep, ANONYMOUS

Hi, I would really appreciate it if i could get some clarifications regarding the project? I have 4 questions: 1.Why would make and model in the VehicleType be the primary keys? Any two cars could have the same make and model(eg. Both cars are Hondas and they have the same model number like X5)So how would we distinguish between two cars of the same model/make? 2.Also,if the make/model are the same then wouldn't the doors ,trim, body etc. all be the same? Then wouldn't this table be redundant? 3.Why is fleet not an entity, when the database is used to manage the fleet of hire vehicles? 4.Where is the daily insurance and rental tariff in the DailyTariff entity?Because they were specifically given values in part1($3) so wouldn't they be attributes as well?Or are we supposed to assume that their IDs are included in the tariffID attributes?

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