Detecting the conflict time and date 2

866 512MB

Hi

This is a follow-up post from my post (please click here) as CyberSoftHari suggested me to post it here.

These are the tables that I've made:

Schedules
-ScheduleID
-StartTime
-EndTime
-DayID*
-RoomID*

Day
-DayID
-Day

Room
-RoomID
-RoomName
-Description

Course
-CourseID
-Title
-Description

Sections
-SectionID
-Title
-Description

SectionSemester
-SectionID*
-SemesterID*
-ScheduleID*

Semester
-SemesterID
-Semester

Is it OK or NOT? Any suggestions please...

I tried to other forum, but they said that I you should alter my database design a bit, so that data entered by the user is stored in individual records in a table; then, you can much more easily use SQL to check to see if there is a schedule conflict.

By having a single field containing two pieces of data ('M' 'M/TH', for example,) it makes it extremely difficult to solve the issue using SQL.

Please help? Any suggestions please...

Rey Sean

Dec 4 '07 #1

Subscribe Post Reply

2465

CyberSoftHari

487

Expert 256MB

Is it Exam Time Table schedule?

Nov 11 '13 #2

by: Tim Gaunt | last post by:

Hi, I'm hoping that someone will be able to help me with this one, I'm developing an application which basically inserts a load of data into the database ready for validation at a later date, I...

ASP / Active Server Pages

a2k - simple way of detecting data changes in app

by: Deano | last post by:

In my app I have lots of forms with data presented in various ways using all kinds of controls. Is there a simple way of detecting if the user has changed any data? I would like to do this so I...

Microsoft Access / VBA

javascript popup conflict

by: Caesar Augustus | last post by:

I'm having a problem with two different javascript controls in my app. The first chuck of javascript that I pasted into my app is the client-side calendar control popup which works fine when first...

ASP.NET

Regional Settings conflict

by: Dino M. Buljubasic | last post by:

I am having problems each time I have to deploy my application to some other machine. So far, each time I was having problems because of regional settings, date and time problems. My question is...

Visual Basic .NET

Conflict with short date and default input mask

by: Doug | last post by:

Hi, I created a short date field. The format is dd/mm/yyyy when displayed. The input mask is set to 99/99/00;0 (default, I didn't type anything). If I edit an existing date, say change...

Microsoft Access / VBA

Detecting Conflict Day and Time

by: lotus18 | last post by:

Hello World I have a problem in detecting the conflict schedule (Day and Time). Day 1. M 2. T 3. W 4. TH 5. F

Visual Basic 4 / 5 / 6

How to detect a conflict on schedule?

by: lotus18 | last post by:

Hello all I have these records on my Day Table for my complete database table please click here 1. M 2. T 3. W 4. TH 5. F 6. S

Visual Basic 4 / 5 / 6

Write Conflict when moving to next record

by: MindBender77 | last post by:

Hello all, Using Acc2000, I'm getting a Write Conflict when trying to move to the next record. I have a form that is bound to a table. It has 7 check boxes representing each day of the week and a...

Microsoft Access / VBA

Do Design Patterns conflict with Layered Architecture?

by: DS | last post by:

I'm trying to understand how these two concepts could work together architecturally (if they can.) I realize both concepts provide benefits of re-use and ease of maintenance. Which is important...

PHP

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Detecting the conflict time and date 2

Similar topics