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


 UWA week 40 (2nd semester, week 10) ↓
SVG not supported

Login to reply

👍x1
helpful
9:53am Tue 1st Oct, ANONYMOUS

Hi Teaching Team, I have a question regarding how to translate superclass/subclass related relationship types into SQL. Take the following relation as an example: PropertyForRent(propertyNo,street,city,postcode,type,room,rent,ownerNo) Primary Key propertyNo Foreign Key ownerNo references PrivateOwner(ownerNo) and BusinessOwner(ownerNo) the foreign key ownerNo references two tables, PrivateOwner and BusinessOwner. How should we build the SQL database from this? My initial thought was to create a joint table, but if we do that, it seems there would be little point in splitting the table in the first place. I’m wondering if there is a standard approach to such problems. Thank you for your help!

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