Hai all,
I need help in designing a database for my company, in terms of drawing the layout in ER diagram. There is this table
Room:
Room_no, Area, No_of_computers,phone,B_Name
B_name is the building name under which the room is, and is the foreign key to the B_name in another table called building.
Building:
B_Name, Code, address,N_Rooms,N_floors

There is this entity that i want to model, one that contains recorded information on temperature, sound and light value for a particular room,(and which is in a particular building).
The attributes that i want are the following:
Room_No, B_Name, Date,Time,Temp,Light,Sound.
I have designed a primary key consisting of the 1st four attributes,
so that we can uniquely identify a temp,light,sound value for a room. I just want to know if this is a weak entity under room entity?
If anyone specializes in drawing ER diagrams for databases, if you can advise me in designing a database for this, i'd be very happy.
Thanks,
Prasath

arun1151-
Do you still need help with the ER diagram for your problem? If so please reply back to this post so that I can make sure I am not spending time solving a problem tha tdoesn't exist anymore. Also, is there any reason you are using ER and not IDEFx1?

__________________
Cheers! Matt
Whitefrog Professional Website Design (fun)
Dream It All - Home Decor, Fountains, Florals, Stone Statues