Mysql information retrieval jobs

I'm seeking a proficient Node.js Backend Developer to assist with two core tasks in my project: designing the database schema and implementing API e...project: designing the database schema and implementing API endpoints. Designing the Database Schema - I'll require your expertise to design an optimized and scalable database schema. The database in use for this project is MySQL. Implementing API Endpoints - I also need your assistance to implement API endpoints using a RESTful architecture. You should have sound knowledge and experience in designing and developing RESTful APIs. The ideal freelancer for this project should have: - Solid experience working with Node.js - Profound knowledge of designing database schemas in MySQL - Extensive experience in implemen...

...develop a modern and minimalistic presentation mainly aimed at sharing information with the general public. Key Requirements: - The PowerPoint design should lean towards minimalism and be current, aligning well with modern design principles. - The presentation requires a great balance of simplicity and appeal as the target audience is the general public. Thus, it needs to be easily understood and visually engaging. - Expertise in designing professional, clear, and engaging PowerPoint presentations. Ideal Skills & Experience: - Previous experience in creating PowerPoint presentations for mass information dissemination purposes. - Proven track record in minimalist design approach. - Ability to effectively communicate information in a simple yet engaging manner....

I need a skillful freelancer to create a couple of professionally designed PowerPoint slides to present conceptual information. The slides must adhere to a formal and executive style, focusing on simplicity and professionalism. The purpose of these slides is to effectively communicate information, not persuasion or education. Therefore, clarity and coherence are key. Ideal skills and experience: - Proficiency in PowerPoint. - Experience in creating executive-style presentations. - Ability to communicate concepts clearly and effectively. - Excellent visual design skills. - Attention to detail. - Knowledge in business and formal document design would be a plus. Please, include examples of previous work of a similar nature in your bid. Looking forward to witnessing your c...

I'm in immediate need of a talented web developer who can assist me with my project on an urgent basis. Proficiency in HTML, CSS, Java, PHP, MySQL or equivalent is desired. The candidate should have a knack for web development and should be able to deliver quickly. Key Requirements: - Excellent knowledge in HTML, CSS, Java, PHP, MySQL - Quick turnaround - Previous experience in web development Speed is of the essence, therefore, a candidate who can begin immediately will be preferred. Looking forward to your bids.

I'm looking for an expert to set up Docker Swarm using Linux and connect to my MySQL database. The key details and requirements for the project are: - Edition: The version I'm interested in is Docker Swarm Mode. - Connection: I need a direct connection to the MySQL database - OS: The operating system in use is Linux. Ideal Skills: - Docker - Docker Swarm - Linux - MySQL - Networking Experience: The successful freelancer will have a strong background in setting up Docker Swarms on a Linux operating system and connecting them to MySQL databases. Their understanding of networking should include the ability to establish a direct connection with the database. The optimal candidate will have a knowledge of Docker Swarm Mode specifically. I am open to ...

More details: What is the purpose of the website? A dating service website written via PHP & MySQL, based on CRM. Responsive to mobile displays. A sample site in Chinese characters is here: I can provide the login information of aboved sample site, as an user only, no admin account available. Basically I need a website just like this one, some features needed to be added or modified. What information should successful freelancers include in their application? Experience How soon do you need your project completed? 1-2 weeks

I'm searching for a skilled chatbot developer who can create a text-based chatbot focused on information retrieval. Most of the code is written by me. However, I am having trouble at the question answering stage of the bot. All the steps for implementing RAG search is already done and the data is already prepared. The purpose of this chatbot is to deploy it in the future on my personal website. In that case, I would like it to be integrated either with streamlit or gradio, up to you!

...version of Cloudflare. Must know how to configure AWS server (lowest cost, optimised, secure). Re server I have been told that mine would be better with Linux upgrade: - “PHP upgrade from 7.2 to 8.1 - Installation of web server nginx, apache would be removed. There should be no reason to use apache and nginx should show better performance. - Installation of elasticsearch. - Installation of MySql 8, MySql 5 would be removed” so would need someone who understands this or has expertise in configuring the server. I need someone who has a good idea of SEO changes i.e. if SEO team need some changes done to the site, need developer to know how to complete them. Site speed is super important so any change/ work needs speed of site taken into account. Most importa...

