Question: You are a database developer for XYZ Games working with the development team on a new online gaming store. Read the list of constraints and
You are a database developer for XYZ Games working with the development team on a new online gaming store. Read the list of constraints and the business requirement carefully and then answer the question at the end.
Constraints: primary key, foreign key, unique, not null, or check constraint
Business Requirement:
Good Morning I just got off the phone with the software developers and they want us to prevent any records from being inserted into the customer table if they are missing the customers name and the date of birth. Their application logic requires the customers name and their date of birth is needed to determine if they are old enough to purchase games based on the games ESRB. Can you alter the customer table to reflect this business logic real quick before we push it back out to the developers for testing on GitHub? The software developers are putting in their own constraints at the application level but we are still migrating users over from the recent merger so we need to catch any missing data during the nightly imports.
Thanks,
Janet Senior Database Developer
XYZ Games
Which of the listed constraints need to be added to the customer table in order to meet the specific business requirement from Janets email?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
