Mysql table field php jobs

I'm looking for a PHP developer with substantial CodeIgniter framework expertise. The project at hand involves upgrading and optimizing an existing PHP application. Key Requirements: - Strong PHP skills and extensive experience with the CodeIgniter framework - Proficiency in MySQL database management for database optimization and management. - Familiarity with front-end development to be able to enhance the UI/UX as part of the upgrade. Your main responsibility will be to improve the existing codebase, making it more efficient and scalable. This will involve database optimizations, code refactoring, and possibly some UI/UX upgrades. An understanding of security best practices in web development will also be highly beneficial. If you have previous experi...

hello I am currently planning to start a startup. I am currently entering the IT field (fields such as Facebook and Instagram) and need a programmer to join me. The working hours per day will be more than 40 hours, and a small salary may be paid per month. I have very creative ideas and am ready to grow into a global company. If you join me, I will provide you with an additional salary increase and a higher position as the company grows (e.g. Data Manager/Marketing Manager, etc.) Anyone who can do any of the following is welcome. -programmer -translator -lawyer -Server maintenance -Marketing expert -Anyone else who can contribute to the growth of the company Anyone who has a lot of passion and is starting a journey with me for my company is always welcome!

I'm looking for a skilled developer who can integrate WhatsApp API into my Wordpress website to allow for sending promotional messages to customers. Additionally, I need this feature further developed into a simple chatbot for automated responses. - Your primary tasks will include: - Setting up the WhatsApp API to the website - Configuring it to allow for sending messages to customers - Developing a basic chatbot functionality - Ensuring the chatbot can provide automated responses based on predefined rules You should have: - Proven experience in integrating APIs, specifically WhatsApp API - Proficiency in developing chatbots - Knowledge of Wordpress and it's capabilities for handling APIs - Good understanding of marketing and customer engagement - Strong problem-solving...

More details: Which type of recipes would you like to include in your app? breakfast , seafood and dessert Do you have a specific API in mind for fetching the recipe data? How soon do you need your project completed? ASAP the app has three screen with buttons breakfast , seafood and dessert. when clicking on one screen it takes to the second screen with dynamic table view that shows list of food items based on API provided. when you click on any item on a second screen. it takes you to the third screen with cooking instructions and ingredients based on API provided. I attached 2 files. one shows the diagram how the screen will look on storyboard. the second file has the project description and the requirements needed for swift .

I require an experienced PHP developer who can quickly resolve two broken links on my e-commerce website. The first issue is in the search line reset menu, while the second is between the cart and the payment gateway. Key Responsibilities: - Fixing two broken links in the e-commerce page - Ensuring the page stops looping - Ensuring the page retains user details between stages - Enabling users to progress to the payment page The fix needs to be completed in the next week. Ideal Candidate: - Proficient in PHP, particularly in e-commerce settings - Strong understanding of custom coding - Ability to work efficiently and meet deadlines - Experience in troubleshooting and resolving similar issues I have existing documentation and code comments available for the sections wit...

I need a wizard in Microsoft Word for a particular job. The task requires fixing issues related to page numbering and the table of contents in my document. Here's what you need to do: - The documents appear to have page numbering inconsistencies which require correction. - The table of contents needs to be arranged with numerical page numbers. It is worth noting that the document does not follow any specific style guide or template. So, a general understanding of Microsoft Word formatting rules is necessary. Ideal candidates should have: - Mastery in Microsoft Word - Experience in troubleshooting and fixing Word formatting issues - Understanding of different formatting styles (although the work does not require adherence to a specific style guide) This is a quick fix...

I'm in need of an experienced developer to modify my PHP/Bootstrap5 image watermark form. The current setup has the form working in the background with a preset design. I now want it to be a more integral part of the watermark process. Key tasks: - **Form Integration**: The form should be fully functional, where users can upload images, add text for watermarking, choose a watermark position, and even select an existing image for watermarking. - **Code Adjustment**: The existing watermarking code needs to be integrated and work seamlessly with the form submission. This involves adjusting the code to make it work in conjunction with user input from the form. - **User Experience**: The form should be user-friendly, intuitive, and visually appealing, ensuring a smooth and engaging...

