Chat with AI
Core Concepts of Accounting Information Systems 12th Edition by Carolyn Strand Norman, Mark Simkin
Edition 12ISBN: 9781118022306Core Concepts of Accounting Information Systems 12th Edition by Carolyn Strand Norman, Mark Simkin
Edition 12ISBN: 9781118022306 Exercise 10
Souder, Oles, and Franek LLP (Data Modeling with REA) Souder, Oles, and Franek LLP is an international consulting firm headquartered in Chicago, Illinois. The E-R diagram in Figure 3-20 shows a simplified version of the company's process for purchasing and paying for equipment and supplies. ![Souder, Oles, and Franek LLP (Data Modeling with REA) Souder, Oles, and Franek LLP is an international consulting firm headquartered in Chicago, Illinois. The E-R diagram in Figure 3-20 shows a simplified version of the company's process for purchasing and paying for equipment and supplies. Requirements 1. Insert appropriate cardinalities for the relationships in the E-R diagram developed with the REA data modeling approach. 2. Describe the database table attributes for this model. You will need a table for each entity, as well as one or more relationship tables. Identify first the table name, then indicate the primary key by underlining it. Show any foreign keys by framing them in brackets (e.g., [Vendor #]). Include at least three fields in each table. Below is an example for the Vendor table and the Order Goods table: Vendor #: Name, Street Address 1, Street Address 2, City, State, Zip Code, Phone Number, E-mail, Fax, Contact, Comments. Order #: Date, [Vendor #], [Employee #], Shipping Instructions, Comments](https://storage.examlex.com/SM1589/11ec7ce8_aa9a_79aa_9798_873d263abba0_SM1589_00.jpg)
Requirements
1. Insert appropriate cardinalities for the relationships in the E-R diagram developed with the REA data modeling approach.
2. Describe the database table attributes for this model. You will need a table for each entity, as well as one or more relationship tables. Identify first the table name, then
indicate the primary key by underlining it. Show any foreign keys by framing them in brackets (e.g., [Vendor #]). Include at least three fields in each table. Below is an example for the Vendor table and the Order Goods table: Vendor #: Name, Street Address 1, Street Address 2, City, State, Zip Code, Phone Number, E-mail, Fax, Contact, Comments. Order #: Date, [Vendor #], [Employee #], Shipping Instructions, Comments
Requirements1. Insert appropriate cardinalities for the relationships in the E-R diagram developed with the REA data modeling approach.
2. Describe the database table attributes for this model. You will need a table for each entity, as well as one or more relationship tables. Identify first the table name, then
indicate the primary key by underlining it. Show any foreign keys by framing them in brackets (e.g., [Vendor #]). Include at least three fields in each table. Below is an example for the Vendor table and the Order Goods table: Vendor #: Name, Street Address 1, Street Address 2, City, State, Zip Code, Phone Number, E-mail, Fax, Contact, Comments. Order #: Date, [Vendor #], [Employee #], Shipping Instructions, Comments
Explanation
Verified
Verified
Entity relationship diagram:
1. The fol...
Core Concepts of Accounting Information Systems 12th Edition by Carolyn Strand Norman, Mark Simkin
Why don’t you like this exercise?
Other Minimum 8 character and maximum 255 character
Character 255
