The mssql database you are currently using is slow to search You want to improve the speed of this slow search speed.
# 2013년6월 ~ 2013년12월 : 고양시 상수도 블록시스템 - 고객사 : 고양시청 - 근무사 : (주)제이앤씨시스템 계약직 - 사용기술 : Java, Spring, Oracle, ibatis, amchart, eazy-ui # 2014년1월 ~ 2014년3월 : 고양시 상수조 블록시스템 GIS적용 - 고객사 : 고양시청 - 근무사 : (주)제이앤씨시스템 계약직 - 사용기술 : Java, Spring, Oracle, iBatis, O2Map, OpenGIS # 2014년4월 ~ 2014년11월 : 주유소 누유관리 모니터링 시스템 - 고객사 : (주)에스티모빅 - 근무사 : 프리랜서 - 사용기술 : Java, Spring, MySql, MyBatis, jqgrid, bootstrap, daum map API, plot-chart # 2014년12월 ~ 2015년2월 : 생산관리 ERP설계 - 고객사 : (주)금강이엠씨 - 근무사 : 프리랜서 - 사용기술 : mockup UI tool # 2015년3월 ~ 2014년4월 : 블루투스 BLE 비콘통신 Android 개발 - 고객사 : (주) 바이트시스템 - 근무사 : 프리랜서 - 사용기술 : Android (블루투스 BLE 비콘통신, 서버 소켓통신) # 2015년7월 ~ 2014년8월 : 임베디드 리눅스장비 웹관리 프로그램 - 고객사 : (주)제이앤씨시스템 - 근무사 : (주)제이앤씨시스템 계약직 ...
I'm in need of a Java developer with expertise in debugging issues related to reading and updating properties files in a runtime environment. Key Requirements: - Your primary task will be to troubleshoot why my application, which updates the properties file during runtime, fails to reflect the updated values when reading. - The updated properties should ideally be reflected periodically within the application. - The purpose of updating the properties file is to store user preferences. The ideal candidate should have: - Proficient experience in Java programming. - Strong understanding of how to work with properties files. - Proven skills in debugging and troubleshooting. It's important for the c...
We are seeking an experienced developer or team to create a comprehensive web software and database system for the remote monitoring and control of cathodic protection stations (SKZ) equipped with TE-RCU control units. This project involves developing web applications, database design, and integration of communication modules for real-time data acquisition, SMS/GPRS control, and SCADA system interfacing. More details will be sent in private.
...attempting to access the websites, a 503 Service Unavailable error is displayed. Key Tasks: - Diagnose the issue: Identify the root cause of the malfunction and provide a detailed explanation of what caused the websites and Java application to stop working. - Implement a solution: Apply the necessary steps to rectify the situation and restore full functionality to both the websites and the Java application. - Testing: Ensure that the fix is effective by thoroughly testing the websites and the Java application. Skills and Experience: - Profound knowledge of Webmin/Virtualmin/Cloudmin with the Tomcat module is essential to understand the impact of the update. - Strong understanding of WordPress websites and Java applications to effectively t...
I'm in need of a skilled individual who is proficient in blockchain and wallet analysis, specifically on the Arbitrum blockchain. The project involves analyzing transaction patterns and wallet balances and activities. Key Requirements: - Proficiency in blockchain analysis, particularly on the Arbitrum blockchain - Ability to identify patterns and trends in transactions - Proficient in analyzing wallet balances and activities Deliverables: - A comprehensive report that includes methodology, analysis, and conclusion - The report should be presented in a combination of written format and visual presentation (charts and graphs) Please note that I will provide you with access to the necessary pages and data on Arbiscan. Your task ...
We are seeking a highly skilled and experienced Data Scraping Specialist to optimize and significantly increase the speed of our current data scraping processes. The ideal candidate will have extensive experience in web scraping, advanced knowledge of bypassing anti-scraping measures, and proficiency in utilizing cloud-based solutions for enhanced performance. Strong problem-solving and hacking skills to navigate complex web security systems are essential for this role. Responsibilities: Analyze and improve existing data scraping scripts to maximize efficiency and speed. Implement and manage cloud-based solutions (AWS, GCP, Azure, etc.) for scalable scraping tasks. Develop advanced strategies to bypass anti-scraping measures like CAPTCHAs, rate l...
I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,7...
...experienced WordPress developer to handle the migration of an existing website to a new hosting provider. This role also involves updating the WordPress core software and all plugins, ensuring the security and integrity of the site, and providing ongoing maintenance. Responsibilities: 1. Migrate the existing WordPress website to a new hosting provider. 2. Update the WordPress core and all installed plugins to their latest versions. 3. Verify the security of all plugins and scripts. 4. Identify and remove malware to clean up the website, which is currently flagged on up to 8 malware sites. 5. Address and resolve any 3rd party malware reports. 6. Provide ongoing WordPress maintenance and security support post-migration. Qualifications: 1. Prov...
...for a Remote Part-Time WordPress Developer / Publisher to join our dynamic team. This role offers the flexibility to work from anywhere in Pakistan, collaborating with team members to create and maintain stunning WordPress websites. Responsibilities: Design & Development: Crafting visually appealing and fully functional WordPress websites. Content Management: Publishing and updating content across WordPress sites efficiently. Blog Management: Editing, publishing, and maintaining high-quality blog posts. Team Collaboration: Working closely with other team members to achieve project goals. Technical Support: Troubleshooting and resolving technical issues on WordPress sites to ensure optimal performance. Qualifications: Proficient in...
I'm a beginner in Oracle Service Bus (OSB) and would like a thorough virtual training session on the topic. I'm looking for a skilled instructor who can guide me through the following areas: - Basic Concepts and Architecture: I need to understand the foundational principles of Oracle Service Bus (OSB). This includes how it works, its key components, and its role in service-oriented architecture. - Service Development and Deployment: I'm interested in learning how to develop services on OSB and deploy them effectively. This includes hands-on exercises and practical examples to reinforce the learning. - Troubleshooting and Optimization: I want to be able to troubleshoot any potent...
I'm having some trouble with my Windows-based soft phone engine. There are some glitches and I'd like to get them resolved. I cannot specify the exact errors or issues, but I'm looking for a professional who can troubleshoot and help me get it working smoothly. Ideal skills/experience would include: - Proficiency in Windows OS - Experience with soft phone engines - Excellent troubleshooting abilities - Strong communication skills
I need a bash script that can import and export data from my database to CSV files. Ideal candidate should be able to: - Create a bash script that can effectively import and export data - Have experience working with database management systems such as MySQL, PostgreSQL, or MongoDB - Ensure that the script securely creates user accounts and manages their access to the database. The script will be used for daily database management tasks, so it needs to be reliable, secure, and efficient.
I need a professional to address two main issues on my WordPress website. Firstly, the ticket purchase functionality no longer works, and secondly, I require the identification of the root cause of this problem. KEY TASKS: - Troubleshoot the ticket purchasing feature, which is currently non-functional - Determine the cause of the issue The website was built using WordPress and the payment functionality is managed by the WP Travel Engine plugin. While there are no error messages displayed to users, the system does not allow for successful ticket purchases. Your role is to fix this issue and ensure that the payment and ticket purchase processes are fully operational. Ideal candidates for this project should have: - Extensive experience in WordPress deve...
...site plugins due to a checksum error. Along with this, I can't download newer versions of WordPress. I also need to make sure that my website is compatible with Consent Mode V2. Your responsibilities include: - Diagnosing and resolving the checksum error that prevents me from updating plugins and downloading WordPress updates. - Ensuring the site complies with Consent Mode V2. - Conducting a thorough evaluation of the website to detect any other issues that could be causing the problem. Skills and experience needed: - Proficiency in WordPress, its functioning, and its common issues. - Experience with plugin management and troubleshooting. - Familiarity with web compliance, especially with Consent Mode V2. - Ability to work around potential iss...
...frustratingly slow when I try to update or post content. I'm using shared hosting, and need an expert to improve the loading time to ensure smooth content management. Key Tasks: - Identify the root cause of the slow loading issue. - Implement effective speed optimization strategies for my Divi WordPress site to improve the editing and updating experience. - Ensure the site remains visually appealing and fully functional post-optimization. - I'd also appreciate any advice on maintaining optimal loading speeds in the future. Ideal Skills and Experience: - Extensive experience with Divi WordPress sites and the Divi theme. - Proven track record in speed optimization, particularly on shared hosting environments. - Ability to tro...
...experienced developer to work on a web project of mine. The project involves HTML, CSS, JavaScript, and some light database functions. The work will mainly focus on: - Implementing text input fields and dropdown menus: These are crucial elements for user interaction and data input. Your job would be to make them look and function as required. - Basic database functions: While the exact nature of these is yet to be decided, they will likely include retrieving and adding data. Your task will be to integrate these functions seamlessly into the site. Ideal skills for this project would include: - Proficiency in HTML, CSS, and JavaScript, with experience in creating user-friendly and responsive UIs. - Familiarity with basic database...
Looking for a skilled developer to help with an issue related to Livewire gadgets. The key points of the project are: - The problem: Currently, the save functionality of one of the gadgets, namely Index Filter, is not working as intended. It's not saving data correctly. I need this to be fixed. -Also need to fix livewire library issues please Ideal candidates for this project should have: - Proven experience with Livewire gadgets - A strong understanding of database systems, particularly in the context of web applications - The ability to troubleshoot and solve issues efficiently - Strong communication skills to understand and implement the necessary changes to the saving mechanism.
...skilled and experienced mobile application developer to integrate and implement the Tap payment gateway into my mobile application. The integration should be smooth and seamless, using the provided SDK and API keys. The primary goal is to ensure that the payment gateway functions properly and securely, without any errors, and provides a flawless user experience. Requirements: Proven experience in integrating payment gateways, preferably with Tap or similar services. Proficiency in the programming languages and frameworks used in my application (please specify if it's for Android, iOS, or a cross-platform framework). Strong understanding of API integration and handling secure data transactions. Ability to implement the payment gateway acco...
I'm facing an error while deploying my project during its application start-up. The project is currently being deployed to an unspecified environment. I require an experienced deployment specialist to troubleshoot and resolve the deployment issue. Key requirements: - Proficiency in deployment processes - Strong experience in resolving deployment errors - Ability to work on unspecified deployment environments Your expertise in this area will be vital in getting my project up and running successfully.
...developer to join our team and help finalize our ride-hailing application. The app is nearly complete, but we need assistance in implementing and refining our two-way communication system within the match-making component. The ideal candidate will have a strong background in Flutter, Bloc state management, and Node.js APIs. **Responsibilities:** - Debug and enhance the two-way communication functionality in our ride-hailing app. - Collaborate with our backend team to ensure seamless integration with Node.js APIs. - Implement and optimize Bloc state management for efficient state handling. - Ensure the app’s match-making system works reliably and efficiently. - Conduct thorough testing to identify and fix any bugs or performance issues. -...
Hello We are looking for a Google Pla...ideal candidate should be familiar with the Google Play Console and have experience in uploading apps to the Google Play Store. The main responsibilities of this role include managing app listings, uploading Apps, and ensuring compliance with Google Play policies and guidelines. We are seeking someone who can efficiently navigate the Play Console interface, troubleshoot common issues, and optimize app metadata for better visibility. If you have a strong understanding of the app submission process and can deliver high-quality results, we would love to hear from you! Skills needed: - Google Play Console - App upload - APK management - Google Play policies - Troubleshooting - Responsible with work Looking forward to...
I'm currently facing an issue with my MySQL replica. Although there are no errors, the data isn't being synced and the "Seconds_Behind_Master" is consistently increasing. I'm looking for a professional who can help me with this problem. I can't give you access to the server(s) but we can troubleshoot together. Key Requirements: - Expertise in MySQL command line - In-depth understanding of MySQL replication mechanisms - Experience in troubleshooting replication lag - Ability to work quickly and efficiently Max 50 euros. Thank you.
...Cloudflare and RDP setups to help me troubleshoot and resolve this problem. Key Points: - No specific error messages are being displayed when attempting to establish the RDP connection. - The remote desktop host is running on Linux. - There have been some issues previously with establishing RDP connections to this server before the Cloudflare tunnel was set up. Your role will involve: - Investigating the issue thoroughly to understand why RDP isn't working as expected. - Implementing necessary changes to the Cloudflare setup or the RDP configuration to ensure a successful connection. - Addressing any underlying issues that might be causing the problem. Ideal Candidate: - A proficient understanding of Cloudflare and RDP, particular...
I'm looking for a skilled developer to integrate two frontend files (HTML, CSS, JavaScript) into one single localhost. These files should display side by side and share a common footer. Key Requirements: - Integration of HTML, CSS and JavaScript files - Configure the files to display side by side - Implement a shared footer Ideal Skills: - Proficiency in HTML, CSS and JavaScript - Experience with frontend development and integration - Knowledge of localhost configuration and deployment Your understanding of frontend web development, integration, and configuration is crucial. A keen eye for detail and the ability to troubleshoot potential conflicts is needed to ensure a smooth integration process.
I'm running a website with an Apach...React frontend. The problem is, the frontend is loading with HTTPS while the backend is using HTTP, despite having a proper SSL configuration in the etc/sites-available confi file. I'm currently using a reverse proxy server to redirect HTTPS traffic to my backend server and I'm using a secure connection (HTTPS) to communicate between the reverse proxy server and the backend server. Key tasks include: - Troubleshoot configuration issues to identify the cause of the HTTP/HTTPS discrepancy - Ensure that the SSL configuration on the Apache2 server is indeed correct - Verify that the reverse proxy server is properly configured to redirect HTTPS traffic to the backend server No access c...
...themes or plugins recently, I'm unable to access the WordPress admin dashboard. I'm in urgent need of a skilled developer to troubleshoot and restore my site. Key tasks include: - Diagnosing the 'White screen of death' issue and resolving it to bring the website back online. - Investigating the root cause of this error and ensuring it does not reoccur in the future. - Restoring access to the WordPress admin dashboard so that further updates can be made, if necessary. Ideal skills for this job: - Proven experience in troubleshooting WordPress issues, particularly 'White screen of death'. - Strong background in website maintenance and problem-solving. - Excellent communication skills to k...
...developer to create a script for automatically sending MOV videos as email attachments. Key Requirements: - Design and develop a Python script for TouchDesigner that can attach MOV videos to outgoing emails. - Ensure the script is robust, reliable and can handle various video sizes. - Email content doesn't need to be customized for each recipient, so a standard email template is sufficient. - Mail input from user side Your role will involve: - Understanding the project's requirements and the specific constraints of sending MOV videos via email. - Creating the necessary Python script within the TouchDesigner environment. - Testing and refining the script to ensure it performs reliably across different email platforms. - Creating mail input system ...
I have two APIs in PHP that need to be fixed, specifically regarding issues with user authentication. Key Requirements: - Fix API A and API B - Resolve the authentication problems - Ensure APIs are properly authenticating users Ideal Skills and Experience: - Strong experience with PHP - Proficiency in working with APIs - Prior experience in resolving authentication issues - Ability to troubleshoot and debug efficiently Please let me know about your prior experiences in fixing PHP APIs, especially with user authentication. Feel free to share examples of your previous work or any relevant details. Your proposal should outline your plan on how you intend to resolve the issues and demonstrate that you understand the proj...
...detail-oriented and web-savvy freelancer/contractor to build a comprehensive database of sign manufacturers/companies in France. Project Scope: • Research and identify qualified sign manufacturers/companies/suppliers/sellers/stores across France. • Utilize various online resources, including: o Search engines (Google, Bing, etc.) o Social media platforms (Facebook, Instagram, LinkedIn) o Industry directories and publications (list specific resources if known) o Business databases (mention specific databases if known) • Gather and verify contact information (name, email, phone number) for each lead. • Compile lead data into a Excel format . Qualifications: • French reading and understanding - ONLY • Excellent research and data collecti...
...advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to 'Category A' should be displayed. - **Advanced Sorting**: The sorting functionality should be advanced, including multi-level sorting. This means that users should be able to sort the data based on mult...
I have a Uniswap Swap Widget integrated on my web platform built using React. The widget is currently facing connectivity problems that need to be addressed. Uniswap Swap Widget It use Metamask and Wallet Connect , I want change it Rainbowkit connector It need to complete in few hrs Ideal Skills and Experience: - Proficiency with React and Uniswap - Experience in fixing connectivity issues in web platforms - Understanding of how to integrate and troubleshoot widgets The task mainly involves identifying the root cause of the connectivity issue, and implementing a reliable fix that ensures the widget functions correctly. Experience with similar projects or Uniswap integration will be a
...developer, I am seeking a professional with expertise in Android Studio using Java who can support me in executing key tasks for my app. The main areas of support needed are app functionality and bug fixing. Key Tasks: - App Functionality: Your role will involve implementing and refining specific functionalities within the app. This includes features like push notifications and user authentication. Ideally, you will have a strong understanding of Android development best practices and be able to translate user requirements into tangible features that enhance the app's overall usability and appeal. - Bug Fixing: Being able to troubleshoot and resolve any technical issues or bugs that may arise during the development process is crucial. Your abili...
I will need to go through your flow and also have the appropriate access to troubleshoot the issue
I need a proficient PHP developer to address an integration issue I'm experiencing with the Ccavenue payment gateway on my website. Key Tasks: - Resolve the integration issue occurring at a specific stage of the payment process. - Implement the necessary changes to ensure the payment gateway functions seamlessly. - Integrate a new control panel in the admin panel. Ideal Skills and Experience: - Strong command of PHP, particularly in relation to payment gateway integration. - Previous experience with Ccavenue payment gateway is highly preferred. - Proficiency in admin panel development. - Ability to troubleshoot and identify issues efficiently.
I'm seeking a skilled freelancer to assist me with leveraging the free tier of Google Cloud ($300 credit) . I am a Google Cloud Platform account holder who wants to install and configure S/4HANA 2024. The primary goal for this project is development and testing. I'm looking for a freelancer who has a good understanding of both SAP S/4HANA 2020 and Google Cloud Platform. Your role will be to install and configure the software, ensuring it runs smoothly on the cloud platform. Key requirements include: - Expertise in SAP S/4HANA 2024 - Proficiency in Google Cloud Platform - Experience with installation and configuration processes - Ability to troubleshoot and offer post-installation support if necessary. Your assistance in...
I'm looking for an experienced developer to help with real-time text data scraping via API and management using BeautifulSoup. This project is primarily focused on retrieving text data and storing it in a database. Key Responsibilities: - Implement an API scraper to continuously retrieve text data in real-time - Utilize BeautifulSoup for data extraction and management - Develop a robust database to store all the scraped text data The ideal candidate should have: - Proficiency in Python programming language - Strong experience with API scraping and BeautifulSoup - Previous work involving real-time data scraping - A good understanding of database management It is important that the data scraping runs seamlessly and accu...
...last night for data analysis purposes. However, after trying to upload the '' file to GitHub, I encountered an error due to the file size being too large for GitHub. I need to get the Python file running again, but with the '' file stored on an external service to work around the file size limitations of GitHub. Key requirements include: - Identifying and resolving the issue causing the Python file not to run - Storing the '' file on an external service and adjusting the Python code to access it from there Ideal Skills and Experience: - Proficiency in Python - Experience with data analysis and handling large datasets - Familiarity with version control, specifically using GitHub - Ability to ...
I'm in need of an Expert Laravel Developer to fix some functionality issues with my current system. The main problem is various features are not working as expected. Your primary task will be to troubleshoot and correct these issues. You should have a deep understanding of Laravel and its ecosystem to quickly identify and resolve the problems. Key Requirements: - Proficient in Laravel framework - Strong problem-solving skills - Ability to work independently - Excellent communication skills Ideal Skills: Laravel, Bug Fixing, Troubleshooting, Problem Solving.
We are looking for a talented PHP Laravel Programmer to join our team and work on our B2B ecommerce website and app development. The ideal candidate will have a strong background in PHP and Laravel, with experience in building and maintaining ecommerce platforms. This is a remote position, offering the flexibility to work from anywhere. Key Responsibilities: Develop, test, and maintain high-quality ecommerce solutions using PHP, Laravel, MySQL, HTML, CSS, JavaScript, and related technologies. Collaborate with the design and product teams to implement new features and improvements. Optimize and enhance the performance of the website and app to ensure a seamless user experience. Troubleshoot and resolve issues as they arise, ensuring the sta...
...someone who can create a database in MS Access for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. The database should have a login page. After Login, there should be a a Main Page, with link to the above mentioned list pages plus, Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice page, I should be able to add an invoice details in...
I'm currently encountering some bugs in my Laravel project that need urgent fixing. I can provide you with more details about the specific issues in a private message, but here's a general overview of the task: - I'm looking for an experienced Laravel developer who can troubleshoot and resolve the bugs in my project as soon as possible. Ideal candidate should: - Have a strong understanding of the Laravel framework - Be proficient in debugging and fixing errors in PHP applications - Be available to start on this task immediately
...I'd like to organize my games by categories using custom taxonomies. Please read the SPECIFICATIONS BEFORE BIDDING - I need assistance with fixing the taxonomy issues and setting up the custom taxonomies to organize my games. - The main objective here is to help me effectively categorize the games on my site. - This will involve back-end work and ensuring that the taxonomies are correctly linked to the relevant content. SPECIFICATIONS (REFERENCE IMAGES PROVIDED): ----------------------------------------------------------------------------------------------------------------------------------------------------------------- I need to remove the Service Number Taxonomy that was added and create a new one called Booking Category. This will need l...
I'm currently facing a Forbidden error in my Laravel project that's connected to a MySQL database. I'm looking for a skilled developer to troubleshoot and resolve this issue, and potentially optimize the database connections for a smoother performance. Key tasks: - Troubleshoot the Forbidden error in my Laravel project - Review and potentially modify the existing database connections - Ensure that the database connections are optimized for performance The ideal candidate will have: - Strong experience with Laravel framework - Proficient in MySQL database management - Proven track record in troubleshooting and resolving similar issues
I'm in need of a proficient developer with experience in WPML to help resolve a few issues on my website. Currently, the Portuguese pages are not linked correctly to their respective English counterparts. Specific challenges I'm facing include translation errors, an improper layout, and missing content in forms and the footer. Key requirements: - Proficiency with WPML and WordPress - Familiarity with link management in WordPress - Ability to troubleshoot and fix translation errors - Experience in addressing layout issues Additional tasks: - I've also mentioned the need for some 'minor removals', which I'll provide more information on during our discussion. Ideal skills and experience for the j...
Money and all it takes to make it in easy steps even a 14 y/o can deal with
I'm in need of a competent web developer who is experienced with Bootstrap and can troubleshoot issues affecting the mobile browser version of my website. Key Tasks: - Identify and rectify issues causing browser compatibility problems - Ensure full responsiveness across different mobile browsers, particularly Safari, Chrome, and Firefox - Confirm that website's layout is consistent and functional on all devices The initial issue seems to be centered around Bootstrap, and hence, your understanding and experience with this framework is crucial. While I'm not certain if the Bootstrap framework itself is the root cause, your ability to investigate and resolve all possible problems affecting mobile responsiveness is highly sought. Ideal Skills and E...
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for 30%; 12 for 40%; 78 for 10%; 5 for 15%; 23 f...
...require an advanced database to streamline church operations. It must include: - Member management: This involves recording personal details of each member, tracking attendance, and allocating to the right departments. Each member's record should also include household and family details, with specific fields for spouse and children. - Functionalities: Capacity to sort data based on each individual (organize by member). It should also capture other input fields like gender, age, membership status, notes, and whether they serve as workers or ministers. - Financial management: The platform should have capabilities for recording and tracking financial contributions. Ideal freelancers will have experience in building similar database system...
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may ...
