一段E文：
Incorporate data for speakers, chairs, workshop presenters, exhibitors and delegates attending workshops. Have at least one delegate who has paid for the seminar only. Have at least one delegate who requires details of accommodation. Ensure you can record the special requirements of at least one speaker and one exhibitor. Ensure that the database can distinguish between exhibitors and sponsors. Have a chair linked to a specific session.
Ensure you have identified appropriate relationships and created the relational links between tables - the identification of many-to-many relationships and demonstration of their resolution is expected.
Methods of payment: You should be able to record how the delegates, exhibitors want to pay.
Retrieval of data: You are required to produce forms and reports. You should have created some stored queries which can be run to retrieve the above information.
Ensure it is possible for the database to have data added, for the possibility of new queries to be created.
The report should explain your rationale behind the database structures and how you propose that the database will be used but there is no requirement for it to be a "user manual".
答：先整出个E-R图来(我E文水平不行，按我理解的来哦，错了就改^_^)：
再转换成表：根据教材上的转换规则1、2、3、4，你自己先试试吧
Incorporate data for speakers, chairs, workshop presenters, exhibitors and delegates attending workshops. Have at least one delegate who has paid for the seminar only. Have at least one delegate who requires details of accommodation. Ensure you can record the special requirements of at least one speaker and one exhibitor. Ensure that the database can distinguish between exhibitors and sponsors. Have a chair linked to a specific session.
Ensure you have identified appropriate relationships and created the relational links between tables - the identification of many-to-many relationships and demonstration of their resolution is expected.
Methods of payment: You should be able to record how the delegates, exhibitors want to pay.
Retrieval of data: You are required to produce forms and reports. You should have created some stored queries which can be run to retrieve the above information.
Ensure it is possible for the database to have data added, for the possibility of new queries to be created.
The report should explain your rationale behind the database structures and how you propose that the database will be used but there is no requirement for it to be a "user manual".
答：先整出个E-R图来(我E文水平不行，按我理解的来哦，错了就改^_^)：
再转换成表：根据教材上的转换规则1、2、3、4，你自己先试试吧
