This week I have revisited database design. I had to envision all of the possible fields that would be needed for every sport on the website, and also the relation between the fields. Also things like specifications for each field (e.g. whether it is a number or letter, whether it is unique, if it is a key, and if so, is it a primary or secondary key), if there is an auto-increment etc.) I also am in the process of normalizing the database, which includes assigning foreign & primary keys, and working out table relation types (one to one, one to many etc) and creating intermediate tables.
Advertisement
