| Keeping Track of an Interest Group Using Internet Business Logic. | | Based on the presentation ''Designing a User Group Database Using Erwin'' by Frank Palmeri. | Meeting-Presentation PresentationTitle MeetingDateTime -------------- PersonID PresentationComment on this-date-time a presentation entitled this-title by this-personID is scheduled ( this-comment ) ========================================================================================================= 20040302-900 An Environment for Business Rules over SQL, Part 1 AW Introductory 20040302-1000 Designing a User Group Database Using ERWIN FP Use case 20040302-1100 An Environment for Business Rules over SQL, Part 2 AW Use case, continued | MeetingDate ----------- Company Location the presentation on this-date is at this-organization location this-name ================================================================================== 20040302 New York State Dept. of Tax & Finance | Attendance PersonID MeetingDateTime ------------- MeetingRole on this-date-time this-personID attended (or will attend) a meeting in the role of this-role ========================================================================================== 20040302-900 MG attendee 20040302-1000 MG attendee 20040302-1100 MG attendee on some-date-time a presentation entitled some-title by some-personID is scheduled ( some-comment ) ------------------------------------------------------------------------------------------------------- on that-date-time that-personID attended (or will attend) a meeting in the role of speaker | Company-Location Company Name Location ------------- Room Addr1 Addr2 City State Zip Country this-organization location this-name room this-room is at this-addr1 this-addr2 in this-city this-state this-area this-country ================================================================================================================================= Computer Associates Head Office 100 1 Computer Associates Plaza Islandia NY 11749 USA New York State Dept. of Tax & Finance 5 299 Old Niskayuna Road Latham NY 12110 USA | Person PersonID ------------- Salutation LastName FirstName MidInitial Suffix Title LocID EmailFlag EmailPrimary EmailSecondary PhoneNumber PhoneExtension MobileNumber FaxNumber DateAdded Comment CompanyName ID this-person-ID is this-salutation this-first-name this-initial this-last-name this-suffix who works for this-company ============================================================================================================================== AW Dr Adrian - Walker - Reengineering FP Mr Frank - Palmeri - New York State Dept. of Tax and Finance MG Mr Mike - Gorman - Whitemarsh Information Systems ID some-person-ID details : this-title this-locID this-emailflag this-email1 this-email2 this-phone this-ext this-mobile this-fax this-date-added this-comment ================================================================================================================================ AW CTO 06011 emailOK adrianw@snet.net ibl@snet.net (860) 583 9677 - 860 830 2085 860 830 2085 20040101 works on IBL FP VP 12202 emailOK Frank_Palmeri@tax.state.ny.us - (518) 457-0164 - - (518) 457 6860 2000101 President, AEMUG MG CTO 20716 emailOK mmgorman@wiscorp.com - (301) 249-1142 - - - 20020202 See his list posts ID some-person-ID is some-salutation some-first-name some-initial some-last-name some-suffix who works for some-company ----------------------------------------------------------------------------------------------------------------------- a person with ID that-person-ID is in the AEMUG database on some-date-time a presentation entitled some-title by some-personID is scheduled ( some-comment ) some-date followed by some-time separated by a symbol - = that-date-time the presentation on that-date is at some-organization location some-name that-organization location that-name room some-room is at some-addr1 some-addr2 in some-city some-state some-area some-country ------------------------------------------------------------------------------------------------------------------------------ on that-date a presentation is scheduled a person with ID some-person-ID is in the AEMUG database some-date is a possible date for a presentation some-time is a possible time of day for a presentation that-date followed by that-time separated by a symbol - = some-date-time add : on that-date-time a presentation entitled some-title by that-person-ID is scheduled ( some-comment ) ---------------------------------------------------------------------------------------------------------------------- ADD a scheduled presentation entitled that-title by that-person-ID on that-date at that-time with comment that-comment on some-date-time some-personID attended (or will attend) a meeting in the role of some-role some-date followed by some-time separated by a symbol - = that-date-time -------------------------------------------------------------------------------------------- on that-date that-personID attended (or will attend) a meeting some-date is a possible date for a presentation count some-personID : on that-date some-personID attended (or will attend) a meeting = a-number ---------------------------------------------------------------------------------------------- on that-date that-number person(s) attended (or will attend) a meeting this-date is a possible date for a presentation ================================================ 20040302 20040402 20040503 some-time is a possible time of day for a presentation ====================================================== 830 900 930 1000 1030 1100 1130 1200 1230 1300 1330 1400 1430 1500 1530 1600 1630 1700 1730 1800 1830 1900 ID some-person-ID is some-salutation some-first-name some-initial some-last-name some-suffix who works for some-company ID that-person-ID details : some-title some-locID some-emailflag some-email1 some-email2 some-phone some-ext some-mobile some-fax some-date-added some-comment -------------------------------------------------------------------------------------------------------------------------------------- ID that-person-ID name that-first-name that-last-name has 1 emailflag that-emailflag ID some-person-ID is some-salutation some-first-name some-initial some-last-name some-suffix who works for some-company ID that-person-ID details : some-title some-locID some-emailflag some-email1 some-email2 some-phone some-ext some-mobile some-fax some-date-added some-comment -------------------------------------------------------------------------------------------------------------------------------------- ID that-person-ID name that-first-name that-last-name has 2 primary email that-email1 ID some-person-ID is some-salutation some-first-name some-initial some-last-name some-suffix who works for some-company ID that-person-ID details : some-title some-locID some-emailflag some-email1 some-email2 some-phone some-ext some-mobile some-fax some-date-added some-comment -------------------------------------------------------------------------------------------------------------------------------------- ID that-person-ID name that-first-name that-last-name has 3 secondary email that-email2 ID some-person-ID is some-salutation some-first-name some-initial some-last-name some-suffix who works for some-company ID that-person-ID details : some-title some-locID some-emailflag some-email1 some-email2 some-phone some-ext some-mobile some-fax some-date-added some-comment -------------------------------------------------------------------------------------------------------------------------------------- ID that-person-ID name that-first-name that-last-name has 4 phone that-phone ID some-person-ID is some-salutation some-first-name some-initial some-last-name some-suffix who works for some-company ID that-person-ID details : some-title some-locID some-emailflag some-email1 some-email2 some-phone some-ext some-mobile some-fax some-date-added some-comment -------------------------------------------------------------------------------------------------------------------------------------- ID that-person-ID name that-first-name that-last-name has 5 extension that-ext ID some-person-ID is some-salutation some-first-name some-initial some-last-name some-suffix who works for some-company ID that-person-ID details : some-title some-locID some-emailflag some-email1 some-email2 some-phone some-ext some-mobile some-fax some-date-added some-comment -------------------------------------------------------------------------------------------------------------------------------------- ID that-person-ID name that-first-name that-last-name has 6 cellphone number that-mobile ID some-person-ID is some-salutation some-first-name some-initial some-last-name some-suffix who works for some-company ID that-person-ID details : some-title some-locID some-emailflag some-email1 some-email2 some-phone some-ext some-mobile some-fax some-date-added some-comment -------------------------------------------------------------------------------------------------------------------------------------- ID that-person-ID name that-first-name that-last-name has 7 FAX number that-fax ID some-person-ID name some-first-name some-last-name has some-number some-attribute some-value ================================================================================================= | This file is an application written in the language Executable English. | You can view, run and change it by pointing a browser | to www.reengineeringllc.com and selecting AlbanyGroup1.