QUESTION $4$

$5$ points

Choose TWO answers that best fits the appropriateness of the following design:

CUSTOMER $($LastName$,$ FirstName, Phone$)$

and

SALE $($InvoiceDate$,$ Invoiceltem, Price, Tax, Total$)$

NOT GOOD. In CUSTOMER, using $($LastName$,$ FirstName$)$ creates a problem because multiple customers can have the same name. Therefore, would violate the rules of a primary key.

GOOD: This is the best design and meets all the functional dependency rules.

NOT GOOD: Everything represented in this design should be in a single table.

NOT GOOD: The primary keys chosen create no issues and do not require a need for a foreign key.

NOT GOOD. In SALE, with InvoiceDate as the primary key there can only be one purchase per day!