Chat with AI
Accounting Information Systems 7th Edition by Cynthia Heagy,Constance Lehmann
Edition 7ISBN: 978-1111219512Accounting Information Systems 7th Edition by Cynthia Heagy,Constance Lehmann
Edition 7ISBN: 978-1111219512 Exercise 2
Consider the following vendor master file in a relational database:
Vendor Master File
Required:
a. What database operation(s) would you perform on the table if you want to create a new table with just the name of the vendors and their outstanding balances? Draw the new table.
b. What database operation(s) would you perform on the table if you want to create a new table with the name and current balance of the vendors whose current balances are more than $4,000? Draw the new table.
Vendor Master File
Required:
a. What database operation(s) would you perform on the table if you want to create a new table with just the name of the vendors and their outstanding balances? Draw the new table.
b. What database operation(s) would you perform on the table if you want to create a new table with the name and current balance of the vendors whose current balances are more than $4,000? Draw the new table.
Explanation
Verified
Verified
a. The projection operation of the datab...
Accounting Information Systems 7th Edition by Cynthia Heagy,Constance Lehmann
Why don’t you like this exercise?
Other Minimum 8 character and maximum 255 character
Character 255
