I have a database consisting of a table of TV channels, a table of audio channels and a table of rooms.
Different rooms need access to different TV channels and audio channels. To detail which channels are allowed and which ones aren't I have tables in between (RoomTVChannel and RoomAudioChannel). Each entry in these tables has a room key, a channel key and a 'ChannelEnabled' value to detail whether the channel is allowed in that room.
The part that's missing it that I need the entries in the RoomTVChannel and RoomAudioChannel tables to be created when a new room is added to the room table, an entry for every channel from the channel tables. When entries are first created they should default to 1 (enabled).
When a room is deleted the RoomTVChannel and RoomAudioChannel entries should be deleted. If a room is updated the change should cascade to the tables.
The only slight difference between the RoomTVChannel and RoomAudioChannel tables is that the TV channel table has a binary value as a channel can only be enabled or disabled but the RoomAudioChannel entry is an integer as it could have a number of different states.
I'm using MS Sql server. Developing on express, production server will be full MS Sql server.
22 freelancers are bidding on average £134 for this job
Hello. I have read your project description carefully. I am very familiar with Writing SQL Procedure. So I can do this job with high quality. Please send me a message so that we can discuss more.
Hello I read your proposal and i am very interested in your job I am expert in Sql, I am sure i can satisfy you in short time I look forward to work with you soon. Best regards
I have 8 years of experience in Database Administration I read and understand your need to make a modification trigger between tables, just contact me to talk more about the script. best regards