I have initiated the drafting of my business plan and investor deck, however, I am looking for a seasoned freelance professional to take my existing work to the next level. Pa...Particularly, I am in need of assistance in the creation of compelling visual branding elements. The suitable freelancer for this task should possess: - Proficiency in creating visually appealing branding elements - Impressive portfolio in graphic design with focus on branding - An understanding of business plans and investor decks - Ability to preserve my initial concept, yet bring fresh ideas to the table Your main responsibility will be to revamp the visual aspect of my business plan while maintaining the original essence. I am open to new ideas and novel thinking. I look forward to our potential coll...

I require a skilled Care Manager with mid-level experience, specifically in the field of chronic disease management. You will be responsible for: - Efficient medical scheduling - Seamless care coordination - Exemplary patient advocacy Prior experience in these tasks is crucial to ensure high-quality care and seamless operation. If your skills align with these requirements, I look forward to your bid.

...extended to the professional ranks such as The NFL and the AFL. If you’re an athlete with collegiate eligibility or an athlete looking to pursue the game at a higher level then we would love to see if you have what it takes to become a Hurricane. Our Orientation for you and your family will begin at 12pm and Registration for the Tryout will begin at 1pm. Hydration stations will be provided and proper field work attire will be required....

I'm looking for a skilled social media manager who can handle various aspects of our online presence. Key Responsibilities: - Creating engaging, eye-catching content for Facebook, Instagram, and Twitter - Developing and implementing strategies to increase brand awareness, drive website traffic, and generate leads/sales - Regularly monitoring and analyzing our social media per...multiple social media platforms (Facebook, Instagram, Twitter) - Strong understanding of social media analytics and strategy - Ability to create engaging content that resonates with our target audience - Good understanding of the unique needs and habits of millennials and business professionals on social media - Excellent communication and customer service skills - Background in marketing or a related field...

Objective of the project The goal of the project is to develop an automated system that generates high-quality content related to beauty, cosmetics, ...from various sources (URL, RSS, XML) configurable by a Super User. Filter and process such content using artificial intelligence (AI) to improve it. Automatically publish enhanced content to a WordPress blog and various social networks. Provide an intuitive administration panel for managing system sources and configurations. Technologies and Tools Used Backend: Django Frontend: React Database: MySQL or PostgreSQL Monitoring: Prometheus and Grafana Containers and Orchestration: Docker and Kubernetes This project is already validated by AI tools to correct errors in the part described in the technical document, so the development is...

I need a professional translator to assist in translating our legal documents from Arabic to English. Key Points: - The documents are legal in nature, so it's crucial that the translator has experience in this field. - The Arabic language proficiency required is basic, but having experience in legal translation is a must. Ideal Skills and Experience: - Prior experience in translating legal documents - Proficiency in both Arabic and English - Understanding of legal jargon and document structure - Ability to deliver accurate and high-quality translation - A professional who can maintain confidentiality of the documents If you meet the criteria and are available to take on this project, please get in touch.

I'm currently dealing with an offline defamation of character issue, specifically word-of-mouth. This situation requires professional guidance to deal with effectively. Scope: * Addressing a word-of-mouth defamation situation * Making use of witness testimonies as evidence Ideal Skills and Experie...situation * Making use of witness testimonies as evidence Ideal Skills and Experience: * Proven experience in dealing with defamation cases, particularly those involving word-of-mouth scenarios * Expertise in evidential handling * Superb communication and trustee skills Your task will revolve around strategizing a strong defense using the testimonials I have gathered. Significant experience in this field would be advantageous. Please provide examples of previous similar cases ...

I am in need of a social media content creator who can help me boost my brand across Facebook, Instagram, TikTok and LinkedIn. You need to create 2 pieces of content using the below brand guidelines, the topic can be of your choice. I am looking for repeat work, and I will require a quotation from you based upon 10, 20, 30 pieces of social m...efficiently and deliver on time. Ideal Skills: - Proven experience in social media content creation and management. - Strong understanding of the different social platforms. - Ability to create appealing visual and written content. - Experience in brand awareness campaigns on Facebook and Instagram. If you're a creative social media professional who can bring fresh ideas and effective strategies to the table, I'm looking forward ...

