Find Jobs
Hire Freelancers

Help with SQL db structure

£10-20 GBP

Completed
Posted almost 6 years ago

£10-20 GBP

Paid on delivery
This is a query, rather than a project but I want good advice so am willing to pay. I'm setting up a database in SQL 2017 and I'm kind of a beginner. I can't figure out how to structure some of the relationships. This is the use case: I have a system consisting of a TV channel list and a number of TV receivers (called 'Players'). The TV Channel list contains 10 channels, but the Players should only show a selection of these channels based on an 'Enabled' bit in a table. For example in the lounge the Player should only have 4 of the channels enabled, in the kitchen the receiver should have 8 enabled. I have a table containing all the TVChannels and I have a table for Players. I need an 'Enabled' value for all the channels on each Player. If I put the 'Enabled' in the TV Channel list it will be global to all Players. If I put the 'Enabled' in the Player table I will only have one row, not one for each player. I'm assuming it needs to go in a table in the middle but can't figure it out. I'd like a complete answer, but you don't need to create the db for me, just a diagram would be handy. Image attached shows what I have so far.
Project ID: 17027729

About the project

43 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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
£10 GBP in 0 day
5.0 (10 reviews)
3.9
3.9
43 freelancers are bidding on average £22 GBP for this job
User Avatar
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..
£18 GBP in 1 day
5.0 (131 reviews)
6.3
6.3
User Avatar
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
£13 GBP in 0 day
4.9 (103 reviews)
5.9
5.9
User Avatar
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.
£23 GBP in 1 day
4.9 (39 reviews)
5.6
5.6
User Avatar
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
£10 GBP in 1 day
4.9 (14 reviews)
5.4
5.4
User Avatar
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
£20 GBP in 1 day
4.8 (47 reviews)
5.1
5.1
User Avatar
A proposal has not yet been provided
£23 GBP in 3 days
4.8 (18 reviews)
4.4
4.4
User Avatar
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.
£10 GBP in 1 day
5.0 (15 reviews)
4.3
4.3
User Avatar
Hello, I am a CS trainer, and available now to show you how to do this kind of relation + proper explanation. Regards
£20 GBP in 1 day
5.0 (9 reviews)
4.0
4.0
User Avatar
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 :)
£13 GBP in 0 day
5.0 (2 reviews)
3.5
3.5
User Avatar
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.
£10 GBP in 1 day
4.9 (12 reviews)
3.0
3.0
User Avatar
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
£44 GBP in 1 day
5.0 (2 reviews)
2.2
2.2
User Avatar
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.
£10 GBP in 1 day
5.0 (1 review)
2.3
2.3
User Avatar
Hi. You're right. You need the middle table. In the theory of databases this is called many to many relationship. Additionally you will need the query for ensure this relationship and solving your task. If you want I can make the database model and write the query for the minimum price. In any case, I'm glad to help with advice. Good luck.
£13 GBP in 10 days
5.0 (2 reviews)
1.9
1.9
User Avatar
hello .. it is very simple.. i can tell you what to do .. i am expert in databases and many other stuff
£13 GBP in 1 day
5.0 (1 review)
2.0
2.0
User Avatar
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
£18 GBP in 1 day
5.0 (2 reviews)
1.1
1.1
User Avatar
A proposal has not yet been provided
£18 GBP in 1 day
5.0 (1 review)
0.4
0.4
User Avatar
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.
£18 GBP in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Ready to do it. We have all required skills. Great expertise in HTML, CSS, JAVASCRIPT, JQUERY, PHP, WORDPRESS and so on. We would provide you daily update so you can know the project status and share your feedback with us. We are ready to long-term and mutually beneficial cooperation.
£18 GBP in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
£222 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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
£13 GBP in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
London, United Kingdom
5.0
5
Payment method verified
Member since Oct 3, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.