Answered step by step
Verified Expert Solution
Question
1 Approved Answer
QUESTION 4 5 points Choose TWO answers that best fits the appropriateness of the following design: CUSTOMER ( LastName , FirstName, Phone ) and SALE
QUESTION
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!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started