CAFE NAME: BIgmug Cafe Color black and white I'm looking for a creative logo design for my chain of cafes that can compete in the western market. Like Starbucks, Java House, Mugg & Bean I don't have any specific ideas for the logo yet, so I'm counting on your expertise to bring something unique to the table. Key Points: - The logo must convey a modern and innovative vibe, capturing the essence of my franchise cafe's vision. It should be memorable it’s extremely important it’s unique and memorable like starbucks - I'm specifically looking for a design in black and white or grayscale, so please ensure this is incorporated effectively.

I'm looking for a proficient Blazor developer who can enhance the on-screen keyboard of our existing project. The below project shows on-screen keyboard which shows keyboard when the field is active. Below project has implementation in Blazor : Below is nuget package details: The only change I want to implement is to open the Keyboard inside dialog box when the field gets active instead of displaying on the bottom of the page.

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 stability and reliabilit...

I'm currently running CyberPanel version 2.3 with PHP 7.2 for hosting websites. I need to upgrade both CyberPanel and PHP to their latest stable versions. Key tasks involve: - Updating CyberPanel to the most recent stable version. - Upgrading PHP from 7.2 to the latest stable version (8.3). Ideal Freelancer: - Experienced in administering CyberPanel and PHP. - Proficient in upgrading server-side software. - Good understanding of website hosting environments.

I want 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 it, and if it's...

I've developed a database using MongoDB for dummy user data. I need an expert to review and enhance it in terms of schema design and security. Key Aspects for MongoDB Schema Design Review: - **Naming Conventions**: Ensure the names of collections and fields align with established conventions. - **Data Types**: Verify that the data types are correctly assigned and appropriate for each field. - **Indexing**: Check if indexes are set up and utilized effectively. Security Measures and CIS Benchmark Review: - **Authentication and Access Control**: Validate that the authentication mechanisms and access controls are properly implemented. - **Encryption and Data Protection**: Review the existing encryption measures and data protection strategies. - **Auditing and Logging**: Ensure th...

...HR Administrator - Essential certifications: SHRM-CP, CIPD, ATS I am looking for a collaborator who can help me secure interviews for these positions. The CV and cover letter will be the first impression employers will have of me, so they need to be outstanding. I prefer someone who is experienced in 1. UK and Europe recruitment 2. Environmental, water resources management, and sustainability field recruitment 3. using HR tools to increase the hiring rate, eg: Applicant Tracking Software ATS The ideal freelancer for this job should: - Have a strong understanding of the HR industry, specifically in the UK and Europe. - Be experienced in creating CVs and cover letters for HR professionals. - Be familiar with the relevant certifications and qualifications (SHRM-CP, CIPD, ATS) an...

I'm looking for a skilled professional who can help me with a fluid behavior simulation s...help me with a fluid behavior simulation specifically focused on liquid flows. The main aim of this project will be to deeply analyze the pressure and velocity fields, hence the need for a high level of detail in the simulation results. Key Requirements: - Expertise in fluid dynamics and specifically in simulating liquids. - Capable of providing insights through detailed pressure and velocity field analysis. - Proficiency in using industry-standard software for flow simulations. This project is a crucial step in understanding and optimizing our system's liquid behavior. The ideal candidate will have a proven track record in similar projects and should be able to guide us through t...

I'm seeking a skilled professional to help me understand the basics of the Zig programming language, specifically in relation to MySQL/MariaDB. I would like assistance in the following areas: - Learning how to incorporate MySQL/MariaDB within Zig projects

...specialist well-versed in creating highly engaging and educational animated videos within the medical field. Requirements: - Demonstrated proficiency in executing animated videos. - Expertise as a specialist physician. - Ability to turn complex medical information into simplified animated content. Freelancer Application: Given the complexity of the content I need to present, I request proven past work in similar projects. Please include samples of past work, ideally in the medical field, when applying. This is essential for me to understand your approach to animation and medical content. This is a niche area, and thus, your proven expertise as a physician and in the animation field will give you a considerable edge. Skills and Experience: - Medical video c...

