3 Modelization
3.1 ER schema
The following decomposition, satisfies Boyce-codd normal form.
3.2 Tables
geographic_correspondance(address_street, address_zipcode, address_city | lat, lon)
address_table(address_name, address_street, address_zipcode, address_city | pmr, blind, deaf)
event_table (event_id | event_url, title, lead_text, event_description, date_start, date_end, cover_url, cover_alt, cover_credit, address_name, address_street, address_zipcode, address_city, price_type, price_detail, access_type, access_link, access_link_text, updated_at, image_couverture, programs, title_event, audience, contact_url, contact_phone, contact_mail, contact_facebook, contact_twitter, address_url, address_url_text, address_text, keyword, group_name, parent_event_id)
occurence(event_id, occurence_date)
tag(event_id, keyword)
transport(event_id, transport_type, transport_line, station | distance)