Changes between Version 1 and Version 2 of BuildBoardF6

Timestamp:

07/08/25 00:03:38 (6 days ago)

Author:

221071

Comment:

--

BuildBoardF6

@@ -219 +219 @@
 property_title, property_description, created_at
 
-R12.1 {property_id, user_id, property_type_id, address_id, property_title, property_description,
+**R12.1** {property_id, user_id, property_type_id, address_id, property_title, property_description,
 created_at} - не е во 3НФ
 R12.1 не е во 3НФ поради:
@@ -225 +225 @@
 • address_id → street, municipality, city, number, country
 • user_id → first_name, last_name, email, password_hash, date_of_birth, rating, bio
-R12.1.1 {property_type_id, property_type_name} - во BCNF
-R12.1.2 {address_id, street, municipality, city, number, country} - во BCNF
-R12.1.3 {user_id, first_name, last_name, email, password_hash, date_of_birth, rating,
+
+**R12.1.1 {property_type_id, property_type_name} - во BCNF
+
+**R12.1.2 {address_id, street, municipality, city, number, country} - во BCNF
+
+**R12.1.3 {user_id, first_name, last_name, email, password_hash, date_of_birth, rating,
 bio} - во BCNF
-R12.1.4 {property_id, user_id, property_type_id, address_id, property_title,
+**R12.1.4 {property_id, user_id, property_type_id, address_id, property_title,
 property_description, created_at} - во BCNF
+
 Во R12.2 остануваат сите атрибути кои ги нема во претходните релации.
-R12.2 - {property_image_id, payment_id, maintenance_log_id, inspection_id, document_id,
+
+**R12.2** - {property_image_id, payment_id, maintenance_log_id, inspection_id, document_id,
 message_id, unit_image_id, tenant_profile_id, property_id, unit_id, listing_id, lease_id,
 landlord_profile_id, unit_number, floor, bedrooms, bathrooms, area_sq_m, unit_rent_amount,
@@ -240 +245 @@
 R12.2 не е во 3НФ бидејќи unit_id → unit_number, floor, bedrooms, bathrooms, area_sq_m,
 unit_rent_amount, property_id.
-R12.2.1 {unit_id, unit_number, floor, bedrooms, bathrooms, area_sq_m,
-unit_rent_amount, property_id} - во BCNF
+
+**R12.2.1 {unit_id, unit_number, floor, bedrooms, bathrooms, area_sq_m,**
+**unit_rent_amount, property_id} - во BCNF**
+
 R12.2.2 {property_image_id, payment_id, maintenance_log_id, inspection_id, document_id,
 message_id, unit_image_id, tenant_profile_id, unit_id, listing_id, lease_id, landlord_profile_id,
 listing_title, available_from, available_to, listing_status, listing_description, start_date, end_date,
 lease_rent_amount, deposit_amount, managed_properties_count, is_agent}
+
 R12.2.2 не е во 3НФ бидејќи listing_id → listing_title, available_from, available_to,
 listing_status, listing_description, unit_id
-R12.2.2.1 {listing_id, listing_title, available_from, available_to, listing_status,
+
+**R12.2.2.1 {listing_id, listing_title, available_from, available_to, listing_status,
 listing_description, unit_id} - во BCNF
-R12.2.2.2 {property_image_id, payment_id, maintenance_log_id, inspection_id, document_id,
+
+**R12.2.2.2** {property_image_id, payment_id, maintenance_log_id, inspection_id, document_id,
 message_id, unit_image_id, tenant_profile_id, listing_id, lease_id, landlord_profile_id,
 start_date, end_date, lease_rent_amount, deposit_amount, managed_properties_count,
 is_agent}
-R12.2.2.2 не е во 3НФ бидејќи landlord_profile_id → managed_properties_count, is_agent
-R12.2.2.2.1 { landlord_profile_id, managed_properties_count, is_agent } - во BCNF
-R12.2.2.2.2 { property_image_id, payment_id, maintenance_log_id, inspection_id, document_id,
+
+**R12.2.2.2** не е во 3НФ бидејќи landlord_profile_id → managed_properties_count, is_agent
+
+**R12.2.2.2.1 { landlord_profile_id, managed_properties_count, is_agent } - во BCNF
+
+**R12.2.2.2.2** { property_image_id, payment_id, maintenance_log_id, inspection_id, document_id,
 message_id, unit_image_id, tenant_profile_id, listing_id, lease_id, landlord_profile_id,
 start_date, end_date, lease_rent_amount, deposit_amount}
@@ -262 +275 @@
 R12.2.2.2.2 не е во 3НФ бидејќи lease_id -> start_date, end_date, lease_rent_amount,
 deposit_amount, listing_id, tenant_profile_id, landlord_profile_id
-R12.2.2.2.2.1 {lease_id, start_date, end_date, lease_rent_amount, deposit_amount,
+
+**R12.2.2.2.2.1 {lease_id, start_date, end_date, lease_rent_amount, deposit_amount,
 listing_id, tenant_profile_id, landlord_profile_id} - во BCNF
-R12.2.2.2.2.2 { property_image_id, payment_id, maintenance_log_id, inspection_id,
+
+**R12.2.2.2.2.2 { property_image_id, payment_id, maintenance_log_id, inspection_id,
 document_id, message_id, unit_image_id} - во BCNF
-Финални релации во BCNF
-1. Property_Image {property_image_id, property_image, property_id} - во BCNF
-2. Payment {payment_id, amount, payment_status, payment_date, lease_id,
+
+== Финални релации во BCNF
+1.** Property_Image** {property_image_id, property_image, property_id} - во BCNF
+
+2.** Payment** {payment_id, amount, payment_status, payment_date, lease_id,
 payment_method_id} - во BCNF
-3. Maintenance_Log {maintenance_log_id, maintenance_description, maintenance_date,
+
+3.** Maintenance_Log** {maintenance_log_id, maintenance_description, maintenance_date,
 service_request_id} - во BCNF
-4. Inspection {inspection_id, inspection_date, notes, lease_id, landlord_profile_id} - во
+
+4.** Inspection** {inspection_id, inspection_date, notes, lease_id, landlord_profile_id} - во
 BCNF
-5. Document {document_id, file_type, file_url, uploaded_at, user_id, lease_id} - во BCNF
-6. Message {message_id, sent_at, content, from_user_id, to_user_id, lease_id} - во BCNF
-7. Unit_Image {unit_image_id, unit_image, unit_id} - во BCNF
-8. Tenant_Profile {tenant_profile_id, user_id} - во BCNF
-9. Property_Type {property_type_id, property_type_name} - во BCNF
-10. Address {address_id, street, municipality, city, number, country} - во BCNF
-11. User {user_id, first_name, last_name, email, password_hash, date_of_birth, rating, bio}
-- во BCNF
-12. Property {property_id, user_id, property_type_id, address_id, property_title,
+
+5.** Document** {document_id, file_type, file_url, uploaded_at, user_id, lease_id} - во BCNF
+
+6.** Message** {message_id, sent_at, content, from_user_id, to_user_id, lease_id} - во BCNF
+
+7.** Unit_Image** {unit_image_id, unit_image, unit_id} - во BCNF
+
+8.** Tenant_Profile** {tenant_profile_id, user_id} - во BCNF
+
+9.** Property_Type** {property_type_id, property_type_name} - во BCNF
+
+10.** Address** {address_id, street, municipality, city, number, country} - во BCNF
+
+11** User** {user_id, first_name, last_name, email, password_hash, date_of_birth, rating, bio}- во BCNF
+
+12.** Property** {property_id, user_id, property_type_id, address_id, property_title,
 property_description, created_at} - во BCNF
-13. Unit {unit_id, unit_number, floor, bedrooms, bathrooms, area_sq_m, unit_rent_amount,
+
+13.** Unit** {unit_id, unit_number, floor, bedrooms, bathrooms, area_sq_m, unit_rent_amount,
 property_id} - во BCNF
-14. Listing {listing_id, listing_title, available_from, available_to, listing_status,
+
+14.** Listing** {listing_id, listing_title, available_from, available_to, listing_status,
 listing_description, unit_id} - во BCNF
-15. Lease {lease_id, start_date, end_date, lease_rent_amount, deposit_amount, listing_id,
+
+15.** Lease** {lease_id, start_date, end_date, lease_rent_amount, deposit_amount, listing_id,
 tenant_profile_id, landlord_profile_id} - во BCNF
-16. Landlord_Profile {landlord_profile_id, managed_properties_count, is_agent} - во BCNF
-17. Payment_Method {payment_method_id, payment_method_name} - во BCNF
-18. Service_Request {service_request_id, service_description, request_date,
+
+16.** Landlord_Profile** {landlord_profile_id, managed_properties_count, is_agent} - во BCNF
+
+17.** Payment_Method** {payment_method_id, payment_method_name} - во BCNF
+
+18.** Service_Request** {service_request_id, service_description, request_date,
 service_status, lease_id, service_category_id} - во BCNF
-19. Service_Category {service_category_id, service_category_name} - во BCNF
-20. Main_Relation {property_image_id, payment_id, maintenance_log_id, inspection_id,
+
+19.** Service_Category** {service_category_id, service_category_name} - во BCNF
+
+20.** Main_Relation** {property_image_id, payment_id, maintenance_log_id, inspection_id,
 document_id, message_id, unit_image_id} - во BCNF
-21.Interested {listing_id, tenant_profile_id} - во BCNF
+
+21.** Interested** {listing_id, tenant_profile_id} - во BCNF