attribute definitions, for each entity. For each attribute, give its name. an example. an English description of the meaning of this attribute, if it would not be clear to someone from the name and example what the attribute precisely is. whether the attribute is required or optional the basic type (choosing the basic type as in the lab). Use VARCHAR(n) to indicate a string whose maximum length is n and BLOB to represent things like multimedia (sounds, videos, etc.). We will cover these things later in the course. the domain (see textbook). mention (if it is) that the attribute is the identifier for its entity, or is part of of a composite identifier. mention (if it is) that the attribute can be derived (and give hints, or a formula, as to how). mention (if so) that the meaning of the attribute is specified by a particular organization or group. For instance, Canada Post defines the meaning of Canadian postal codes. Few attributes will have this.

weak_WWOOFWORLDMAP wmap destination VARBINARY(45) FK wwal address VARBINARY (45) Commonfarmer commer_name VARCHAR(45) commer_address VARCHAR(45) commer_country VARCHAR(45) commer_phonel INT commer_email VARCHAR(45) commer_{paymentmethod; VARCHAR(45) Rating( host write to wwoofer) diffrate level(levels) INT diffrate_positive VARCHAR(100) diffrate_neutral VARCHAR(100) diffrate_negative VARCHAR(100) FK_host_ids INT FK_fers_ids VARBINARY(45) Indexes WWOFMAINWEBSITE wwod address VARBINARY (45) wwof_searchhost VARCHAR(45) Host host_ids INT host_name VARCHAR(45) host_LANGUAGE VARCHA... host_address VARCHAR(45) host country VARCHAR(45) FK_wwol_address VARBINAR... FK_commer_name VARCHAR... Farming Skills skill_{types) VARCHAR(45) FK_host_ids INT FK_fers_ids VARBINARY(45) Inde Indexes message(host to wwoofer) mess_{Information) VARCHAR(100) FK_host_ids INT FK_ters_ids VARBINARY(45) Self-assessed proficiency level_scale(0 to 3) INT FK_fers_ids VARBINARY(45) FK_host_ids INT message(wwoofer to host) diftmess (information) VARCHAR(100) FK_fers_ids VARBINARY(45) FK_host_ids INT Indexes # WWOOFer ters_ids VARBINARY(45) ters_name VARCHAR(45) fers_ages INT fers gender(male or female) VARCHAR(45) + fers_country VARCHAR(45) FK_wwof_address VARBINARY[45) FK visit ids INT Indexes Visiters visit ids INT visit_name VARCHAR(45) visit_paymethod(visa, debit, paypal,master) VARCHAR(45) visit_address VARCHAR(45) visit_country VARCHAR(45) visit_gendermale or female) VARCHAR(45) visit_datebirth DATETIME visit_ages INT Indexes Portfolios of durable por_(createstuff) VARCHAR(100) FK_fers_ids VARBINARY(45) FK_host_ids INT Indexes Rating(wwppfer write to host) rate_level(levels) INT rate_positive VARCHAR(100) rate_neutral VARCHAR(100) rate_negative VARCHAR(100) FK_fers_ids VARBINARY(45) Fk_host_ids1 INT Indexes Photograph photo_(photos) BLOB Portfolos of durable_por_(createstuff} VARCHAR(100) Portfolios of durable_FK_fers_ids VARBINARY(45) Portfolios of durable_FK_host_ids INT Loghut log_save(photos) BLOB FK photo_{photos) BLOB FK_fers_ids VARBINARY(45) FK_host_ids INT Indexes weak_WWOOFWORLDMAP wmap destination VARBINARY(45) FK wwal address VARBINARY (45) Commonfarmer commer_name VARCHAR(45) commer_address VARCHAR(45) commer_country VARCHAR(45) commer_phonel INT commer_email VARCHAR(45) commer_{paymentmethod; VARCHAR(45) Rating( host write to wwoofer) diffrate level(levels) INT diffrate_positive VARCHAR(100) diffrate_neutral VARCHAR(100) diffrate_negative VARCHAR(100) FK_host_ids INT FK_fers_ids VARBINARY(45) Indexes WWOFMAINWEBSITE wwod address VARBINARY (45) wwof_searchhost VARCHAR(45) Host host_ids INT host_name VARCHAR(45) host_LANGUAGE VARCHA... host_address VARCHAR(45) host country VARCHAR(45) FK_wwol_address VARBINAR... FK_commer_name VARCHAR... Farming Skills skill_{types) VARCHAR(45) FK_host_ids INT FK_fers_ids VARBINARY(45) Inde Indexes message(host to wwoofer) mess_{Information) VARCHAR(100) FK_host_ids INT FK_ters_ids VARBINARY(45) Self-assessed proficiency level_scale(0 to 3) INT FK_fers_ids VARBINARY(45) FK_host_ids INT message(wwoofer to host) diftmess (information) VARCHAR(100) FK_fers_ids VARBINARY(45) FK_host_ids INT Indexes # WWOOFer ters_ids VARBINARY(45) ters_name VARCHAR(45) fers_ages INT fers gender(male or female) VARCHAR(45) + fers_country VARCHAR(45) FK_wwof_address VARBINARY[45) FK visit ids INT Indexes Visiters visit ids INT visit_name VARCHAR(45) visit_paymethod(visa, debit, paypal,master) VARCHAR(45) visit_address VARCHAR(45) visit_country VARCHAR(45) visit_gendermale or female) VARCHAR(45) visit_datebirth DATETIME visit_ages INT Indexes Portfolios of durable por_(createstuff) VARCHAR(100) FK_fers_ids VARBINARY(45) FK_host_ids INT Indexes Rating(wwppfer write to host) rate_level(levels) INT rate_positive VARCHAR(100) rate_neutral VARCHAR(100) rate_negative VARCHAR(100) FK_fers_ids VARBINARY(45) Fk_host_ids1 INT Indexes Photograph photo_(photos) BLOB Portfolos of durable_por_(createstuff} VARCHAR(100) Portfolios of durable_FK_fers_ids VARBINARY(45) Portfolios of durable_FK_host_ids INT Loghut log_save(photos) BLOB FK photo_{photos) BLOB FK_fers_ids VARBINARY(45) FK_host_ids INT Indexes