Having considered how he needs the contact data to be separated into tables and validated, his data structure consists of three tables as shown below.
After considering his validation options, he makes the following decisions.
First_name
and last_name
should not be empty.Address_id
and company_id
should reference records in the appropriate tables. street_1
entry post_code
(regular expression match)street_1
+ post_code
must be valid on creation of the addressA single regular expression is to be used to check and reformat telephone numbers.
Rory is now ready to start the practical steps of building his application.
52.15.176.80