...specifics were not outlined, further details of what the API is required to do will need to be discussed - this includes tasks such as data retrieval and storage, user authentication and authorization and web service integration. The main purpose of the Laravel API could range between facilitating data communication between different systems, creating and managing RESTful endpoints, to handling user requests and responses. Additionally, there is a possibility that the Laravel API might need to interact with external databases or third-party services. Ideal Skills and Experience Required: • Comprehensive knowledge of Laravel API • Experience in data retrieval and storage systems • Proficiency in user authentication and authorization • Proficiency in ...

<Overview> Please collect product information on vehicles or service information that have or will have the technologies described in the “Technology Description” section below. <Technology Description> This technology acquires a state of locking and unlocking of a vehicle that is locked and unlocked based on instruction information acquired within a valid period of authentication from a portable terminal, and transmits a notification to a delivery management server when the vehicle is not locked during a period of time from when the vehicle is unlocked based on the instruction information until a first timing that arrives after the valid period of the authentication expires. This technology also transmits a notification to the deliver...

Hi Elite Information Tech, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I need an experienced developer to implement MySQL database management using Python. The selected professional will utilize the python connector 'mysql-connector-python' to establish a connection with the database and do two tasks of a project. The database management includes: - Creating an efficient system design - load, extract and manipulate the data Key skills required for the job include: - Strong Python programming skills - expertise in SQL and specifically working with MySQL databases - Experience with 'mysql-connector-python' - Knowledge of data management best practices Previous work with user data management would be a plus.

I am looking for a proficient and experienced web scraper to scrape items and images from ...br/arte-indigena/?mpage=25 * Additionally, scraping images associated with each product. The structure of the product titles on the website is a single sentence. So, the scrapping should be straightforward, without having to deal with complex nested structures. Ideal skills and experience: * Previous experience with web scraping, ideally from ecommerce websites * Attention to detail to ensure accurate retrieval of data * Ability to work with single sentence title structures * Adeptness at handling image scraping on ecommerce platforms. Please, only bid if you have the required expertise and can deliver this task effectively. I'm looking forward to working with a diligent and commit...

We currently operate all our MySQL databases on Amazon RDS and Amazon Aurora services. With the upcoming update deadline on August 22, 2024, we desire an analysis of all possible implications of the update and if needed, corrective action to comply with these issues as listed on our health dashboard. Key Responsibilities: - Thoroughly understand the SSL/TLS certificate update process in the context of Amazon RDS and Aurora - Analyze our databases for potential impact and make any corrective changes We believe this may affect our Scripts server, our PHP code on our Scooby server, and our web site application code that accesses that database. It is possible that this change will not impact us at all, beyond ensuring that the new certificate is associated correctly with your RDS i...

... - Security and Access Control: We have a user creation bug I cannot solve. - Troubleshooting and Performance Tuning: We have intermittent record locking which we need to fix. - XML Parsing: We have a 10 year old xml parsing codebase, which causes serious performance issues when there are hundreds of fields, we need a way to speed this up. - Converting SQL Server to MySQL: We also need to convert the entire codebase to mysql so we can run on both database engines and keep them syncronised. This is a nice to have skill, but we expect we might need a second person with different skills for this. Presently, we're using SQL Server 2017. We're looking for a SQL DBA specialist, so if your background includes SQL, .Net, web, mobile, SEO, graphic design, property devel...

I need a capable and experienced PHP/MySQL developer to create an interactive historical results report for me. The report will be generated based on user-selected parameters in a web page. Data to be arranged in tables, generally organized like in the attached image. A list of departments is in another of the attached images. User should be able to click to hide/display prior years and click to hide/display min/avg/max values as well. At the bottom of the report, a grand total section that includes all departments should be displayed in a similar fashion as the departments. The MySQL query that is used to obtain a given total from the data is: ------------------------ SELECT SUM(llx_facturedet.total_ht) AS Total FROM llx_facture AS t LEFT JOIN llx_societe ON...

...multiple proficient C++ developers with in-depth understanding of MySQL. The project primarily involves setting up MySQL in C++, therefore the ability to create and integrate a MySQL database with C++ is vital. Moreover, experience in input/output handling and advanced mathematical calculations are necessary. Skills and Experience: - Expertise in C++ - Proficiency in MySQL - Understanding of I/O handling in C++ - Experience with mathematical calculations Project Requirements: - Set up MySQL database in a C++ environment - Implement MySQL database that is capable of storing application data - Foster database integration with C++ - Incorporate intuitive input/output handling - Execute complex mathematical calculations. Please note, a MySQL...

