Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are asked to design a relational database of customer information. Some customer information will not change frequently ( e . g . Gender )
You are asked to design a relational database of customer information. Some customer
information will not change frequently e g Gender and other fields change more
frequently e g date of last purchase Which of the following design considerations
should be avoided? Question options: All of these Maintain separate tables that relate to
each other with a key, where the tables are arranged by the types of business information
product, demographics, etc. Maintain all information in a single table with each row
containing all the information about each customer Maintain separate tables that relate to
each other with a key, where tables that contain frequently updated information are
separated from tables that are less frequently updated. None of these
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