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


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

Login to reply

👍x2
helpful
5:38pm Tue 1st Oct, James S.

credit: https://www.cs.uct.ac.za/mit_notes/database/htmls/chp07.html For anyone that was looking at the anonymous superclass inquiry on here.... I found this useful but it probably reinforces the lecture notes. Method 1 All the entities in the relationship are mapped to individual tables. Student (Regno, name) PosGrad (Regno, supervisor) UnderGrad (Regno, points) Method 2 Only subclasses are mapped to tables. The attributes in the superclass are duplicated in all subclasses. PosGrad (Regno, name, supervisor) UnderGrad (Regno, name, points) This method is most preferred when inheritance is disjoint (mutually exclusive) and complete, e.g. every student is either PosGrad or UnderGrad and nobody is both. Method 3 Only the superclass is mapped to a table. The attributes in the subclasses are taken to the superclass. Student (Regno, name, supervisor, points) This method will introduce null values. When we insert an undergraduate record in the table, the supervisor column value will be null. In the same way, when we insert a postgraduate record in the table, the points value will be null.

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