Wow, Derek what a great link. Thanks very much. Ken
On Friday, May 27, 2016 at 4:47:56 PM UTC+2, Derek wrote: > > There a number of designs for similar situations online; a quick Google > showed me: > > * http://www.databasedev.co.uk/student_courses_data_model.html > * http://databaseanswers.org/data_models/ > > And I am sure there are more... > > If this is your first project. I would not be too fussed about making it > perfect. Try out what seems to work and then iterate as you go. You'll > learn a lot and probably end up having to rewrite based on all your > learning. > > On Friday, 27 May 2016 02:47:34 UTC+2, Ken Edem wrote: >> >> I am new to Django Python and I need bit of help >> >> >> >> Can someone please help me with how I should structure my models, since >> this is a very important part of the project I am trying to develop, I had >> been teaching myself and not yet good at this stuff. I want to develop a >> web project for matching teachers or instructors who will teach students >> who subscribes to our service at they residence.For now I think I will need >> these models: >> >> >> Students = Database to contain all students details. See below for the >> database fields >> >> Instructors = Database to contain all instructors or teachers details. >> See below >> >> Course = Databases for all the courses or services that will be offering >> >> Feedbacks = Database to contains both feedbacks from students about >> teachers and also teachers about students. >> >> >> So, I have done something in terms of normalising my database, but I do >> not think it is efficient enough.? I think I also need a database Class, >> which is combination of Students and Instructors, but I cannot figures what >> the fields of this database should be. >> >> I also think I need a combine database Instructors & Course and Course & >> Students. But I cannot figure out what the fields of these databases also >> should be and what the foreign key or whatever should be. >> >> >> You see, our primary service will be matching students with instructors >> and having these instructors teach student what they want to be thought. >> >> >> Please can someone assist me in structuring my models a structure and >> also should I just have one app or separate apps for students, instructors, >> feedbacks etc. Thanks in advance. >> >> >> Below is my database models. >> >> >> Thanks agains >> >> >> >> >> >> Models and Tables >> >> - Students >> >> - Instructors >> >> - Course >> >> - Feedbacks >> >> - Class >> >> >> Model Properties and Fields >> >> Students >> >> - student-id >> >> - student_firstname >> >> - student_lastname >> >> - student_address >> >> - student_city >> >> - student_region >> >> - student_startdate (immediately, in 2 weeks, in a month over 6 months) >> >> - student_classLocation (student address, instructor address, arrange >> location) >> >> - student_phone1 >> >> - student_email >> >> - student_phone2 >> >> - student_internetContact (skype, viber etc) >> >> - student_days_to_take_classes (mon - sun) >> >> - student_duration_of_course (1 - 12 months) >> >> - student_hours_to_spend_on_course (1 -8 hours) >> >> - student_class_start_time ( 06am - 06am) >> >> - student_course_skill_level (beginner, intermediate, advance) >> >> - student_personal_wishes_to_help_match_an_intructor ( ) >> >> - student_budget_amount >> >> - student_preferred_instructor_gender (male, female) >> >> - student_date_of_birth >> >> >> Students Methods and actions >> >> - match a student to instructors >> >> - seek payment >> >> - message update >> >> >> >> >> Instuctors >> >> - id >> >> - firstname >> >> - lastname >> >> - middlename >> >> - gender >> >> - date_of_birth >> >> - phone1 >> >> - phone2 >> >> - streetaddress >> >> - city >> >> - region >> >> - country >> >> - qualifications (multiple entry) >> >> - certfications (multiple entry) >> >> - degrees (multiple entry) >> >> - present occupation >> >> - previous occupations (multiple entry) >> >> - present job position >> >> - length of teaching skills >> >> - type of skills to teach >> >> - class location (student address, tutor address, arranged address) >> >> >> Instructor Methods and Actions >> >> match instructor to students >> >> seek instructors >> >> pay instructors >> >> - >> >> >> >> Courses >> >> - id >> >> - course_name >> >> - course_description >> >> - course_duration >> >> >> Methods >> >> >> >> Feedbacks >> >> - id >> >> - course_name >> >> - instructor >> >> - student >> >> - Feedback_details >> >> - Grade (Beneficial, Great, Average, Satisfied, Very Satisfied, >> Excellent) >> >> >> >> >> Class >> >> - instructor >> >> - students >> >> - course >> > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/4536e046-eb99-4b23-8e7d-19b13f7b27fd%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
