smtazulislam
Member
- Local time
- Today, 08:38
- Joined
- Mar 27, 2020
- Messages
- 806
Hi, I want to create a DB for employees room distribution.
In this tblRoomDistribution table I put basic data.
We have 4 Buildings. And each building have 3 Floors with minimum 20 rooms capacity
Each room bed capacity minimum 2 beds.
And
1. Want to search By Building No : How many Room and total employee stayed.
2. Want to search by Room No : How many bed is filled out or empty.
3. Want to search by EmployeeID : Which Building and which numbers of room he stay.
My question:
For this 3 things how can I create table, query and relationship.
I attached DB for redesign data. Need your suggest & support.
anyone can edit field name or Add any new fields.
Any help will appreciate.
In this tblRoomDistribution table I put basic data.
We have 4 Buildings. And each building have 3 Floors with minimum 20 rooms capacity
Each room bed capacity minimum 2 beds.
And
1. Want to search By Building No : How many Room and total employee stayed.
2. Want to search by Room No : How many bed is filled out or empty.
3. Want to search by EmployeeID : Which Building and which numbers of room he stay.
My question:
For this 3 things how can I create table, query and relationship.
I attached DB for redesign data. Need your suggest & support.
anyone can edit field name or Add any new fields.
Any help will appreciate.