> 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?