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 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?

Answer 1

1. In the database table in figure 1.12 there is 8 figures.

2. In the database table in figure 1.12 there is 2 fields.

3. Espresso coffee need customer contact no., Locality of street, customer mail id.