Review the sample RentalProperty table below and draw a diagram that meets field

Question

Review the sample RentalProperty table below and draw a diagram that meets field-level integrity, table-level integrity, and relationship-level integrity.

Make sure to do each of the following:

Establish relationships

Define the appropriate deletion rules

Establish and identify the relationship-specific business rules (constraints)

Identify the type of participation for each table

Establish the proper degree of participation for each table RentalProperty (Sample Data)

Apt BldgNumber MonthlyLease Tenancy Bedrooms Bathrooms Sq ft Rental Renter 100 Mark 2000 05/11/2017 2 1500 A 12000 Jefferson 12/05/2012 3 101 Janet White A 12001 1900 2000 04/07/2000 3 1500 102 Robert &Marry; C 13000 2100 Carter 103 Christina B 23000 06/07/2001 3 1500 2100 Lafferty 05/30/2012 2 2080 104 Steve&Nancy; A 12000 1500 Fox

Explanation / Answer

Table Level Integrity = Entity Integrity

Relationship Level Integrity = Referential Integrity

Field Integrity = Domain Integrity

These Fields ensures that every field is sound and it has values that valid , consistent , and accurate.

If it is OK to delete records in a table if its PK is not linked to a FK in another table.

If its PK is linked to a FK in another table,it needs to be ensure that referential integrity is maintained.

The deletion depending makes:
D:R Delete Restrict -Disallow deletion of records
D:C Delete Cascade - Allow deletion of records

Business rules are delete rules and update rules. It is a descriptions of policies, procedures and principles.

types:

1. field level integrity

2. relationship level integrity

3. relationship level integrity

4. field level integrity

5. table level integrity

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.