I need help in designing a database for my company, in terms of drawing the layout in ER diagram. There is this table
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.
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.