I'm in need of a proficient C++ developer for an ongoing project. Key Responsibilities: - Develop and implement new software features using C++ Ideal Candidate: - Proficient in C++ programming - Strong knowledge of MySQL and its integration with C++ - Experience in documenting complex structures in C++ As I have very little experience with C++, it would be beneficial if the ideal candidate has strong experience to recommend scalable architecture design of code when working with me. Additonally, although I would like to learn, it is important to focus on the task of developing new features. Your understanding and patience are greatly appreciated.

We are looking for someone to fix following issue which is coming every 3 hours. Access denied for user 'root'@'localhost' (using password: YES)

I'm in desperate need of assistance with a database management assignment. The tool of choice for this project is MySQL, necessitating an expert familiar with the specifics of this particular database system. With an urgent closure time frame of 2 hours, you will need to hit the ground running. The assignment centers on two key areas: 2. Understanding Database Concepts - In addition to query writing, a solid understanding of core database concepts is necessary. Part of the task may involve explaining these database concepts to me, so clear communication is important.

I need a talented web and mobile app developer with...following skills: - Proven experience in both web and mobile app development. - Strong proficiency in HTML5, CSS3, JavaScript for front-end development. - Solid skills in PHP, Python, Ruby or Java for back-end development. - Knowledge of website and app layout/user interface by using standard HTML/CSS practices. - Experience with public key cryptography. - Familiarity with database systems including MySQL, Oracle, and MongoDB. - Proficient understanding of code versioning tools such as Git. Please note, despite the listed e-commerce platforms, we prefer to have our own content managed system (CMS). Please provide examples of any previous work and include estimates on cost and time in your proposal. Looking forward to your best ...

...need of a skilled PHP/Admin expert with experience in Laravel to help host a new Laravel site which has a theme/template. It is hosted in one site and I want it to be hosted in my site in USA. In some sense I want to keep developers in check who gave me GIT/ZIP File. ZIP has MySQL DB too. Will share the site so as long as this code does what site does.. if not, they offered their help to help you host in India AM time too. You can test it in local before we move to my production VPS. Needs PHP 8.2, Laravel 10, MySQL DB to host the site. It is ecommerce marketplace. Key Responsibilities: - Get Zip from me and try locally - if it works move to hosting - If not,, available after 9 hours to talk to them and understand issues. Where you ask and get resoultion. - You wi...

...a proficient C++ developer with in-depth understanding of MySQL. The project primarily involves setting up MySQL in C++, therefore the ability to create and integrate a MySQL database with C++ is vital. Moreover, experience in input/output handling and advanced mathematical calculations are necessary. Skills and Experience: - Expertise in C++ - Proficiency in MySQL - Understanding of I/O handling in C++ - Experience with mathematical calculations Project Requirements: - Set up MySQL database in a C++ environment - Implement MySQL database that is capable of storing application data - Foster database integration with C++ - Incorporate intuitive input/output handling - Execute complex mathematical calculations. Please note, a MySQL data...

I'm in need of a proficient C++ developer for an ongoing project. Key Responsibilities: - Develop and implement new software features using C++ Ideal Candidate: - Proficient in C++ programming - Strong knowledge of MySQL and its integration with C++ - Experience in documenting complex structures in C++ As I have very little experience with C++, it would be beneficial if the ideal candidate has strong experience to recommend scalable architecture design of code when working with me. Additonally, although I would like to learn, it is important to focus on the task of developing new features. Your understanding and patience are greatly appreciated.

I need to setup latest mysql (v8.x) on C++ on my windows 64. The C++ is installed using Msys64 (not visual studio). I need you to figure out how set up the mysql for this c++ for me on my computer. Before I hire you, you must provide a video demonstrating the installation steps successfully on your own computer, and showcase a test by writing c++ code to run a basic mysql query. If the video convinces me that you can do the job correctly, then I will hire you so that you do it on my computer. I will give you control thru anydesk, and you will have to repeat the installation steps on my computer too. And after that, I will do the steps from scratch once again while you watch me, and you troubleshoot me if I get stuck somewhere. PAY: 3000 INR + 2 reviews of 5-star ...

