RDBMS database

5 pts.
Tags:
Database
RDBMS
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    We won't do your homework, sorry.

    If you are trying to do it by yourself, and are having problems, tell us what you have tried, and we might give you some tips to help you find the solution.
    69,605 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following