I've been asked to implement the following constraints in the table that stores the Issue/Return details:
The fields that store MemberID, MemberName, and ItemID should not be left blank.
The date stored in the DateofIssue field should always be less than or equal to the date stored in the DateofReturn field.
However, while populating the table that stores the Issue/Return details with the sample data, I found that even if you leave the MemberID, MemberName, and ItemID fields blank, no error is displayed. In addition, you are able to populate the DateofIssue field with a date greater than the date stored in the DateofReturn field.
Analyze the preceding problem and implement the required constraints in the corresponding table.
While populating the table that stores the Issue/Return details with the sample data, I found that:
The ItemID field should contain unique IDs.
The values stored in the Tariff, AmountPaid and Balance fields should not be less than 0.
Alter the corresponding table to add constraints so that the preceding requirements can be implemented.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!