Question: please help me do it CHAPTER 1 ACCOUNTING SYSTEM INSIGHTS 17 Field H G B A STATE ZIP CUSTOMER No LAST NAME FIRST NAME COMPANY


please help me do it
CHAPTER 1 ACCOUNTING SYSTEM INSIGHTS 17 Field H G B A STATE ZIP CUSTOMER No LAST NAME FIRST NAME COMPANY NAME STREET ADDRESS CITY 1 54911 Appleton WI 13 Joseph Ave 127127 Ashuer Angela 2 Record 56100 Tuscany Pisa 58 Dante 913691 Pico EspressoBar Vincent Customer FIGURE 1.12 Fields and Records How many fields do you see in Figure 1.12? How many records are in Fiqure 1.12? CTION OF RELATED RECORDS A database table is a collection Note that the address is 1.30 Look at the CUSTOMER table for EspressoCoffee appearing in Figure 1.12. Can you an- swer the following questions? (Q1.3) 1. How many fields do you see in the database table in Figure 1.12? 2. How many records do you see in the database table? 3. Are there any other fields that you would recommend that EspressoCoffee add to the CUSTOMER table? Is there any additional information that EspressoCoffee might need about customers
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