I have a web application that runs on PHP and I'm looking to integrate it with APIs provided by multiple suppliers. These suppliers will send us three specific types of data through their APIs - customer information, product information, and order information. Key Requirements: - Connect the webapp with Supplier A, Supplier B, and Supplier C APIs. - Extract and process customer information, product information, and order information sent by these suppliers. - Display this data on the webpages of the application. - Store this data efficiently in a database. Skills and Experience: - Proficient in PHP and API integration. - Strong understanding of database management. - Experience in handling customer, product, and order data. - Detail-oriented to ensure accurate data ext...

I am in need of a highly creative infographic to illustrate an intermediate level concept within the field of education. This will require both a creative and effective approach to presenting information visually, and ideally strong familiarity with educational topics. Skill sets and experience required include: - Personal understanding of graphic design principles, particularly related to infographics. - Experience in understanding and visually presenting intermediate complexities in data or concepts. - Knowledge or experience in the education sector would be highly beneficial. - Excellent communication skills to fully comprehend and manifest the concept being explained. Your task is to take this concept and present it in a way that not only educally enlightens but also visuall...

...I need to remove the Service Number Taxonomy that was added and create a new one called Booking Category. This will need look up the `11_bkntc_services` table in the database. (I use the Booknetic Plugin for Game Bookings) The table looks like this image, so you will have to use case insensitive SQL to find the `11_bkntc_services` WHERE name is PARTIALLY equal to the "Projects name" (2nd Image) as I have multiple actual games per "Project" The WP page in question is Https:// The "Book Now" button uses the code in the image below found in this file: wp-content/themes/gamico/template-parts/project/item-project-style-6.php to show the Booknetic category based on the game. -------------------------------------------------------------------...

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 am in need of a skilled iOS app designer to help develop a start-up program aimed at addressi...- Proficient in iOS platform app design - Prior experience in start-up or related app development - Solid understanding of user experience and interface design - Excellent problem-solving skills and creativity - Ability to work within deadlines and multi-task effectively. This project requires someone who can intuitively understand the needs of a start-up and bring creative solutions to the table. I look forward to hearing from you. I have searched the app store and have not found anything like this but it is very much needed. I will need to get a confidentiality agreement signed before anything starts. It should be fairly simple but I am not versed in app production. Thank you for ...

I am an experienced Pick Basic software programmer with many years of experience in the field. I am passionate about expanding my skill set and delving into new technologies. Currently, I am eager to learn Salesforce and gain practical experience in this area. I am seeking a mentor or a client who is willing to guide me through a Salesforce project, providing me with the opportunity to learn and grow while contributing to their project's success. While I may have limited experience with Salesforce at the moment, I am dedicated, motivated, and quick to learn. Here's what I bring to the table: Extensive experience in Pick Basic programming and software development. Strong problem-solving skills and attention to detail. A proactive and enthusiastic attitude towards ...

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

We are a web development company looking to expand our team. We need someone highly skilled in PHP and MySQL. Our work primarily involves custom projects, and occasionally WordPress. Currently, we have a job ready to start using the BigCommerce platform. This project requires code customization, assistance with connecting to shipping, and more. Thank you.

I need help migrating my Joomla-based website, which currently features a Currency Converter, to a new hosting server. Key Requirements: - Mig...migrating my Joomla-based website, which currently features a Currency Converter, to a new hosting server. Key Requirements: - Migrate the entire website (including the Currency Converter feature) from the existing server to a new one. - Ensure that the Currency Converter functionality remains intact and fully operational post-migration. Ideal Skills and Experience: - Proficiency in Joomla, PHP, and MySQL. - Prior experience with migrating websites, particularly those with dynamic features like Currency Converters, would be beneficial. - Strong attention to detail to ensure all components of the website are correctly transferred...

I'm in need of a debt collector agency with 1-5 years of experience to help me recover outstanding debts across various sectors. I require a set of services incl...different types of debts, such as consumer, business, medical, and government debts. - Skip tracing: Locating the whereabouts of debtors who have gone off the grid, making it difficult to recover owed funds. - Credit reporting: Providing me with updated credit reports of debtors to help assess their current financial status and determine the best approach for debt recovery. Experience in this field is crucial, as it requires a deep understanding of debt collection laws and practices. The ideal agency should have a proven track record of successful debt recoveries and be able to carry out the tasks efficiently and ...

