Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Project management

Authors: Harvey maylor

4th Edition

027370432X, 978-0273704324

More Books

Students also viewed these General Management questions