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


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

Login to reply

👍?
helpful
11:56pm Tue 1st Oct, Hafiz A.

while checking Depot table for normalization, have following questions - Postcode depends on street address. and street address is linked to DepotID. does this mean there is a transitive dependency here? should I move address to a new table and then link that new table with the Depot table? - There can be one to four phone numbers. as discussed in class lectures, keeping those in same table may result in NULL values and larger database and during the lecture we discussed to move these to a different table. do we apply same approach here to move phone numbers in a different table to make table in 3NF or use the table as it is? same question for Client table Post code / Phone # and Email?



This article has 1 attachment:

 

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