AFM341 Lecture Notes - Lecture 10: Business Process, Class Diagram, Foreign Key

47 views2 pages

lilacmouse857

28 Jun 2018

School

University of Waterloo

Department

Accounting & Financial Management

Course

AFM341

Professor

Anita patel

For unlimited access to Class Notes, a Class+ subscription is required.

e.g. one person can own many cars. This is a one to many relationship and will be

implemented by foreign keys



One to one relationships will also be implemented with a foreign key

In a one to many relationship, the foreign key is posted toward the "many" side of the

association. e.g. the PK for person is posted in Auto as a foreign key. The PK for state is also

posted in Auto as a foreign key. See table 3-1 for general rules for posting foreign keys

based on the types of association between two classes

Note in figure 3-7, the minimum is 0 for person to auto even if some individuals own

autos. As long as our requirement indicate that some individual may not own an auto,

the minimum is 0

Timing for minimum multiplicities. If an entry in one table must match an entry in another

table, the minimum is 1. if an entry in one table can occur without an entry in the other

table, then the minimum is 0.

Is when the maximum multiplicity is * on both ends of the association, regardless of the

minimum multiplicities

○

Create a new table with the default PK as the combination of the two PK for the associated

tables

○

In figure 3-7, auto can be serviced by many deals and each dealer can service many autos.

Thus "serviced by" association is implemented by creating a new table with a PK that

includes both auto_ID and the dealer_ID (called a concatenated or composite key) shown in

figure 3-8

○

Create new tables to implement many to many relationships4.

AFM 341 Page 5

Unlock document

This preview shows half of the first page of the document.
Unlock all 2 pages and 3 million more documents.

Already have an account? Log in

Document Summary

A. b. e. g. one person can own many cars. This is a one to many relationship and will be implemented by foreign keys. One to one relationships will also be implemented with a foreign key. In a one to many relationship, the foreign key is posted toward the many side of the association. e. g. the pk for person is posted in auto as a foreign key. The pk for state is also posted in auto as a foreign key. See table 3-1 for general rules for posting foreign keys based on the types of association between two classes. If an entry in one table must match an entry in another table, the minimum is 1. if an entry in one table can occur without an entry in the other table, then the minimum is 0. i. Note in figure 3-7, the minimum is 0 for person to auto even if some individuals own autos.

Related Questions

Celestila Moonn, an UMB Global Affairs major student registered for the online Global Financial Markets course. After completing the reading of âAn overview of the Global Financial Marketsâ Moonn stated the following regarding the trends in the growth of global financial markets since the 1990s. The significant growth in foreign financial markets is the result of several factors. First is the increase in the pool of savings in foreign countries (e.g., the European Union). Second, international investors have turned to U.S. and other markets to expand their investment opportunities and improve their investment portfolio risk and return characteristics. This is especially so as the value of public pension plans has declined in many European countries and investors have turned to private pension plans instead. Third, information on foreign investments and markets is now more accessible and thoroughâfor example, via the Internet. Fourth, some U.S. FIsâsuch as specialized mutual fundsâoffer their customers opportunities to invest in foreign securities and emerging markets at relatively low transaction costs. Fifth, while the euro has had a significant effect throughout Europe, it is also having a notable impact on the global financial system. Despite challenges resulting from the Greek (and to some extent the European) debt crisis of the 2010s, the euro is still one of the worldâs most important currencies for international transactions. Finally, deregulation in many foreign countries has allowed international investors greater access and allowed the deregulating countries to expand their investor bases (e.g., until 2012, individual foreign investors faced severe restrictions on their ability to buy Indian stocks). As a result of these factors, the overall volume of investment and trading activity in foreign securities is increasing, as is the integration of U.S. and foreign financial markets. Do you agree or disagree with Moonn? Briefly discuss.

