Question Roster HELP

[hisheeraz]

Hello Guys,
I am here writing a programme and I need to creat a roster for the cars and drivers driving those cars at any given day for up to seven day.

My head is spinning and I just cannot figure out how to do it.

can any any one out there help me ho to design that roster.

thanks. shiraz

 

[Knvn]

You can design the tables like below:

Cars					        Drivers
--------------------------		--------------------------
CarID | Name | OtherFields...		DriverID | Name | OtherFields...


Schedule
------------------------------------	
FromDate | ToDate | DriverID | CarID

1. You can add the new cars to 'Cars' table and drivers to 'Drivers' table.
2. Set the schedules on 'Schedules' table.
3. For a given day, you can make the query to 'Schedule' table.

 

[hisheeraz]

hi my friend thanks for your reply
i have finished design and implementation phase for cars and drivers,
now working on schedule/roster i donot know how can i design that and implement that design
with a code.
thanks again. appreciate your post. cheers

 

[Knvn]

--> For the 'Schedule' table, 'DriverID' and 'CarID' are the foreign keys.
--> You can insert new cars to 'Cars' table and drivers to 'Drivers' table independently.
--> When you are creating new schedule, insert a record into the 'Schedule' table depending upon which driver will drive which car from which date which date.

* Now by making query to the 'schedule' table, you can identify:
--> Which car is engaged for which date.
--> Which driver is engaged for which date.
--> For a given date you can identify, who will drive which car on that date.

I think by knowing the intention of these tables you can write the code.

 

[hisheeraz]

hey kvn thaks my friend,
i am on to the code now, hopefully i should have something to show you by the end of the weekend and will waits for your comments anxiously,
many thanks regards
shiraz