AFM341 Chapter Notes - Chapter 3: Unique Key, Foreign Key, Business Process

• School: University of Waterloo
• Department: Accounting & Financial Management
• Course: AFM341
• Professor: Brian Ma

Document Summary

Structure models: describe info and data inherent to business processes. Allow communication about database design support design, implementation, use of databases. Data models: show conceptual content of databases to communicate with database users. Class: separate collection of things that company wants information on. Multiplicities: maximum and minimum number of times instances in one class can be associated with instances in another class*** Unique short (cid:272)a(cid:374)"t (cid:271)e (cid:374)ull (cid:272)a(cid:374)"t (cid:272)ha(cid:374)ge over ti(cid:373)e controlled by organization that assigns it sequential! Foreign key attribute(s) that is used to link tables (linked to primary key of another table!) Table 1 primary key is customer id, in table 2 (cid:272)usto(cid:373)er id is li(cid:374)ked to it ((cid:271)ut it"s not that tables primary key!) Business rule: statement of constraint on business process. Allowed: can occur valuable because make modeling business processes easier but things change so so(cid:373)eti(cid:373)es it"s okay to (cid:271)reak (cid:271)usi(cid:374)ess rules.