logo
+1-617-874-1011 (US)
+61-7-5641-0117 (AU)
+44-117-230-1145 (UK)
Live Chat

Implement the constraints in the table

  1. You were asked to implement the following constraints in the table that stores the supplier details:
  • The fields that store the first name, last name, address, and phone number of the suppliers should not be left blank.
  • Phone number must be in the following format:

[0-9][0-9][0-9][0-9]-[0-9][0-9][0-9]-[0-9][0-9][0-9] Example: 4356-555-555

However, while populating the table that stores the supplier details with the sample data, you find that even if you leave the preceding fields blank, no error is displayed. In addition, you are able to populate the field that stores the phone number with any number or character.

Analyze the preceding problem and implement the required constraints in the corresponding table. [5 marks]

  1. While populating the table that stores the order details with the sample data, you find that:
  • The order date should not be greater than the current date.
  • If a user does not enter the order date, the current date should be taken as the default date.
  • The quantity ordered, quantity received, and unit price of the products should be any value greater than 0.

Alter the corresponding table to add constraints so that the preceding requirements can be implemented. [5 marks]

Improve Your Grades with Custom Writing Help
Homework Help
Writing Help
Editing Services
Plagiarism check
Proofreading services
Research Project help
Custom writing services
scanner
E learning blogs

Disclaimer : The study tools and academic assistance/guidance through online tutoring sessions provided by AssignmentHelp.Net is to help and enable students to compete academically. The website does not provide ghostwriting services and has ZERO TOLERANCE towards misuse of the services. In case any user is found misusing our services, the user's account will be immediately terminated.