Help with SQL db structure

Hi, I'll give you the answer and, if you like, you can pay me afterwards. You actually have another example on your diagram, in the Display table. The principle is the same, you correlate a Room and a Player, and it allows a Player to be in several Rooms and a Room to have Several Players. You can: a) build the same table with the checkbox . b) build the same table without the checkbox, and assume that if there is no record for that Player and Channel then the checkbox is not checked. Hope it helps. Diego

Hello this is a common case for the so called many-to-many relation. To achieve this you would need a separate table containing at least 2 fields: PlayerID and Channel ID..

Hi, I am a developer with vast experience in .NET, MVC, SQL, Java/TypeScript, Angular, PHP available for this project. I am full time freelancer available throughout the day. Best regards Note: This is not an automated bid and I am available right now to discuss your project! Khalid.

Hi, I would like to suggest for keeping the value of "Enabled" for players and TVChannel. Available to start now. please get in touch to discuss more. Regards, Manish

Hi This needs to go into a separate table where both Channel and Player are foreign Keys. Let us assume that you have Channel1 to Channel 10 and Player 1 for kitchen then in this table you will set up Channel 1 Player 1 True / False Channel 2 Player 1 True / False Now you can set up for another player also for all channels. You do not need to pay me as it is not a great effort. Hope it clarifies Thanks Regards Vaidy

Hello, I have been working as an IT BI DWH Professional since last ~ 7 years and have very vast experience around all its 3 layers (ETL, DWH & Reporting) including ER Dimensional Modelling. Below are some key areas of my skills: • Expert in SQL Server, Oracle ,MySql and MS Access Databases • Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools • Expert in ER & Dimension Data modeling • Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries. Always work to provide Best Delivery with 100 % customer satisfaction. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Point5Nyble

A proposal has not yet been provided

Hello, I am a CS trainer, and available now to show you how to do this kind of relation + proper explanation. Regards

Hi, I have read your job post, I'm very interested to work on your project. In last week itself, I have completed one sql script related task so I can give you trust that I can help you very easily. I'm looking forwards to collaborate with you in this project. Thank you, Nikunj.

Hi, good day, Maybe I could help you. I have seen your ER entity, I think you need to relation display with tvchanel and not with player, then you need a relationship between player and room. so , table display will be: (just an example) display_id, room_id, tvchanel_id, is_enabled relation between player and room depends of you project, generally it has to be a middle table room_player id_room_player, id_room, id_player but if you assign a specifics rooms to users, would be in talbe player a field with room id_player, id_room so,when you run a query to get list of chanel first you have to go to room of user, then go to display, then tv chanel, I hope you understant, if you have trouble run the query, let me know I can show you via teamviewer. good luck.

Hello, I am interested in your project, I am a Senior .net Software Engineer with 6+ years of working experience in Software applications full life cycle. your task actually is very easy and simple and the solution for your problem can be done in a minute. I am expert in .Net 4.6, Asp.net, REST / SOAP web services, WCF, MVC 5, JavaScript, JQuery, Asp.net Web API, LINQ, Entity Framework, Amazon MWS, HTML, XML,CSS, PL/SQL. Actually, I am still building my profile here that's why I am offering a low cost, my only concern now is client satisfaction. I hope I can help you and it would be my pleasure to complete and deliver your task.

I've 17 + years experience as a DBA, hire me and I'll give you the answer in 15 minutes - you're right you just need a table in the middle :)

Hello, I would like to take this assignment. I am having 14 years of experience on web development, deployment and project management. Below are my core technical skills •ASP.Net /HTML/CSS/JavaScript/JQuery •C# and VB.Net SOLID Design Principles •MS SQL, AZURE SQL, MySql and non-relational databases like Azure Table storage, Azure Document Db and MongoDb •Entity Framework (Database first, Code first and OData) •Azure Service Bus, N Service Bus and Azure Service Fabric •AWS: EC2/S3/Elastic Beanstalk/RDS/LightSail •Restful API Development (using C#) and deployment on cloud •Team City and Octopus Server for Continuous Integration and deployment •VSS/TFS/GitHub/SVN/Bitbucket/VSO •Agile/Scrum/Kanban/Zendesk •JIRA/Confluence •Unit tests using nUnit and xUnit framework •Integration testing •Acceptance/ Behavioral testing using SpecFlow •API Authentication using JSON web token •JSON format for information exchange •Domain Driven Design (DDD) •Command Query Responsibilities Segregation (CQRS) •Owin Web hosting •QuartzNet for Cron job •SSRS and Crystal Reports •Integration and implementation of Carrier(DHL, UPS, FedEx,TNT) APIs in the ASP.Net application •Integration and implementation of payment gateway(PayPal, PayUMoney) APIs in the ASP.Net application Working on tools like: Zendesk, Autofac, AutoMapper, SeriLog, Elastic-Search, Kibana, RoboMongo, RabbitMQ, TopShelf Looking forward for further discussion and to start. Best Regards

hello .. it is very simple.. i can tell you what to do .. i am expert in databases and many other stuff

You need a third table where it will only reside Channel ID from the first table and receiver ID from the second table. Receiver with id 2, will have four columns in the third table for examle

A proposal has not yet been provided

Hello, This is in response to your job notification for the position of Professional for your project. I have been working as a developer for the last 6+ years with a software firm and mentioned below are some of my achievements in this role: - Designed and developed a conversion plan for 100+ Uniface modules into equivalent Java/J2EE. - Managed a project team developing a Java/MySQL based web application/Window Application - Converted a user based web application to a Java/J2EE application for better performance. I’m well versed with: - Designing database architecture and server scripting - Studying and establishing connectivity with network systems, search engines, and information servers. - Developing knowledge and understanding of the technical environment including program compilation, file structures and program interfaces in the Java EE environment. I have a full understanding of Designing and development of Java Technology. Expertise in JSP/Servlet/Collection/JDBC , Framework - Spring/Hibernate, API -iText/POI/iPerf, Database(Oracle/MySQL/ PostgreSQL/MongoDB), Should you need any more details, please do let me know. Thanking you for your time and looking forward to hear from you. Regards Vivek

I am very experienced on modeling databases, from small to expressive companies. We can talk about modifications on your primary idea more flexible and dynamic to changes in specifications.

A proposal has not yet been provided

Hello client, I will help you to solve this small problem. I have worked and interacted with databases for quite a while ranging from SQL server to Oracle. I will assist you in just a day and all will be well. Your considerance will be highly appreciated.

I have work on numerous database project in the past, in my last job I usually have to create reports on the fly from Microsoft SQL and MySQL servers