= Relational Design for OPLMS=

== Notation ==

* Primary keys are bolded and underlined.
* Foreign keys are marked with `*` at the end of their name and the referenced entity is written in parentheses.
* Complex attributes are bolded, and their containing attributes are following the, made italic.
* Multivalued attributes have their own table

== Tables ==

1. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')
    __id_user__*

2. **Instructor **(__'''UInstructor_ID'''__, '''Bio''', '''Expertise''')

3. **Administrator **(__'''Admin_ID'''__, '''Admin_Level''')   

4. **Category **(__'''Category_ID'''__, '''Name''', '''Description''')

5. **Course **(__'''Course_ID'''__, '''Name''', '''Price''', '''Status''', __Category_ID__*(Category), __Instructor_ID__*(Instructor))

6. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')

7. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')

8. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')

9. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')

10. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')

11. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')

12. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')

13. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')

14. **USER**(__'''User_ID'''__, '''First_Name''', '''Last_Name''', '''Email''', '''Password''')


=== DDL скрипта за креирање и бришење на табелите ===

[wiki:ddlScript.sql DDL скрипта]

=== DML скрипта за полнење на табелите со податоци ===

[wiki:dmlScript.sql DML скрипта]

=== Релациски дијаграм изваден од DBeaver ===
[[Image(DBeaverExportVer2.png)]]