To be written in PHP/HTML/JS/CSS + MySQL/MariaDB Admin functions: (through desktop and tablet) Login View all "work logs" View, Add, Edit, Delete Employees View, Add, Edit, Delete Clients Must be able to reset an employee password. Employee Access: (through tablet) Login View (own only) past work logs. Add a work item (log job button in mockups) A "work item" is a database entry that logs an employees work for that day. It should have at minimum the following information: Employee id, client id, work location (text input), hours logged, description (text), and customer signature. The signature should be stored as both a blob and png. An email should be sent to the admin (hardcode email address is OK) via SMTP when a new "work log" is created...

...professional with expertise in setting up and managing MySQL databases in a multicluster replication using Galera. While the goal is to enhance system performance and ensure high availability, it's crucial that the hired professional has: • Deep understanding and hands-on experience with MySQL databases and Galera Cluster. • Expertise in database architecture and scaling strategies. • Capabilities to optimize configurations for best performance. • Precise troubleshooting skills and quick problem resolution abilities. To provide more context about the project: • We're planning to utilize the multicluster functionality. • Our database size is in the small range, i.e. a few gigabytes. Potential freelancers need to demonstrate their p...

I require a diligent and detail-oriented professional to he...Retrieve and convert a vast number of US addresses from the source, which is currently in an online database format - Ensure the converted data is compatible and easily integrated with APIs for seamless utilization - Handle the entire range of addresses from the National Address Database, not missing out on any specific city or state Ideal skills for this project include: - Experience in data retrieval and conversion, particularly from online databases - Proficiency in creating API-compatible data sets - A meticulous approach to ensure all addresses are accurately captured - Background in working with marketing data is a plus. I am looking for someone who can meticulously get this broad dataset ready for my marketing ...

Hi Elite Information Tech, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Start your quote with "MSSQL2017 so I know your not a bot. :) I am in need of an experienced database professional who can help in converting my small MySQL database (less than 1GB) into MSSQL. The database doesn't contain any stored procedures, hence simplifying the migration process. Key requirements of the project: - A thorough understanding of both MySQL and MSSQL. - Experience in database conversion processes. - MySQL database (source) is small, less than 1GB. - There are no stored procedures in the database. Please note compatibility requirements: - The MSSQL version for conversion is specifically required. MSSQL 2017 or later Your proposal should detail your relevant experience and any similar projects you've successfully completed. Please ...

