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 скрипта за креирање и бришење на табелите

DDL скрипта

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

DML скрипта

Релациски дијаграм изваден од DBeaver