expand icon
book Accounting Information Systems 7th Edition by Cynthia Heagy,Constance Lehmann cover

Accounting Information Systems 7th Edition by Cynthia Heagy,Constance Lehmann

النسخة 7الرقم المعياري الدولي: 978-1111219512
book Accounting Information Systems 7th Edition by Cynthia Heagy,Constance Lehmann cover

Accounting Information Systems 7th Edition by Cynthia Heagy,Constance Lehmann

النسخة 7الرقم المعياري الدولي: 978-1111219512
تمرين 2
Consider the following vendor master file in a relational database:
Vendor Master File
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.
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.
التوضيح
موثّق
like image
like image

a. The projection operation of the datab...

close menu
Accounting Information Systems 7th Edition by Cynthia Heagy,Constance Lehmann
cross icon