?
Solved

Database Design

Posted on 2012-03-13
8
Medium Priority
?
394 Views
Last Modified: 2012-06-27
I need to design an ERd for a student teacher scheduler program. The program would let the following to take place :
the teacher would be able to set his office hours
the teaxcher would be able to set free times for meeting students
the student would be able to read teacher meeting time periods and reserve one of them.

what is the best way to design that, how many tables do I need.
0
Comment
Question by:lojayn
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
8 Comments
 
LVL 9

Expert Comment

by:macarrillo1
ID: 37714574
lojayn,  is this a homework assignment?
0
 
LVL 10

Accepted Solution

by:
Derokorian earned 600 total points
ID: 37714823
I would say 4 tables: Students (id, name, whatever else), Instructors (id, name, whatever else), AvailableHours (id,instructor_id,begin available datetime, end available datetime) and Scheduled (available_id, student_id)

HTH
0
 

Author Comment

by:lojayn
ID: 37714998
what about separating the adviser office hours and the meetings time hours in two different tables. If I did so, what is the best design for office hours table. I amthinking if ( instructor_id, Mon_hours, Tue_hours, Wed_hours, Thur_hours)
0
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 
LVL 10

Expert Comment

by:Derokorian
ID: 37715015
That seems like poor database design IMO. Instead you should use something like (instructor_id, day (mon, teus, etc), begin (08:00 for example) and end (13:00 for example)
0
 
LVL 10

Expert Comment

by:Derokorian
ID: 37715036
Then for an instructor you might have 3 rows:
3,Monday,08:00,12:00
3,Wednesday,09:00,12:00
3,Friday,13:00,15:00

This is especially helpful if an instructor has office hours say from 9am to 11am and 3pm to 5pm the same day.
0
 

Author Comment

by:lojayn
ID: 37718229
I apologize, I accepted the wrong solution. How would I fix that
0
 
LVL 10

Expert Comment

by:Derokorian
ID: 37719815
Hey thanks for the points! Hope your question was answered to your satisfaction =D
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question