Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Discuss methods of controlling data integrity for the following relations based on your logical ERD i. The relation which would store all the data for
Discuss methods of controlling data integrity for the following relations based on your logical ERD i. The relation which would store all the data for claims. ii. The relation which would store the data for customers of the organisation What needs to be talked about: Talk about contegraty constraint Default value - A value a field will assume unless an explicit value is entered for that field. - Avoids null values when the user puts nothing. Format controls - Restricts data entry values in specific character positions. Range control - Limits range of values which can be entered into field. Referential integrity - An integrity constraint specifying that the value (or existence) of an attribute in one relation depends on the value (or existence) of the same attribute in another relation. Null value - A special field value, distinct from 0, blank, or any other value, that indicates that the value for the field is missing or otherwise unknown. For the description field: Null Value - Can be Null or Not Null depending on the business' requirements. Default value can be provided. Range: depends on whether this is required by the business. No referential integrity control. Format: depends on business requirements
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started