Changes between Version 6 and Version 7 of Normalization

Timestamp:

09/29/25 18:27:03 (2 weeks ago)

Author:

221514

Comment:

--

Normalization

@@ -424 +424 @@
 
 All resulting tables are in BCNF - and we may further semantically infer other tables that are present in the ER schema, but the core tables that have many attributes present in them are confirmed to exist and adhere to the design of the ER diagram.
+
+Now we can list the final relevant and core tables derived as a result from these normalization steps:
+
+R11: `Account`
+    (account_id, acc_email, person_name, person_surname, password, years_experience)
+
+R12: `Company`
+    (company_embg, company_name)
+
+R2: `Vehicle`
+    (vehicle_id, plate_num, model, brand, capacity, year_manuf)
+
+R3: `Trip`
+    (trip_id, date, status, free_seats, route_id)
+
+R4: `Route`
+    (route_id, days_active)
+
+R5: `Location`
+    (location_id, loc_name, latitude, longitude)
+
+R51: `Ticket`
+    (ticket_id, two_way, student_disc)
+
+R52: `Child_Ticket`
+    (child_embg, child_disc)
+
+R6: `Payment`
+    (payment_id, total_price, n_tickets, time_purchased, date_purchased)
+
+R7: `Review`
+    (review_id, review_description, rating)
+