Completed

SQL Scripting

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.

Skills: Database Administration, Database Programming, Microsoft SQL Server, SQL

See more: company phil provide sql scripting, sql country states list, virtuemart display default added price without tax, phpbb sql error mysqli field topic_last_post_subject default, sql scripting job, sql scripting outsource, sql server management studio set default formula, sql dump states cities, cheap photographer for 1 hour in new york, create a sql database and create a simple but good looking website where i can access and query the database, delphi ds150e pkw lkw &diagnose interface mit automatischer programmer code reader 2014 hohe qualität 1 jahr garantie mit bluet, forbidden you don t have permission to access index php on this server additionally a 404 not found error was encountered while, forum xda developers com showthread php t 1, http kleinanzeigen ebay de anzeigen s anzeige eheim 2178 professionel 3e thermofilter 600 t top zustand 311506624 138 7703 ref s, freelance t shirt design artist new york, t-1 jayhawk gouge, t-shirts jobs papua new guinea, online t-shirts jobs papua new guinea, t-shirts work papua new guinea, freelance t-shirts jobs papua new guinea

About the Employer:
( 3 reviews ) London, United Kingdom

Project ID: #17785236

Awarded to:

sumon355

Hello, As an expert in SQL, i am very much interested to do this project. Let's discuss more. Note: Simply you need couple of triggers in the 'Room' table for the thing you need to happen and i can do these. T More

£99 GBP in 2 days
(187 Reviews)
7.3

22 freelancers are bidding on average £134 for this job

feninsoftech

Hi, This will be achieved by creating trigger to manage add and delete actions. There will be no code changes required for this as all will be handled by trigger. I have 9 years experience in development and depl More

£133 GBP in 3 days
(43 Reviews)
6.1
octopus823

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.

£150 GBP in 3 days
(6 Reviews)
5.5
fanninson45

INTRODUCTION I can see you are interested in building back-end SQL server queries for your database. I can create your SQL procedures, develop database with other specified business intelligence searches and looku More

£100 GBP in 3 days
(21 Reviews)
5.7
iglobalvn

Hi sir, i have read your requirement carefully. I can do SQL Scripting perfectly and exactly without any risk. If you wanna confirm me, please check my work history and portfolio kindly. Then, you can know about my More

£150 GBP in 3 days
(11 Reviews)
5.5
schoudhary1553

Hello, Hope you are doing well. I can help with your project SQL Scripting. I can assure you the quality job. I have good experience in Database Administration, Database Programming, Microsoft SQL Server, MySQ More

£200 GBP in 3 days
(10 Reviews)
5.1
prakash2813

Hi there, I have strong expertise in database relations, plsql, dynamic queries, pivot tables, umls, normalizations and more. I have read the details and checked attached image for ERD. This is an easy job for me, H More

£200 GBP in 2 days
(17 Reviews)
4.9
creativeitechpvt

let's talk and start

£100 GBP in 2 days
(3 Reviews)
3.8
Gaosong2017

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

£150 GBP in 2 days
(3 Reviews)
3.8
£222 GBP in 5 days
(9 Reviews)
3.6
alexgospodarets

Hi! I have 11+ years of web developing experience. I can promise quality and responsibility. We can start IMMEDIATELY.

£150 GBP in 2 days
(2 Reviews)
2.8
psubramonian

Waiting for your reply. Our Portfolio: =========== - SMP Coderz Technologies : [login to view URL] - iSmartTax : [login to view URL] - Samsung extremo : [login to view URL] - Insider TV : http://in More

£150 GBP in 2 days
(4 Reviews)
2.8
psranjana

Hi, These can be done with triggers written on the required tables. Could you please reach out to me with more details on the structures, data sets and volumes for each table under the scope of the project? Cheers, More

£100 GBP in 3 days
(2 Reviews)
2.4
Proolancer

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

£23 GBP in 3 days
(2 Reviews)
1.6
KGeorgy

Hello, Thank you for the job posting. It’s a pleasure to meet you. I’d really like to work with you on this one if possible! I do have a couple of questions, but first I’d like to make you an offer and some backgrou More

£150 GBP in 3 days
(0 Reviews)
0.0
Malahinian

Hello Hiring Manager, I read your requirements with tasks you have mentioned. Please let me know your best time when we can get on a quick call so we can discuss further on this. Please go through feedbacks give More

£135 GBP in 2 days
(0 Reviews)
0.0
webdroid

Hi , We are expert Scripting scripter ,having 5+ years of professional experience, we will help you to MYSQL Scripting along with 100% satisfactions. Question: 1-What is your specific deadline ? Please visit More

£100 GBP in 4 days
(0 Reviews)
0.0
funsova

Hi ! I read your proposal, You need SQL Scripting for you database. I have have previous experience in building these type of apps. Check our latest work "[login to view URL] More

£100 GBP in 3 days
(0 Reviews)
0.0
sarpilhan

Hello, I have really excited with your project. I want work with you. You will not regret. Thank You

£122 GBP in 10 days
(0 Reviews)
0.0
vb890306

Hi, I am a SQL script expert. I have good experiences in building lots of Sql Query Scripts on database. Well, I have one question. Your database is built by Microsoft SQL Server, or MySQL, or SQL? I'd like to dis More

£150 GBP in 3 days
(0 Reviews)
0.0
£222 GBP in 3 days
(0 Reviews)
0.0