Changes between Version 3 and Version 4 of LogicAndPhysicalDeisgn

Timestamp:

06/23/24 14:55:44 (5 months ago)

Author:

201136

Comment:

--

LogicAndPhysicalDeisgn

@@ -13 +13 @@
 Ingredient(iID, name, calories, protein, carbs, fats)
 
-PersonalizedIngredient(piID, quantity, iID)
+PersonalizedIngredient(piID, quantity)
 
-Workout(wID, duration, name, uID*)
+PersIngrsIsOfType(iID*, piID*)
+
+Workout(wID, duration, name)
 
 Exercise(eID, name, type)
 
-PersonalizedExercise(peID, reps, sets, weight, time, eID*)
+PersonalizedExercise(peID, reps, sets, weight, time)
+
+PersExerIsOfType(eID*, peID*)
 
 WorkoutProgram(wpID, name)
@@ -69 +73 @@
 
 == DDL скрипта за бришење на табелите и креирање на табелите
-[https://develop.finki.ukim.mk/projects/FitnessTrackingApp/attachment/wiki/LogicAndPhysicalDeisgn/kreiranje.sql kreiranjeFinal.sql]
+[https://develop.finki.ukim.mk/projects/FitnessTrackingApp/attachment/wiki/LogicAndPhysicalDeisgn/kreiranje.sql kreiranjeFinal2.sql]
 == DML скрипта за полнење на табелите со податоци
-[https://develop.finki.ukim.mk/projects/FitnessTrackingApp/attachment/wiki/LogicAndPhysicalDeisgn/polnenje.sql polnenje.sql]
+[https://develop.finki.ukim.mk/projects/FitnessTrackingApp/attachment/wiki/LogicAndPhysicalDeisgn/polnenje.sql polnenjeFinal2.sql]
 == Релациски дијаграм изваден од DBeaver
-[[Image(ERdiagramDbeaver.png)]]
+[[Image(ERdiagramDbeaver2.png)]]