Celestila Moonn, an Global Affairs major student registered for the online Global Financial Markets course. After completing the reading of âAn overview of the Global Financial Marketsâ Moonn stated the following regarding the trends in the growth of global financial markets since the 1990s. The significant growth in foreign financial markets is the result of several factors. First is the increase in the pool of savings in foreign countries (e.g., the European Union). Second, international investors have turned to U.S. and other markets to expand their investment opportunities and improve their investment portfolio risk and return characteristics. This is especially so as the value of public pension plans has declined in many European countries and investors have turned to private pension plans instead. Third, information on foreign investments and markets is now more accessible and thoroughâfor example, via the Internet. Fourth, some U.S. FIsâsuch as specialized mutual fundsâoffer their customers opportunities to invest in foreign securities and emerging markets at relatively low transaction costs. Fifth, while the euro has had a significant effect throughout Europe, it is also having a notable impact on the global financial system. Despite challenges resulting from the Greek (and to some extent the European) debt crisis of the 2010s, the euro is still one of the worldâs most important currencies for international transactions. Finally, deregulation in many foreign countries has allowed international investors greater access and allowed the deregulating countries to expand their investor bases (e.g., until 2012, individual foreign investors faced severe restrictions on their ability to buy Indian stocks). As a result of these factors, the overall volume of investment and trading activity in foreign securities is increasing, as is the integration of U.S. and foreign financial markets. Do you agree or disagree with Moonn? Briefly discuss.

greenjackal65

note: Working managers may complete this exercise based on the practices of their own organizations. Students may complete this exercise based on the practices of a current or previous employer. Instructions 1. Select and describe the boundaries of the system of interest; the term âorganizationâ will be used to refer to this selected system. You may select a team, a department, a small organization (e.g., an office practice), or an entire organization. 2. To familiarize yourself with the criteria, review the section called âCategory and Item Descriptionsâ in the Baldrige Criteria for Performance Excellence available from: www.nist.gov/baldrige/ publications/hc_criteria.cfm 3. The Organizational Assessment Worksheet provides a general description of the criteria category followed by selected questions from the respective 2011â2012 Health Care Criteria for Performance Excellence category. 4. Based on the system selected in question 1, write a brief reply to the selected questions. Briefly describe your organization, including its services; size; geographic community; key patient or customer groups; and current facilities, equipment, and technology, as well as the number of patients or clients it serves. Briefly describe your organizationâs key challenges and your organizationâs current performance improvement system. How do senior leaders deploy your organizationâs vision and values through your leadership system, to the workforce, to key suppliers and partners, and to patients and stakeholders as appropriate? How do senior leaders encourage frank two-way communication throughout the organization? How does your organization conduct strategic planning? Summarize your organizationâs action plans, how they are deployed, and key action plan performance measures or indicators. How do you identify patient, stakeholder, and market requirements for service offerings? How do you build and manage relationships with patients and stakeholders to meet their requirements and exceed their expectations at each stage of their relationship with you? What are your key organizational performance measures? How do you use these data and information to support organizational decision making and innovation? How do you assess your workforce capability and capacity needs, including skills, competencies, and staffing levels? How do you address workplace environmental factors to ensure and improve workplace health, safety, and security? How do you design and innovate your work processes to meet all the key requirements? How do you improve your work processes to improve healthcare outcomes, to achieve better performance, to reduce variability, and to improve healthcare services? Provide data for one key measure or indicator of healthcare outcomes that is important to your patients and stakeholders. Provide data for one key measure or indicator of patient or stakeholder satisfaction. Provide data for one key measure or indicator of financial performance. Provide data for one key measure or indicator related to operational performance. Provide data for one key measure related to achieving legal, regulatory, and accreditation requirements. Prioritizing Improvement Opportunities 1. Review the responses to the organizational assessment questions. 2. Note any questions for which you could not provide a response (i.e., the organization does not have a defined process or approach to address the topic of the question). 3. Review the organizational performance results data. 4. Select one or more measures that demonstrate less than desirable results. 5. Select one item from question 2 or 4 as the performance gap for the performance improvement exercise .

magentachinchilla174

AFM341 Lecture Notes - Lecture 10: Business Process, Class Diagram, Foreign Key

Document Summary

Get access

Related Documents

AFM341 Chapter Notes - Chapter 3: Data Structure Diagram, Entity–Relationship Model, Object Management Group

AFM341 Lecture Notes - Lecture 9: Class Diagram, Social Security Number, Unique Key

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

Related Questions