I'm in need of a skilled individual who can apply their expertise to complete a 3D modeling task in Fusion 360 software. Below are the specifics of the project: - Task: Completion of a 3D architectural model using Fusion 360 - Required Skills: Proficiency in Fusion 360, particularly in creating architectu...low detailed model. Ideal freelancers should have: - Extensive experience and a strong track record working with Fusion 360. - A portfolio showcasing examples of completed 3D architectural models. - Ability to work effectively in line with given deadlines. - Strong attention to detail, even when creating models with a lower level of complexity. Please respond with examples of your work in this field, as well as your time estimation for this project. Looking forward to ...

I am in search of a proficient individual in crafting an impressive resume for a Senior-level AI Lead position I aim to apply for. Key requirements: - Knowledge and ...learning - An understanding of the programming languages utilized in AI, specifically Python Ideal skills and experience: - Previous experience developing resumes for Senior-level roles in tech industries. - Proficiency in Python, ideally within the context of AI and machine learning - An understanding of the relevance and applicability of various programming languages and machine learning in the AI field could be a great advantage in writing this resume. Overall, I require a resume that candidly but effectively highlights my skills in Python programming and machine learning in the context of a senior-level AI ...

I'm looking for a skilled developer to help me customize my current PHP SMS system. It's primarily used for sending notifications. I have the script and has been working with twilio, however all of a sudden it stopped working due to twilio changes I need assistance in modifying the script

...to ERPNext because it's easier to scale there. And also to be able to have our accounting team work there. The goal is separated on multiple phases but the first one and the most important is to build our dashboard on ERPNext by copy pasting what we have in the in-house built dashboard and creating DocTypes. After that, we'll create a new request for the other phases. Key features: - Custom field creation: The ability to create custom fields tailored to our specific needs. The system should allow for various data types, validation rules, and labels. - Custom form creation: The option to design custom forms with the ability to drag and drop fields where needed. The form should be easily modifiable to accommodate changing requirements. The primary users of this too...

I'm looking for a seasoned app developer who can create and design a unique utility application intended for young adults on both iOS and Android platforms....looking for the freelancer to possess, they should be: - Highly proficient in both iOS and Android app development. - Highly skilled in UI/UX design with a portfolio that showcases apps developed for young adults. - Experience in developing utility apps with incorporated social media functionalities. - Always staying updated with the latest trends and technologies in the mobile app development field. Other options will be given furthermore in the process. I also want a person who speaks fluently English Make sure to place a bid with your experience and samples of past work that align with the requirements of this pro...

I'm looking for an experienced affiliate marketer to help me promote physical products targeting both men and women. Because this is a physical product, the ideal candidate should have experience in this area. Key responsibilities for this project inc...product, the ideal candidate should have experience in this area. Key responsibilities for this project include: - Identifying suitable affiliate networks for physical products - Crafting and implementing an effective affiliate marketing campaign - Managing and maintaining relationships with affiliates - Monitoring and analyzing campaign performance If you have a proven track record in this field, I'd love to hear from you. Please provide examples of successful physical product affiliate marketing campaigns you...

...changing (both up and down ) for 20 times per year **T1 transactions Product id Date time Store id **T2 prices New price permanent Data Store is **T3 promotions Product id Store id Promotion price Date promotion start How many days promotion lasts **T4 store lookup table Store id Store state Store city **T5 competitors lookup table Competitor ID Competitor state Competitor city **T6 holidays lookup table USA holiday name USA state holyday Holiday date 1 Holiday date 2 Holiday date 3 ***** Main table to calculate ***** Product id Year Month Day How many sold Price usual Promotion y or n Price promotion Price promotion % to usual Promotion number of days Promotion 1 day before y or n Promotion 2 days before y or n Promotion 3 days b...

