To jest stara wersja strony!


Projekt logiczny [In Progress]

Doprecyzowanie struktury bazy

Słowniki danych

  1. address
    • id
    • street
    • house_number
    • flat_number
    • town
    • postal_code
    • post_office
  2. cars
    • id
    • registration_number
    • brand
    • model
    • colour
    • year
    • examination_date
    • insurance_date
    • category
    • distance
  3. categories
    • category_code
    • category_name
  4. courses
    • id
    • start_date
    • type
    • practical_training
    • theoretical_training
  5. driving_lessons
    • id
    • student_id
    • instructor_id
    • start_time
    • end_time
    • course_id
    • status
    • distance
    • car_id
  6. employees
    • id
    • nip
    • account_number
  7. groups
    • id
    • name
    • desc
  8. instructors
    • user_id
    • account_number
  9. internal_exams
    • id
    • student_id
    • course_id
    • type
    • result
    • date
    • instructor
    • errors
  10. parameter_groups
    • id
    • name
    • order
  11. parameters
    • name
    • desc
    • type
    • value
    • group_id
  12. payments
    • id
    • amount
    • date
    • student_id
    • accepted_by
    • status
    • due_date
    • description
  13. payments_status
    • id
    • description
  14. roles
    • name
    • desc
  15. roles_groups
    • role_name
    • group_id
  16. status
    • id
    • name
  17. student_categories
    • student_id
    • category_code
  18. student_courses
    • course_id
    • student_id
    • medical_certificate
    • instructor
    • certificate_number
    • end_date
  19. students
    • user_id
  20. theoretical_lessons
    • id
    • course_id
    • instructor_id
    • subject
    • date
    • hours
    • class
  21. users
    • id
    • username
    • pass_sha256
    • pass_salt
    • code_sha256
    • email
    • phone
    • mobile
    • status
    • first_name
    • last_name
    • pesel
    • birth_date
    • nationality
    • home_address
    • mailing_address
    • register_date
    • last_login_date
  22. users_groups
    • user_id
    • group_id
  23. users_roles
    • role_name
    • user_id

Analiza zależności funkcyjnych i normalizacja tabel

Denormalizacja struktury tabel

Projektowanie operacji na danych

pl/dydaktyka/ztb/2011/projekty/osk/logiczny.1311900947.txt.gz · ostatnio zmienione: 2019/06/27 15:57 (edycja zewnętrzna)
www.chimeric.de Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0