Employee job status(Free or not freee)

[updatesvc]

I am making a database for work employees.The employees are given jobs that last between | DateofBegining| and |Date of completion| In the job table.Other attributes in the Table are |Doneby(Employee Id)| , |JobID| etc. I want to to know which employees are free on a particular date . How do i go about this. Please help.

[orange]

This info may be helpful

[updatesvc]

Thanks Orange but thats a bit difficult to understand.All the same i am looking at overlapping records on the internet

[orange]

Tell us about your table(s) and relationships.

You have Employees and Tasks

Tasks have a StartDate and EndDate.

Employees are "busy"/"Not free" on StartDate and EndDate and all intermediate dates.

I did put up a sample involving Room reservations --- a room is not free(for reservation) if it is currently occupied.

[updatesvc]

Thanks a lot for the help.
The hotel Room reservations example cleared up things.Thank you.In case i have any other questions i will post them THANKS

[updatesvc]

@ orange Please Help
What if an employee can have a maximum of 4 Jobs/Task at the same time.In your example what if a room can be booked 4 times(At the same time, however the booking dates can vary Start and end Dates). The 4 Jobs can have different time durations overlaping other jobs for the same employee. I would like a query using your booking's(Hotel reservation DB). That displays rooms that don't have reservations equal to 4 or more.(My jobs last more than a day, use the first data base without the [time]attribute)

[updatesvc]

By the way here is an example of my database. Can you help write a query to display employees(Carpenter_No) that have jobs less than 4 and also display the number of their current jobs.NB:Their jobs overlap in time jobStartDate is the same as |Date_of Order| and jobEndDate is the same as |Date_of_completion|.

2.Also a query to display employee|(Carpenter_no)| who have jobs more than 4 and also display the number of their current jobs.

[orange]

What exactly does this database represent? Please describe in plain English what your business is.

In overview it appears you have a number of employees -carpenters. Some of which are temporary and some of which are permanent. It also appears that you have Customers who create Orders. It would seem that the carpenters design/build some Item(s) that the Customers order, but that isn't explicit in your post.

I suggest you work through this tutorial from RogersAccessLibrary. You will learn a process to build a data model that supports your business.

For more info on Normalization.

For a series of videos related to the generic, Customer, Order, OrderDetail, Item, please see these links.


http://www.youtube.com/watch?v=IiVq8M5DBkk Logical data modeling

http://www.youtube.com/watch?v=BGMwuOtRfqU Candidate key

http://www.youtube.com/watch?v=ZiB-BKCzS_I Normalization

http://www.youtube.com/watch?v=pJ47btpjAhA Normalization example

http://www.youtube.com/watch?v=q3Wg2fZENK0 1st Normal form

http://www.youtube.com/watch?v=vji0pfliHZI 2nd Normal form

http://www.youtube.com/watch?v=HH-QR7t-kMo 3rd Normal form

http://www.youtube.com/watch?v=q1GaaGHHAqM E_R Diagramming

https://www.youtube.com/watch?v=lXAG...6FE5448948D9B4 E-R Diagramming Price and Quantity

Complete set of tutorials on Acc2010.
https://www.youtube.com/playlist?lis...FoilxbUY0yUqZP

Good luck.

[updatesvc]

Thanks alot.This tutorials helped me.May god bless you.