is it possible to create a table from other tables with the following
My goal is to create that table 'Hours' with a say 362 records and
after that to update those records with UPDATE sql commands. That is,
I don't want to INSERT in that table any more records, but just UPDATE
it's existing records only with new or modified informations.
The conditions are as follows.
The resulting table called Hours should look like this:
Columns are: id,date,D,lb,g,c,lp,ld,re
where D is a Day name in Week,
lb is the number of the Lesson Block hour,
g is the grade of a school class,
c is the name of the school class,
lp is LessonPlan,
ld is LessonDiary,
re is Reminder.
Example records would be like this:
where the last three columns have NULL values so far, because later I
want to fill those with informations by using UPDATE sql command.
So in Hours table one or more records could have the same date, Day
name in Week, Lesson Block number, but could have also same grade, and
same class name. Only id is UNIQUE in these records.
For start I will be happy to get the Hours table with proper date and
Day name in Week values out there.
Which date is proper in the Hours table should be determined by
another table in the database. Let this table be called the
However, a date value in Hours table should not be a Sunday date in the Year.
The Semesters table should have the following columns:
In a record of Hours table a date should have the Day name in the Week
which it has in the Calendar, but this behavior can be changed by
another two tables in the database; let these be called the
'TeachingSaturdays' and 'Timetable Exceptions'.
The TeachingSaturdays table should have the following columns:
where the value for date column is definitely a Saturday day date,
and D could be one of these: M, Tu, W, Th, F.
The TimetableExceptions table should have the following columns:
where the value for D column could be one of these: M, Tu, W, Th, F.
Well, I hope I have clearly defined the problem.
Can this Hours table be created with these constraints?