I am urgently in need of a SQL expert proficient in MySQL. I require assistance with writing data definition queries. Work Expectations: - Writing proficient data definition SQL queries. - Extensive knowledge of MySQL. Below is my query. Need to modify the query and get the count as 0 for the column srce_syst_paty_i SELECT COUNT(*) FROM ( SELECT CASE WHEN PATY_IDNN_BK LIKE '%SAP%' THEN SUBSTR(PATY_IDNN_BK, INSTR(PATY_IDNN_BK, '+') + 1) WHEN PATY_IDNN_BK LIKE '%BCB%' THEN SUBSTRING_INDEX(PATY_IDNN_BK, '~', -1) END AS srce_syst_paty_i, * FROM dev_enr.cpln_svrq_paty_detl WHERE day = '02' AND month = '06' AND year = 2023 ) src INNER JOIN ( SELE...

Please apply only if you are willing to work on Zoom screensharing only. This is long term project lasting for years. Must have good skills in Javascript, PHP, Mysql/Nosql database and API integrations. As the person in charge of this project, I am seeking a skilled PHP/Javascript developer to handle various tasks, including: - Database integration: I anticipate needing to ingest, organize, and manipulate data regularly. Therefore, you'll need strong database skills with a focus on integration points between the site and the back-end databases. - Custom coding: We anticipate some unique challenges in the development of our website that will call for custom codes. You should be a problem-solver who can think on their feet and write custom code as required. For this project, ...

...building the server-side logic and RESTful API endpoints to handle user requests and data manipulation. Database Management: Skills in working with MySQL for storing and retrieving trade data are essential. Understanding database schema design, querying, and optimization techniques is necessary for efficient data management. Authentication and Security: Familiarity with JSON Web Tokens (JWT) for user authentication and implementing secure authentication mechanisms to protect user data is required. Real-time Updates: Knowledge of WebSockets for implementing real-time updates to reflect changes in trade statuses and other relevant information is necessary. Deployment and Containerization: Proficiency in Docker for containerization, NGINX for reverse proxy, and deployment...

...developer who can build an informative website about Menopause. This site will serve as an essential resource for those seeking to understand more about Menopause, including symptoms, treatments, and support. Key Features: - An informative platform that discusses all aspects of Menopause - A clear and user-friendly layout optimized for ease of navigation - The ability to update content as new information or research becomes available Ideal Skills and Experience: - Proven experience in website development - Strong knowledge of user interface design - Experience with SEO best practices to ensure site visibility - Knowledge or interest in women's health, specifically Menopause, is a significant plus You will be responsible for both the overall design and technical exec...

We need to create a medical alert information ID badge for the consumers to wear when out in public in case of any emergencies, so first responders could know critical information... but they don't want the consumers medical information easily seen by just anyone. We need to create a spot with the consumers in the program you already built, to add the consumer's picture, name, date of birth, address, any medical alert information needed, allergies, verbal/non-verbal, emergency contact information, alternate emergency contact information, guardian's contact information, Medicaid number. That would create a 2.125 inch x 3.375 inch image with the consumer's photo, name, and a QR code that could be downloaded as an image f...

i have a mysql query i need to add some JOIN or WHERE / AND condition i tried but not working help call first to show the issue then once i award u u will work in real time live must be done realtime live

...kiosk interface, backend server logic, and integration with physical hardware components like sensors and shuttles for vehicle storage and retrieval. The goal is to provide a seamless, efficient, and user-friendly parking experience with minimal driver involvement. Responsibilities: Design and implement a secure and intuitive mobile app and web interface for users to initiate parking and vehicle retrieval processes. Develop robust backend logic to manage parking allocations, user interactions, and system status in real time. Integrate various sensors and automation hardware into the system, ensuring accurate vehicle measurement, positioning, and retrieval. Work closely with hardware engineers to ensure software and hardware components communicate effectively. Impl...

I'm in immediate need of a skilled php mysql html5 javascript developer to finalize two forms for my php script. The purpose of these forms is for invoice information capture. Ideal Skills: - Proficiency in PHP, MySQL, HTML5, and JavaScript - Experience in form creation and data management - Quick turnaround time Please note, as this is urgent, I need the project completed ASAP. Looking forward to your bids.

I am seeking a talented WordPress developer to build a classic and elegant website dedicated to providing comprehensive information about Euro 2024. The site should not only serve as a hub for enthusiasts to learn all there is to know about the event but also as a guide for attendees navigating the event's various locations. Here are the project requirements: Key Content Features: - Schedule and fixtures: The site needs a section where users can easily access the full event schedule, including all fixtures. - Participating teams: A detailed list of participating teams should be displayed, possibly with additional information about the squads. - Stadiums and venues: This section will detail the various stadiums and venues hosting the matches, including their history, c...

I'm in need of a freelancer with extensive experience in Excel, specifically in applying VLOOKUP, IF, and SUM formulas. Task will mainly focus on: - Utilizing VLOOKUP to retrieve valuable data from a di...SUM formulas. Task will mainly focus on: - Utilizing VLOOKUP to retrieve valuable data from a different sheet. - Employing IF and SUM formulas as necessary to enhance data analysis. The ideal freelancer for this project is expected to have a profound understanding of Excel functions and capabilities, and a proven track record in the efficient use of Excel for data analysis. Experience in data retrieval and comparison using VLOOKUP is highly essential for this role. Ability to cross-reference and perform calculations with accuracy is required. If you fit the description, let...

Fair Playfields is a web-based sports match management system designed to streamline the organization and coordination of sports events, like football. The platform aims to provide a user-friendly interface for players, organizers, and administrators to ma...resolving queries. Performance Tracking: Develop a performance tracking system to record player statistics, match results, and personal ratings. Allow players to view their performance history and compare their stats with other players. Technology Stack: Backend: PHP (Laravel framework preferred) Frontend: HTML, CSS, JavaScript (with a modern frontend framework such as React or Vue.js) Database: MySQL Authentication: JSON Web Tokens (JWT) or OAuth for secure user authentication Version Control: Git for code management and col...

I'm in need of a SQL expert who can assist with some tasks on my MySQL database management system. The exact tasks are still being finalized, but it is essential that you have a wide range of skills and expertise in the field. Here's a potential list of tasks you might be working on: - Query optimization - Database design - Data migration Ideal Skills: - Extensive understanding of SQL and MySQL - Previous experience with query optimization, database design, and data migration - Strong problem-solving ability When applying, please ensure you include details of your past work. I'm keen to see examples of SQL tasks you've successfully completed, specifically in MySQL. Please be as comprehensive as you can be in your application. Your prior experi...

<Overview> Please collect product information on vehicles or logistics service information that have or will have the technologies described in the “Technology Description” section below. <Technology Description> This technology transmits the reminder to pick up the packages delivered in the vehicle when the package is not picked up by the user after predetermined period of time has passed after the package has been delivered to the vehicle cabin. Please search for this technology in this contest. <<NOTICE>> The target brands in this search are limited to US, European, Chinese, and South Korean brands. <Requirements for Payment> ・Submit documentary evidence that clearly states the details of the subject product, the name of the ...

NO AI GENERATED CONCEPTS PLEASE We are on the lookout for a talented designer to craft a new logo and brand identity for our exciting project, ClashRush. We're seeking an innovative approach and welcome a designer with the ability to create a compelling and memorable logo that resonates with our brand and target audience, showcasing their unique design perspective. Skills and Experience: Proficiency in design software, especially Adobe Illustrator. Demonstrated experience in crafting logos and brand identities. Ability to generate innovative and original design concepts. Color Preferences: Hey there! As we spruce up ClashRush with a fresh look, we're hoping you can work your magic using this specific color for the logo, #03E8FF. It's been used as the primary color on o...

... and PRODA systems bookings with our dispatch system through API integration. The key functionalities required are as follow: - Retrieve booking information: Your main responsibility will be to establish a connection that allows us to fetch data from and auto populate this information into our dispatch system in real time. Ideal Candidate: I'd be particularly interested in individuals who have previously worked on API integrations for online booking platforms such as Booking.com. The ideal person for this job should have proficient knowledge of web-based API connectivity and a strong understanding of data retrieval processes. Efficiency and accuracy in delivering the project will be crucial. Experience with dispatch systems is a huge plus. In your proposal...

Does anyone have a license for Stellar Repair for MySQL (Version 8+). I need you to recover a DB for one time use. Please start with "stellar" to be considered

I am seeking an experienced HTML5 (or REACT) and JavaScript developer to create a user registration, login (with change and forget password) system and one special form for my project. It should be simple, clean, and user-friendly. Your respon... clean, and user-friendly. Your responsibilities will include: - Creating a user registration and login interface. - Implementing change and retrieve password functionalities. - Designing a special form with moderate complexity, including validation and rules. - Designing MySQL database structure - APIs to communicate between UI and MySQL database The ideal freelancer for this project should have extensive experience in: - HTML and JavaScript programming. - Developing user-focused interface designs. - MySQL Database ...

I have a similar project that I could use your help on. We need to sync QBO customer records into MySQL. Is that something you'd be interested in helping with as well?

I own a Python script that I want to transf...Python script that I want to transform into a SaaS-based web application. I am seeking a Django developer with experience in user authentication, authorization, and MySQL database integration. The finalized application should offer these capabilities: - User Authentication & Authorization: The platform needs to include secure access for both admin and subscriber roles. Admin users should have higher privileges compared to subscriber users. - Database Integration: The application should be integrated with a MySQL database to manage and store user data. The ideal freelancer should have a solid understanding of Python, Django, MySQL, and user access control mechanisms. Experience in creating SaaS applications will be co...

I'm requiring a talented and detail-oriented specialist to construct a database to manage a diverse set of data, potentially including but not limited to customer information, inventory management and sales tracking. The freelancer would ideally have experience in design and ER diagram, to ensure a smooth flow of data and efficient retrieval process. Key Job Requirements: - Proven experience in the designing and implementing of a comprehensive database - Knowledge of dyanmiq or mongoDB - The ability to produce detailed project proposals When applying, please provide a detailed project proposal including an overview of the project, your proposed approach to the project, timeframe and budget estimates. I am looking for an innovative thinker with a problem-solving appro...