Changes between Version 3 and Version 4 of Normalization

Timestamp:

07/21/25 23:53:57 (8 days ago)

Author:

221514

Comment:

--

Normalization

@@ -3 +3 @@
 = 1. Functional Dependencies =
 
-Given the ER Diagram:
-
-{{{
-![[Pasted image 20250705104406.png]]
-}}}
-
-And the relational database schema:
-
-{{{
-![[Pasted image 20250705104424.png]]
-}}}
-
-The database can be made so it is represented in exactly 1 relation with all the attributes in it.
+Given the relational schema we already created in earlier sections of this project, the database can be made so it is represented in exactly 1 relation with all the attributes from every relation concatenated together. Of course, duplicates would be removed by doing this which is not a problem.
+
 Let R be the relation just described:
 {{{R(`account_id`, accout_email, person_name, person_surname, password, years_experience, - company_name, company_embg -, - years_experience -, - `vehiche_id`, plate_num, model, brand, capacity, year_manuf -, - `route_id`, days_active -, - `trip_id`, date, status, free_seats -, - time_stop -, - `location_id` , loc_name, latitude, longitude - , - `ticket_id`, time_purchased, date_purchased, two_way, student_disc, child_disc, child_embg, parent_embg -, -`payment_id`, total_price, n_tickets -, - `review_id`,  review_description, rating - `)}}}