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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!