60 347
Assignments Done
98%
Successfully Done
In April 2018

Answer to Question #52520 in Databases | SQL | Oracle | MS Access for pankaj debnath

Question #52520
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
Expert's answer

Not answered

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be first!

Leave a comment

Ask Your question

Submit
Privacy policy Terms and Conditions