Answer to Question #52520 in Databases | SQL | Oracle | MS Access for pankaj debnath
1. You have 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, you find 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. [5 Marks]
2. While populating the table that stores the Issue/Return details with the sample data, you find 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 ta