I am trying to integrate custom theme into wordpress . My intention is for each section of the website to react dynamically in wordpress so that I can build my site in wordpress itself. I need help to complete this process as I am facing a lot of errors.

I'm in need of a s...custom CSS code into the main app (portal has this option, need to copy paste for the company field) this is in order to enable RTL for RTL language users. CSS can be given. CSS can also be hard coded, only used for RTL. but should only be enabled if user selected either Hebrew or Arabic as language. 3. Expenses sub category - expenses add a sub category (now only category exists), also define how much % of the expense is approved. For example, in some countries if you report car gas expense, only 45% will be acknowledged as expense from the total sum. so 45% from the total expense should go into the reporting. The ideal candidate will be an individual or team with extensive experience in Invoice Ninja, PHP, Laravel, CSS, HTML and proficient in cre...

I need a skilled PHP developer to help me with a bug that's causing our login functionality to malfunction. Key Requirements: - The bug currently prevents users from logging in, and an error message is displayed upon failure - We need this bug fixed so that users can successfully log in without any issues Ideal Skills and Experience: - Proven experience in PHP development, particularly with login systems - Strong debugging skills to identify and rectify the issue - Solid understanding of database connections in PHP - Good communication skills to understand the problem and provide a timely fix

Hi! Dear Sir, I am a full-time Data Entry Specialist. I have been working in the field for more than 20 years. I am confident that I can offer effective and timely solutions for the right project. I am well equipped to handle any task from simple to complex and can tailor my skills to fit your needs. My professional qualifications and knowledge will enable me to success fully complete your project, no matter how large or small. I am full time certified GoverNment typing wpm certificate and data entry certificate. I am available to start your project. I will be happy if you choose me. Thanks.

I have a substantial Excel table and I am in need of a skilled data analyst to help with correlation analysis between Column 1 to 9 of my dataset, which contains more than 4200 rows and 9 columns. Need the source file of xls with formula too Key Responsibilities: - Perform accurate correlation analysis on specified columns - Generate line graphs to visualize the correlation Ideal Skills and Experience: - Proficiency in Excel and correlation analysis - Solid understanding and experience with line graph creation - Excellent problem-solving abilities - High attention to detail I'm looking for accurate and efficient work so I can understand the relationship between my data points and act accordingly. Your experience could be the key to enhancing my project. Looking forward to se...

I'm in need of an all-round developer who has strong experience in both Python and PHP, specifically for the creation of an e-commerce website. The desired professional should be well-versed in crafting custom web solutions as well as knowledgeable in leveraging the WordPress CMS beneficially. Skills and Experience Required: - Demonstrated expertise in Python and PHP web development. - Proven experience in developing successful e-commerce websites. - Proficiency with WordPress CMS. - Understanding of e-commerce website security essentials. - Articulate in communicating project progress and potential hurdles. Freelancers who can showcase previous work on similar projects will be given priority. I look forward to your enticing bids and am eager to form a productive pa...

I need a robust class management system that caters to the needs of a large-scale educational institution. Our primary users will be students, teachers, administrators, and parents. Key Features: - Attendance Tracking: The system sho...The system will cater to over 100 users, so scalability and performance are key considerations. Ideal Skills: - Proficiency in developing and deploying class management systems. - Strong understanding of user interface and user experience design. - Experience in creating scalable systems that can accommodate large numbers of users. - Knowledge of educational technology and best practices in the field. I'm looking for a freelancer who can deliver a user-friendly, reliable, and feature-rich system that can meet the diverse needs of our education...

...-70%; 91 for +30% **T1 transactions Product id Date time Store id **T2 prices New price permanent Data Store is **T3 promotions Product id Store id Promotion price Date promotion start How many days promotion lasts **T4 store lookup table Store id Store state Store city **T5 competitors lookup table ( 20% percent of stores have competitor In the same city ) Competitor ID Competitor state Competitor city **T6 holidays lookup table USA holiday name USA state holyday Holiday date 1 Holiday date 2 Holiday date 3 ***** start Main table to calculate ***** Product id Year Month Day How many sold Price usual Promotion y or n Price promotion Price promotion % to usual Promotion number of days Promotion 1 day before y or n Promotion 2 day...