This is database technology class and MYSQL database

bill gate is the owner of Innovative Technology Solutions and is in the process of creating a database to support the operation and management of her business. For the past year, she has hired Zac and Lyndon as staff. Her staff has been using a cash register system that collects the following data:

Sale (InvoiceNumber, DateIn, DateOut, Total, Phone, FirstName, LastName).

Unfortunately during rush times, Zac and Lyndon do not enter all the data and there are null values in Phone, FirstName, and LastName. In some cases, all three are null; in other cases one or twoare null. InvoiceNumber,DateIn and total are never null.

To help create bill's database, she purchased a mailing list from a local mailing bureau. The mailing list includes the following data: HOUSEHOLD(Phone, FirstName, LastName, Street, City, State, Zip, Apartment)

Design an updatable database for storing customer and sales data. Explain how to deal with problems of missing data. Explain how you deal with incorrect and name data.

Design a read-only database for storing customer and sales data. Explain how to deal with the problems of missing data?