DAT601 Physical Database Design

The stage which normally comes after the logical design is the physical one. During the physical design we take into account the environment we are building the database for this includes things like correct datatype, what the specific SQL language can do for example nulls and feign keys.

The physical design can also involve rolling back some of the changes we made to during the previous stages to either save space or reduce complexity.

In Milestone three I was important for me to convert my database into a physical form as it was already to complicated to beginning with and needed to to have the number of tables reduced.

I manages to de normalizes some of the table with out effecting to much of the databases functionality.