Draw a dependency diagram to show the functional dependencies in the relation. Decompose the relations into a set of 2NF. Then produce the final 3NF relations. For each step discuss your reasoning and why you have chosen the 2FN/3FN relations. Manually drawing the dependency diagram, or the set of 3NF relations is NOT acceptable.
Looking for an expert Azure Data Engineer to assist with multiple tasks. Your responsibilities will include: - Implementing and managing Azure Data Lake and Data Ingestion. - Developing ...utilize these platforms to achieve three main objectives: - Perform sophisticated data analysis and visualization. - Enable advanced data integration and transformation. - Build custom applications to meet specific needs. Candidates should have an advanced understanding of Azure Data Lake, Power BI, and Powerapps, bringing a minimum of 6 years experience as Databricks. Proficiency in Python, SQL, PostGre SQL, and Pyspark is also required. Knowledge of GitHub and the CI/CD Process will be beneficial for this role. If you have the skills and expertise needed for this project, I'd ...
I am in need of a skilled freelancer who can help me with my personal SQL database project. The main task involves editing a syntax. In order to perform this task effectively, you should: - Have extensive knowledge and experience working with SQL databases. - Be proficient in storing, retrieving, and analyzing data. - Provide an effective solution to the specified problem related to syntax editing. Only those who are experts in database administration and adept at problem solving are encouraged to bid. Being able to address this issue promptly is vital. Looking forward to hearing from you.
Project Overview: "MicroBizBoost" is a SaaS platform designed to provide ultra-small business owners with affordable, automated marketing tools that allow them to promote their business and sell products. The platform will include features such as an automated website builder, social media management, email marketing, basic SEO tools, digital advertising assistant, and a repository of educational resources. In addition, the platform would need vital business tools such as invoicing capabilities and a general CRM platform. Detailed Technical Requirements: Frontend Development: • Proficiency in React.js for building a dynamic, interactive user interface. • Experience with HTML5, CSS3, and modern JavaScript ES6+. • Familiarity with frontend development tools ...
...maintainable code and resolve software defects and issues up-to-date with the latest .NET technologies and best practices Requirements: 1. Proven experience as a .NET developer 2. Strong proficiency in C# and the .NET framework 3. Experience with ASP.NET, MVC, Web API, and other related technologies with front-end technologies such as HTML, CSS, and JavaScript 5. Knowledge of SQL Server or other relational databases 6. Excellent problem-solving and communication skills How to Apply: Please submit your proposal with the following information: relevant experience as a .NET developer. of previous projects showcasing your skills. hourly rate or project-based pricing. 4. Your availability and estimated time to complete the project. Note: We are looking
I am looking for a nutritionist app built in Laravel that includes the following features: - Client management: ability to add and assign clients to nutritionists - Calendar integration: syncing with external calendars and the ability to schedule appointments - Financial tracking: keeping track of payments and expenses...schedule appointments - Financial tracking: keeping track of payments and expenses For the calendar integration, I have specific requirements, including: - Reminders controlers for the apointments and notifications. Ideal skills and experience for this project include: - Proficiency in Laravel framework - Experience in building and integrating calendar features - Knowledge of financial tracking - SQL The App i already in development and we need to add some new...
I am looking for a PHP web developer who can quickly complete a project within a week. Skills and Experience: - Proficiency in PHP - Familiarity with Laravel, Symfony, or CodeIgniter frameworks - Strong understanding of web development principles and best practices - Experience working with databases and SQL - Ability to work efficiently and meet deadlines The project may involve working with existing code or starting from scratch, depending on the client's requirements. If you are a skilled PHP web developer who can deliver high-quality work within a tight deadline, please apply for this project.
I am looking for a skilled .NET developer to work on my defined project for a duration of 1-3 months. The project requires expertise in C#, ASP.NET, and SQL Server. Specific requirements for the project include: - Developing and implementing ASP.NET web applications using C# - Integrating SQL Server for database management and data retrieval - Collaborating with the team to design and develop efficient and scalable solutions - Testing and debugging code to ensure functionality and performance - Providing ongoing support and maintenance as needed Ideal skills and experience for this job include: - Proficiency in C#, ASP.NET, and SQL Server - Strong knowledge of web development principles and best practices - Experience with front-end technologies such as HTML, CSS, a...
...Administration, Cloud Architecture, and Cybersecurity. I'm seeking a qualified Python and SQL instructor who can teach me how to use these languages for practical applications in my current role. - You will help me learn how to use Python and SQL for: - Data analysis and reporting - Automation of repetitive tasks - Database management - Training should specifically cover applications of Python and SQL in: - Network monitoring and analysis - Configuration management - Log Analysis and reporting Please, note that I'm a beginner. Therefore, the course needs to start from the basics and gradually ramp up to more advanced concepts. Ideal candidates will have a strong background in Python, SQL, and IT, as well as experience...
Looking for a Power BI and SQL expert who can assist me with data analysis and visualization, report creation, and dashboard design. The ideal candidate should have experience in query optimization and performance tuning. I require assistance specifically during the time period of 12 AM to 5 AM IST. No specific deadlines have been mentioned for this project.
I need an expert in ABAP and HANA sql to help me coding bind variables. SAP recommended us to switch our WHERE clause to BIND VARIABLES. [Removed by Admin] We are going to work it together on a live call. Payment is hourly.
Hi, I'm looking for a web app developer to create a web app for my existing site (built with Wordpress). The w...Interactive graphic capabilities: the projects that users collaborate on will be interacted with via a dynamic interface - Ideally the web app will be mobile-friendly, but this is not essential, especially in the early stages. Ideal skills and experience: - Strong experience in web app development, specifically with Javascript - Understanding (and ability to explain/teach) how JS links to Wordpress/HTML, SQL (for business logic), and how to maintain/tinker with the system - Knowledge of user login and registration functionality - Familiarity with responsive design principles is a plus, but not required - Ability to suggest and implement a visually appealing design ...
Node JS Hosting on Google Cloud Platform I am looking for a developer who can help me with hosting my exist...Node JS Application: Yes Database: Node JS Skills and Experience Required: - Experience with Node JS hosting on the Google Cloud Platform - Strong knowledge of Google Cloud Platform and its services - Familiarity with deploying and managing Node JS applications - Understanding of database management in a Node JS environment, specifically NoSQL databases like MongoDB or Firebase - Knowledge of SQL databases like MySQL or PostgreSQL is a plus - Ability to troubleshoot and resolve any issues related to hosting and deployment on the Google Cloud Platform If you have the expertise and experience in Node JS hosting on the Google Cloud Platform, please feel free to reach out. ...
...for text data. Uncertainty persists about whether to use SQL database for storage, so your expertise is needed. The ideal candidate will have: - Proven experience with data repository creation. - Comprehensive understanding of data types, particularly text data. - Expertise in helping clients to choose the best database for their needs. In this case, helping me decide whether to go with SQL for text data storage. - Familiarity with various data format structures. While there's a preference for SQL, this is not set in stone. This project will require you to: - Develop a structure uniquely suited to storing text data. - Provide expert advice on the most suitable form of database for this type of data - we are currently considering SQL. - Ensure the sele...
I require a proficient and experienced CodeIgniter + Python developer to bring my vision of a new website/application to life. 1. CodeIgniter Tasks - Front-end development: Create intuitive and user-friendly interfaces. - Back-end development: Ensure the seamless operation and integration of various functionalities. - Database management: Implement and manage a secure and efficient database system. 2. Python Roles - Data analysis: Extract insights from provided data sets to guide website development. - Web scraping: Acquire necessary information from different sources to enrich content. Expected Skills & Qualifications - Proficiency and demonstrated experience in CodeIgniter, Python, and SQL. - Good knowledge and experience in data analysis and web scraping. - ...
I am looking for help to create a local containerized environment (docker-compose) of our existing LAMP website at so can effectively have a local development environment. Containerized components to include are apache, mysql, php, phpmyadmin Website is running on the following version components Apache Version: 2.4.57 PHP Version 5.4.45 MySQL Version 5.5.62 Will provide you with database sql file to import and the app files of the website
Azure MS SQL Having High I/O Utilization. There are two unwanted processes that need to be killed. Conditions: 1. Issue to be resolved on my device remotely. 2. Complete knowledge sharing on successful completion 3. Payment on successful completion of task. Success Criteria 1. I/O Utilization to become normal below avg 20% 2. Removal of two processes Spid:64 & 65.
I'm in need of a Tableau and SQL specialist who can guide me through the creation of a KPI dashboard based on revenue vs target data. While I have intermediate knowledge of the software, specific assistance is required in building a clear, informative visualization of my company's revenues growth rate. This involves not just creating a standard dashboard, but really getting into the depth of what Tableau and SQL can offer. The ability to work collaboratively and communicate complex data in a comprehensible manner is vital. Ideal skills and experiences: - Advanced expertise in Tableau and SQL - Prior experience with sales data visualization - Exceptional skills in interpreting and showcasing KPI data - Proven ability to teach or guide others. (Videos and vid...
I'm in urgent need of a highly-skilled Full Stack Developer experienced in Laravel framework. The successful candidate will be tasked with executing key improvements to my website including: - Front-end and back-end development: We want the entire UI and the server side to be developed and improved, making it more interactive and efficient. - Database integration: This involves storing, retrieving and using data from our server. We require someone proficient in SQL and can comfortably work with large datasets. - API integration is essential. You will connect reusable resources with applications and devices. Knowledge in RESTful API is preferred. Hence, experts in Laravel with the ability to manage front-end and back-end development along with database and API integrati...
I require an experienced Flutter expert who can integrate a Federated Learning model into my project. Below are the specific needs: - Machine Learning integration using the Federated Learning model - You'll be expected to train a new model for this task - We'll be providing you with structured data, primarily from Excel spreadsheets and SQL databases The perfect freelancer for this job would ideally hold the following skills: - Proficient in Flutter framework - Experience in Machine Learning (specifically Federated Learning) models, and their integration - Expertise in handling and analysing structured data for the training of machine learning models Your ability to provide assistance, strategies and methods regarding the training and integration process will be highly...
I am looking for a freelancer who has strong skills in SQL, Python, and Business Intelligence. The main goal of utilizing Business Intelligence in this project is to improve decision making. The specific tasks that I need help with are query optimization in SQL and data analysis in Python. Ideal skills and experience for this job include: - Strong knowledge and experience in SQL query optimization - Proficiency in Python for data analysis - Familiarity with Business Intelligence concepts and tools - Ability to write complex SQL queries - Attention to detail and ability to extract and transform data efficiently If you have expertise in these areas and are ready to take on this project, please submit your proposal.
As the driving force behind our project, you'll be responsible for creating a modern and sleek online code compiler. Not only should this tool be aesthetically pleasing, but it also needs to be functional and user-friendly. You'll be required to: - Implement support for diverse programming languages that include (but are not limited to) Python, C++, C, SQL, and Java. - Incorporate key features such as a code sharing feature and debugging tools, taking account of our drive for a collaborative and user-friendly platform. Ideally, you're an experienced developer versed in the programming languages specified and have a keen eye for design. We value creativity and innovation, thus we’re interested in individuals who can offer fresh perspectives and ideas. Profici...
I am looking for a freelancer who can help me integrate my Java code into Oracle Database 11 using PL/SQL. The purpose of this integration is to call the Java code for external API integration. Skills and Experience: - Proficiency in Java Stored Procedures - Strong knowledge of Oracle Database 11 and PL/SQL - Experience with external API integration - Ability to set up the environment for the integration The ideal candidate should be able to assist me in setting up the environment for this integration as well.
I am looking for a freelancer who can assist me with asset/facilities management tasks for my project. The ideal candidate should have experience in spatial data analysis, asset/facilities management, and 3D visualization. Preferred Skills and Experience: - Strong knowledge and experience in asset/facilities management - Proficiency in spatial data analysis and 3D visualization - Expertise in PostgreSQL database management system - Experience with data integration services Project Requirements: - Assist in managing assets and facilities within the project - Perform spatial data analysis to optimize asset/facilities management - Create 3D visualizations for better understanding and presentation of assets and facilities - Utilize PostgreSQL as the preferred database management system - Int...
Project Title: Custom-built E-commerce Website Development I am looking for a skilled web developer to create a custom-built e-commerce website for my business. The website should be professional, user-friendly, and visually appealing. Requirements: - Develop a custom-built e-commerce website from scratch - Implement a secure payment gateway for online transactions - Integrate inventory management system for efficient product management - Ensure seamless navigation and intuitive user experience - Optimize the website for mobile responsiveness - Implement search engine optimization techniques for better visibility on search engines Ideal Skills and Experience: - Proficiency in web development languages such as HTML, CSS, and JavaScript - Experience in b...
...a graph. Sorting and Searching Algorithms: Implement quicksort or mergesort. Write an algorithm for binary search. Find the kth largest element in an unsorted array. Dynamic Programming: Find the longest increasing subsequence in an array. Compute the minimum path sum in a grid. Solve the 0/1 knapsack problem. Databases and SQL Queries: Write a SQL query to find the second highest salary. Design a database schema for a given problem statement. Optimize a given SQL query. Solution Design: Design a parking lot system using object-oriented principles. Propose a data model for an e-commerce platform. Outline an approach to scale a given algorithm for large datasets. Big Data Technologies (if applicable): Basic questions on Hadoop, Spark, or other big data tools. Ho...
Hi, I am seeking a skilled .NET developer to assist me with an ASP.NET project. This project involves working with existing code and requires someone with experience in ASP.NET. The ideal candidate should have a strong understanding of the ASP.NET framework and be able to work with ADO.NET. The project is expected to be long term and having knowledge of SQL Server. Freelancer and Team both are welcome. Looking forward. Dipak
...am looking for a highly skilled developer with a deep knowledge in backend development and Flutter. Ideal Skills: • Backend Development • Flutter Framework • SQL Database Management Your primary focus will be on the development of the real-time data synchronization feature. The ideal candidate would have significant experience with SQL database technology. This project will involve bringing the concept to life by applying your advanced understanding in both backend development and Flutter. This is an exciting opportunity to work on a dynamic and innovative project where your expert skills in Flutter, backend development, and SQL will be vital. I look forward to partnering with a knowledgeable individual who can see this project through to completi...
I am looking for a Oracle Netsuite Advanced Reports Functional expert who can assist customers with creating variety of reports. Must have at least 3 strong years of Netsuite functional and active expertise knowing how to create, updating criteria and filters for both saved search and financial GL reports. Must be very strong with SQL formulas and custom fields. Scripting is a plus to have as some requests to use saved searches may require scripting to handle actions on transaction records. WE HAVE ALOT OF PROJECTS..MUST BE ABLE TO BE AVAILABLE ON SOME WEEKENDS TOO. Ideal Skills and Experience: - Strong knowledge and experience in Netsuite financial reports and Saved Searches - Ability to understand and meet specific requirements for the reports - Familiarity with various re...
What's up friends, The project is about configuring a Mikrotik with OpenVPN. SCENERY: Current Firewall: Endian Server (Remote Access): With certificate problems and quite old. There are 2 locations: - The 1st office has a SQL server, and all the PCs on the network connect to this server. - Headquarters 2 is only a warehouse, they connect to headquarters 1 through L2L. WANTED: - Change the physical endian server for a Mikrotik with Firmware v13. (Already in possession and ready to configure.) This change job would be on my side. - Configure the OpenVPN service on the Mikrotik - Generate what is necessary to be able to connect through laptops that are outside the headquarters. Through this VPN. - Consider Firewall rules and protection in the configuration. - Consider that the ...
I'm in need of an experienced programmer who can guide me to improve my skills in reactJS with redux. Using .Net core with SQL as the preferred database, I'm on an intermediate level of programming and my primary goal is to enhance my skills. Key Features: - Expansive hands-on training sessions focused on real-world applications and examples. Skills and Experience Required: - Expert knowledge of reactJS, redux, and .Net core is essential. - Extensive experience with SQL database. - Experience in creating and implementing educational curriculums or training programs. - Excellent communication and interpersonal skills, needed for effective teaching. - Ability to cater lessons to varying levels of understanding and skills.
We need a web app with c# and asp.net that places addresses in a private Google Maps, stored in SQL server and that when the icon is clicked, more information about that event is shown. CREATE TABLE [dbo].[Locations]( [StreetName] [nvarchar](100) NULL, [StreetNumberFrom] [nvarchar](10) NULL, [StreetNumberTo] [nvarchar](10) NULL, [Obs] [nvarchar](80) NULL, [TypeIcon] [nvarchar](50) NULL ) ON [PRIMARY] GO There will be different types of icons.
...build a database to track client assets in over 1000 stores. The main purpose of this database is to manage customer data. I am open to suggestions regarding the type of database and preferred platform or technology to use. Ideal skills and experience for this job include: - Database development experience - Proficiency in relational databases and NoSQL databases - Knowledge of Microsoft Access, SQL Server, and other database platforms - Ability to design and implement a database to track client assets in multiple stores - Strong attention to detail and ability to ensure data accuracy - Problem-solving skills to troubleshoot and resolve any database-related issues If you have experience in building databases and are open to suggesting the best approach for this project, I would...
I need a form to save several data. That data needs to be accessed by the date and viewed on the webpage. The data needs to be saved by SQL and access in an Excel local file.
I am looking for a skilled Oracle database designer and SQL expert to help me with my project. The main purpose of the database is to process sales transactions. Requirements: - I have a detailed specification for the database design, so attention to detail is crucial. - The SQL queries are expected to have high complexity, so experience in handling complex queries is necessary. Ideal Skills and Experience: - Strong expertise in Oracle database design and SQL. - Ability to understand and implement detailed specifications. - Experience in handling high complexity SQL queries. If you have the required skills and experience, please submit your proposal. Thank you!
Exciting project opportunity for a skilled Full Stack Developer, who is well versed in: - JavaScript - React - API - SQL We are looking for a skilled Full-Stack Developer with a strong background in .NET Core API, Postgres, SQL query optimization, ReactJS, and TypeScript. The ideal candidate should have a minimum of 3 years of hands-on experience in web development, and be passionate about creating efficient, high-quality software solutions. Key Responsibilities: Develop, maintain, and optimize .NET Core APIs and back-end systems to meet business requirements. Design and implement efficient database schemas using Postgres, and write complex SQL queries to extract and manipulate data. Collaborate with front-end developers to build interactive and user-friendly web ap...
...also preferably use our whatsapp API to also send a message via whatsapp. The message will include pdf link + QrCode to install the eSIM. Its ok to use a digital product app from the spotify store to deliver the PDF and QrCode image. Our projects use: C# , , Shopify digital product sales, mobile phone eSIM sales, 1.5, Bootstrap 3.0, ag-grid, Ionic framework, Font Awesome MS SQL 2017, webAPI MVC, ASP.NET, Kendo Controls, and all work is delivered via Gitlab Key Responsibilities: You will be working under and have the orientation and help of our project manager to do mostly back end work creating new and also improving existing functionalities of our project. This is for ongoing long term development and we will start with some short sprints to be delivered in 2-3 days
Hello, I want parse this website and give me all page with clean html/css/js I try save source but in source many code and it's not worked like live website so I want someone who can give me page like clean code.
Hello, I need Microsoft SQL Server Mgt Studio query for a large dataset 1,000,000's of rows, which - only looks at the rows with the latest revisions (identifable by a revision no); - and for this latest data, sums selected fields to aggregate the data - and applys the above for a selected subset (region) and from date A sample (dummy) dataset and more detailed requirements is provided/attached (excel)
I am seeking an SQL expert with significant experience in SQL Server and data analysis. This project involves the management of personal data requiring precision and security. You will need: - Demonstrable experience with SQL Server. - Experience handling personal sensitive data. - Proven track record of executing data analysis operations. The key task will be to extract insights from substantial personal information datasets. The qualified freelancer will need to demonstrate in-depth knowledge and experience with SQL Server, data analysis, and handling personal data. Strict adherence to data privacy rules is compulsory.
Seeking a database developer adept in creating a user-friendly, star rating system for my website. This will allow users to review and rate companies. Requirements for this project are: * Development of a database to be integrated into an existing website. * Set up a star rating system through which users can rate companies. * Establish categories for rating - I've left this open for discussion, so expertise in creating impactful categories is appreciated. * Star rating should visibly translate into results, displayed out of a total of 5. Consideration will be leaned towards those with experience in developing interactive databases and user rating systems. Advanced skills in programming languages such as SQL, PHP, Python or Ruby are a huge plus. Looking forwa...
I am looking for a developer who can help me convert specific PayPal transaction data to SQL in a DevExpress XAF XPO application using C#. The ideal candidate for this project should have experience with C# programming, DevExpress XAF XPO, and SQL database management. Specific requirements for this project include: - Converting PayPal transaction data, including Transaction ID, Amount, and Customer Information, to SQL format - Working with a relational database structure - Completing the project within a timeline of less than 1 month If you have the necessary skills and experience, and can meet the specified timeline, please submit your proposal. Thank you.
Hello, I want parse this website and give me all page with clean html/css/js I try save source but in source many code and it's not worked like live website so I want someone who can give me page like clean code.
Ho la necessità di utilizzare un software personalizzato che si appoggia a Microsoft SQL. Sui nuovi MAC Chip M non è possibile installare Microsoft SQL per cui è necessario utilizzare Docker Desktop che deve essere configurato per far funzionare il mio software in ambiente Windows 11 ARM. La configurazione standard di Docker, effettuata dai tecnici Parallel, non è sufficiente per installare un localhost sul quale appoggiare il mio software. L'obiettivo è far ripartire il mio software. Il progetto sarà assegnato se si riesce a riattivare il mio software
I am looking for a developer who can help us create internal database, write api queries to automate extracting data from suppiers and sales platform, and create apps using Retool. Experience in Postgre...queries to automate extracting data from suppiers and sales platform, and create apps using Retool. Experience in PostgreSQL, JavaScript, and structuring database schema will help me with a project. The primary goal is to establish a functional database connected with API for automated workflows. The timeline for the project is flexible. Ideal Skills and Experience: - Storng proficiency in Postgre SQL and JavaScript - Experience with database schema development - Experience with Retool app development - Knowledge of workflow automation techniques - Ability to work within flexible...
I'm in need of a SQL expert who can quickly resolve an issue I'm having with incorrect results from my queries. I'm not entirely sure which database management system I'm using, so a solid background in multiple systems such as MySQL, Oracle, and PostgreSQL would be ideal. I require immediate attention, as I need the project completed as soon as possible. This job requires: - Strong SQL skills, with experience in troubleshooting and resolving issues - In-depth knowledge of different Database Management Systems - Excellent problem-solving and attention to detail - Ability to explain complex issues in simple terms. Your prompt response is much appreciated.
...building customer-centric software products · Analyze existing software implementations to identify areas of improvement and provide deadline estimates for implementing new features · Develop software applications using technologies that include and not limited to core Java (11+ ), Kafka or messaging system, Web Frameworks like Struts / Spring, relational (Oracle) and non-relational databases (SQL, MongoDB, Hadoop, etc), with RESTful microservice architecture · Implement security and data protection features · Update and maintain documentation for team processes, best practices, and software runbooks · Collaborating with git in a multi-developer team · Appreciation for clean and well documented code · Contribution to databas...
I am looking for an experienced Oracle Forms and Reports 11g developer to assist with an intermediate level project. The project has no specific timeline and requires expertise in handling intermediate complexity tasks. Skills and Experience Required: - Proficiency in Oracle Forms and Reports 11g - Strong understanding of database management and SQL - Ability to work independently and meet project requirements - Experience in developing intermediate level projects using Oracle Forms and Reports 11g - Attention to detail and ability to troubleshoot and debug code If you have the necessary skills and experience, please submit your proposal.
I am looking for a freelancer who can assist with the maintenance and repairs of my Microsoft Access SQL server. The specific tasks that I need help with include database optimization and we have an error 3464 for mismatched information in "booking Notifications". the database contains Credit card information so it is safety sensitive. The size of my database is less than 1 GB. I already have a backup plan in place for my database but it will need to be updated/merged if repair can not be implemented in a short period of time. Ideal Skills and Experience: - Strong knowledge and experience in Microsoft Access SQL server maintenance - Expertise in database optimization - Familiarity with query optimization - Experience with data migration would be...
