Mysql huge database importpekerjaan
Hi Zubair Ali S., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
I need an experienced marketing specialist who is well-versed in SEO, Google Analytics, and Google AdWords. My goal is to: - Increase website traffic - Improve search engine rankings - Generate more sales For my online business that primarily targets young adults aged 18-24. I expect the freelancer to submit...specialist who is well-versed in SEO, Google Analytics, and Google AdWords. My goal is to: - Increase website traffic - Improve search engine rankings - Generate more sales For my online business that primarily targets young adults aged 18-24. I expect the freelancer to submit a detailed project proposal, outlining how they will accomplish these goals. Experience with this target age group will be a huge plus. Please share in your proposal, relevant past campaigns and thei...
We are engaged in the bag industry import and export supplier of the company, is committed to providing customers with more cost-effective bag production services. Now we need an engineer to help us build a company promotional page, which is required to meet the aesthetics of European and American customers. If you are good at it and interested in this job, welcome to contact me and communicate the design details. Please confirm with a reply starting with Hello World.
I'm looking for experienced freelancer who can help me optimize my WordPress database. The site is currently facing performance challenges like slow loading times and high CPU usage while some DB operations (post/comment multiply deleting). Requirements: - Proven experience in optimizing WordPress databases - Strong understanding of MySQL/MariaDB As a client, I have full access to the hosting server and database configuration settings, so you'll have the necessary access to make the changes required. Please only bid if you have the relevant experience and can deliver results efficiently. Plz no "manage" bids, the funds are limited & we need to discuss a lot f tech questions about DB, so you will waste YOUR and my end developers are allowed...
I'm in search of a skilled AngularJS developer to add new features and tailor existing ones on my current portal template. The key job duties constitute: - Adding new, unspecified features which will be discussed upon assignment - Tailoring current functionalities - Basic Create basic MySql database to add, edit and retrieve data The ideal candidate should have substantial experience with AngularJS, website functionality customization, and development. However, skills in user interface design and structure formatting would be a significant bonus. Expressions of interest are sought from professionals who are innovative, efficient, and capable of delivering on time. Please incorporate previous similar project examples and outcomes in your bid.
It is basically an app that helps the sales see the account profile data that is attached. We already have the designs ready, workflow will be decided in collaboration with the freelancer. Expertise required is app development and not design
I'm seeking a skilled Cultural Guide, specifically focusing on Indian culture. The aim is to have a knowledgeable companion who can provide insights on various facets of India's rich cultural heritage. This role would involve: - Offering deep unde...knowledgeable companion who can provide insights on various facets of India's rich cultural heritage. This role would involve: - Offering deep understanding and engaging insights on various elements of Indian culture - Customizing the guide to the needs of a radio format - Ensuring the information is accessible and engaging for a wide audience - Ideally, experience in creating radio content would be a huge plus If you have a passion for Indian culture, and a knack for making complex subjects accessible and engaging, I...
...functions. Key Features: - User registration and login - GPS tracking - Quote calculator - Payments and billing Your role will require you to design these components while ensuring seamless user experience and intuitive interface. There's also a need for payment gateway integration. Specifically, the platform must be able to accept transactions via PayPal. Experience with PayPal API is considered a huge plus. Ideal freelancer for this project will have: - Extensive experience in Android app and website development - Portfolio of complex apps with registration, location tracking, and payment features - Familiarity with designing user-friendly interfaces - Track record of integrating PayPal as a payment gateway If you can deliver an excellent work combining these functio...
I am looking for a software engineer who can help me develop a new software application with the primary goal of automating my business processes. Key Responsibilities: - Developing new software applications: You will be responsible for designing and creating a softwa...in software development: You should have a solid background in developing software applications, ideally with a focus on automation. - Strong problem-solving skills: I need someone who can think creatively and come up with innovative solutions to automate my business processes. - Understanding of business operations: Knowledge of business processes and how to streamline them through software is a huge plus. If you think you have the technical expertise and the strategic acumen required for this project, please get...
I am in need of a designer to create a...subtitle should take at least 1/3 to 1/2 of the top part of the cover. It should be large and in an easy to read font. Please no cursive or italics. -Somewhere on the cover needs to say, 'EASY TO READ' and 'LARGE FONT.' -No white or extremely light backgrounds -6"x9"aspect ratio Ideal Skills and Experience: - Prior experience in designing book covers, particularly for older demographics, would be a huge plus. - Expertise in retro design and understanding of the design elements that appeal to the senior age group. - Strong communication skills to collaborate on the design and incorporate feedback. - A portfolio showcasing your previous work in the realm of retro and senior-targeted design. I'm excited to ...
I urgently need proficient help correcting a problem with MySQL Table 1 corruption. Despite ongoing backups, the system is unexpectedly unable to read the table. High expertise in MySQL table repair is essential. Freelancer's tasks will include: - Diagnosing why the system cannot read MySQL Table 1 - Currenly can not do any action on that table This task is ideally suited for professionals with extensive MySQL skills, proven experience in data corruption recovery and comprehensive understanding of database backup utilization. Please provide examples of similar projects completed and your proposed timeline for completion. Prompt resolution is of high priority. Also we need a high experience developer to convert MySQL to mongodb to upscale ou...
I'm in need of a seasoned developer who can design a dynamic, responsive, and custom database synchronization system. Key Requirements: - Custom Data Mappings: The system should allow the designation of unique data mappings for seamless sync across various platforms. - Conditional Sync: The system should support conditional sync to ensure only relevant data is shared. - Automation: The synchronization process should be automated to reduce manual intervention and enhance efficiency. Platforms and Websites: The system should sync data with: - Social media platforms - Mobile devices Ideal Freelancer: - Proficient in database synchronization and mapping - Experienced with integration across websites and devices - Capable of designing automation processes - Knowledgeable ...
...expanding my marketing agency. This role entails: Key Responsibilities: - Cold calling potential clients to promote our services - Scheduling and attending client meetings to discuss their needs Industry Focus: - The primary target will be businesses in the marketing sector. Location: - I'm looking for someone who can reach out to international clients, so familiarity with global outreach is a huge plus. Ideal Skills & Experience: - Demonstrated experience in sales, specifically cold calling and client relations - Background in marketing industry - Ability to target and communicate with international clients effectively - Self-motivated and results-driven. Your role will be vital in driving business growth, so I'd like you to be able to demonstrate a strong tr...
I am looking to develop a ...user-friendly and accommodate the needs of professional teams. - Multilingual: While the app will primarily be in Indonesian, it should be designed in a way that will support other languages in the future. Ideal Skills and Experience: - Prior experience in developing IM apps is a must. Experience in business communication tool development would be a plus. - Proficiency in Indonesian language is a huge advantage, as it will help to ensure that the app is culturally and linguistically appropriate. - Strong UI/UX design skills are necessary to make the app user-friendly and intuitive. Please bear in mind that this is a business-focused project. Your proposal should highlight your understanding of the unique requirements of business communication apps. ...
Follow directions in video. Maidstone and Unity - Janessa and Kenzie Turtleford/Shellbrook/North Battleford - Juan David and Eduardo Meadow Lake - Cody/Tristan
In search of an experienced salesperson who specializes in bringing new projects, particularly in the technology, web applications, and digital solutions sectors. While a technical background in software developmen...potential clients in the technology, web applications, and digital solutions sectors. - Enhancing our client base and bringing in web design and development projects. - Developing and maintaining long-term relationships with new and existing clients. I'm eager to collaborate with a results-driven sales professional who can help grow my business. If you have a knack for opening doors and have a huge network at your fingertips, then I would love to hear from you. Your expertise in technology sales and insight into web design and development markets will drive our ...
...data and then stores it in a MySQL database. Key Components: - Unstructured Data: The quotes come in the form of text documents and images. The images have price information marked on them. The system should be able to interpret both types of data. - ChatGPT Integration: You'll be responsible for integrating GPT-3 or similar to process the received data. - Structured Data Storage: The structured data should be stored in a MySQL database. - Automated Database Updates: While batch updates are acceptable, the ideal system will be able to automatically update the database whenever new data is received. Requirements: - Prior experience working with ChatGPT, GPT-3 or similar technology. - Expertise in MySQL, with experience in se...
...facturas y entrada de productos: Registrar las facturas de compra y la entrada de productos al almacén para mantener un registro de todas las transacciones. Entradas y salidas: Permitir realizar entradas de productos al almacén (por ejemplo, desde proveedores) y salidas de productos (por ejemplo, para clientes o para uso interno). Migración de la base de datos MySQL del aplicativo anterior: Si hay un aplicativo anterior con una base de datos MySQL, necesitarás migrar esa base de datos al nuevo aplicativo para garantizar la continuidad de los datos....
...or 21, MySQL Usecase: 1. As a super admin I would be able to onboard a new tenant(example: school). Whenever superAdmin does that then new new database can be created dynamically in mysql. And the user_details, product, services tables need to be created. 2. There should be a table "tenant_master" which should have information of all tenant databases. like hostname, port, username, password, connection_string, tenant_name, status. One entry should come to this table when we are onboarding a tenant. 2. Need to configure the Spring Security with JWT authentication. 3. I can be able to login as school admin and JWT token need to generated accordingly. 4. When I request endpoints by sending the JWT token, system should connect to the respective databa...
I need an experienced Python MySql backend programmer to provide support for a web app I'm building. The tasks will include: - Database design and implementation - Query optimization - Data migration - Hands on GoDaddy cPanel Hosting The web app will require the following functionalities; - User registration and authentication - A well-designed Customer Relationship Management (CRM) system - Data fetch by API and Post on API Ideal skills and experiences include Python, MySQL, backend development, and experience with implementing user registration, authentication, and CRM systems. Experience in web-based applications is crucial for this project.
...professional to help with the maintenance of my websites built with core PHP and MySQL. Key Tasks: - Website changes: Regular content updates and design changes are anticipated, so the candidate should have flexibility and be comfortable with changes. - Feature Additions: I'm looking to extend the functionality of the websites, so the candidate should be able to implement new features. - Bug fixes: It's essential for the candidate to have a keen eye for identifying and fixing bugs that may arise within the websites. - Security updates: The candidate should be able to stay up-to-date with the latest security trends and ensure the websites are secure. - Performance optimization: A deep understanding of PHP and MySQL is required to optimize the performance of the ...
...facturas y entrada de productos: Registrar las facturas de compra y la entrada de productos al almacén para mantener un registro de todas las transacciones. Entradas y salidas: Permitir realizar entradas de productos al almacén (por ejemplo, desde proveedores) y salidas de productos (por ejemplo, para clientes o para uso interno). Migración de la base de datos MySQL del aplicativo anterior: Si hay un aplicativo anterior con una base de datos MySQL, necesitarás migrar esa base de datos al nuevo aplicativo para garantizar la continuidad de los datos....
I need a server pro to help me install and configure a Wisp game panel on my Ubuntu 22.04 LTS server. The server is a hosted bare metal se...version of Pterodactyl Panel. The setup should include the installation of the following gaming eggs: - Minecraft - Tmodloader - V for Vampire - Pal World Set up local backup on the second drive located on the server. Set up a full redundant backup with AWS S3 (or another storage solution) Ideal Skills and Experience: - Proficiency with Ubuntu 22.04 LTS or other Linux based server OS's - PHP, MySQL, curl, react - Setting up Linux users and securing root and access - Experience in installing and configuring game panels, specifically Wisp or Pterodactyl Panel - Familiarity with Minecraft server setup - Capability to install and set up ga...
I'm looking for a skilled PHP developer to create a web system primarily focused on data analysis. The system will serve as a platform for users to perform detailed data analysis. Key features to include: - User Registration and Login: The system should have a secur...Various Search Modules: I would like the system to have search capabilities by name, date, and category. This will allow users to slice and dice through data effectively. Ideal skills and experience: - Proficiency in PHP: As the core technology of this project, you should have a strong background in PHP. - Data Analysis Expertise: Experience in building systems that cater to data analysis will be a huge plus. - Security Knowledge: Strong knowledge of securing the system is crucial due to the sensitive nature of...
...goal is to automate daily updates of the website's database. Key Requirements: - Daily database updates: The website should automatically update its database every day. - Products and prices: The database should include technology products, such as electronics and computer hardware. - Design and layout: The website should be visually appealing and user-friendly. - Database type: The database can be either SQL or MySQL. Ideal Skills: - Proficiency in SQL or MySQL - Experience in e-commerce website development - Strong understanding of front-end design - Ability to automate database updates - Expertise in handling technology products Your proposal should include: - Your experience in similar projects - Your approach to...
...of a skilled MySQL professional who can smoothly transition my old database into the new one for my website. There are some extra columns in certain tables in the new database, so understanding the essence of the project is pivotal. Here's what I need assistance with: 1. Importing Data: I have a detailed list of specific tables and columns which need to be brought into the new setup. Your work will heavily rely on this list. 2. Data Combination: While importing the data, some of it requires merging. I won't be able to guide you on how this should be done, so it will fall under your professional judgment. Your proven experience and innovative strategies will come into play here. I am hoping to find someone who has extensive experience in MySQL,...
I'm looking for a person with expertise in Facebook ad and campaign management, ideally with a track record in successful branding initiatives. The main purpose of the campaign is to increase brand awareness among adults aged 36-55. The successful freelancer will be responsible for: - Strategizing an arresting Facebook ad campaign that resonates with the target demographic - Execut...resonates with the target demographic - Executing the campaign within a moderate budget, ensuring maximum reach and efficiency - Monitoring and adjusting the campaign as needed to enhance brand visibility Proven experience in digital marketing, especially Facebook ad campaigns, is crucial for this role. A deep understanding of the preferences and behaviors of adults aged 36-55 on social media is a ...
I am looking for a skilled videographer to create 4 enticing 30-second promotional videos for my travel business. The successful freelancer will use exceptional video editing skills to combine live-action footage, ideally featuring people enjoying resort facilities and tropical beaches, with animations. The videos need to inspire viewers to book travel packages and to contact me to do s...animations. The videos need to inspire viewers to book travel packages and to contact me to do so. Voice-over narration is a requirement, both in English and Spanish. However, I will provide the written script. Key skills: - Video editing - Animation - Understanding of creating engaging promotional content Previous experience with travel promotional materials or similar projects would be a huge...
I'm ...Video Consultations - Enables real-time video consultations for convenient and quick veterinary advice. * Prescription Requests - Grant clients the ability to request medication for their pets. * Vaccination Reminder - Automatic reminders for pet owners about upcoming vaccinations. * Database - A structured database for storing all application data, for which MySQL will be used. Ideal Skills and Experience: * Proficiency in iOS, Android, and Web application development. * Proven experience with MySQL database design and implementation. * Familiarity with implementing robust video consultation systems. * Previous work with appointment scheduling features and notification systems. Please provide evidence of any similar projects or relevant ex...
I'm in need of an experienced civil engineering firm to work with us on constructing a modern, bouti...site plan and confirmed that we comply with city zoning requirements. The architect has drawn a plan for the building, and we now need civil engineering, structural engineering, and landscape design. Are you interested in bidding on this project? Key Requirements: Experience in these fields and reasonable chargesPreferred Experience: - Previous experience in hotel or boutique hotel design is a huge plus. - Familiar with city building codes and urban planning considerations. - Proven track record of design projects in the Atlanta metro area. Looking forward to receiving proposals that include portfolio examples of similar work. Let's create a unique and modern bout...
I'm in need of a SketchUp expert to complete a basic context model. This project is primarily for architectural visualization, so the focus is on creating approximate representation of the basic shapes and structures, using a google maps 3d import as a guide. I've set up the file, so it just requires the rest of the buildings to be modelled. Ideal Skills and Experience: - Proficiency with SketchUp. - Previous experience in architectural visualization projects. - Strong understanding of basic building structures. - A keen eye for detail and design aesthetics.
I am in search of an experienced full stack development team to create a job board. Both PHP and MySQL, as well as Ruby on Rails should be familiar technologies for the successful candidate/team. The features I require include: - Job search engine - Resume submission capability - Creation of employer profiles Equally important to functionality is design. The job board must have a modern, sleek aesthetic while remaining user-friendly and intuitive. Moreover, the platform should be customizable and flexible to accommodate future expansion or changes. A successful history in similar projects is highly desired for this task. Proven design skills and a keen eye for UI/UX will also be highly advantageous. Note: Read the attached document for more details
Saloon Management in the following tech: 1. Laravel 11 2. Livewire 3 3. Filament 4. MySql Having following features: 1. Customers Management 2. Agents Management 3. Services Management 4. Booking Management 5. Agents Commission Management 6. Trend Charts
Saloon Management in the following tech: 1. Laravel 11 2. Livewire 3 3. Filament 4. MySql Having following features: 1. Customers Management 2. Agents Management 3. Services Management 4. Booking Management 5. Agents Commission Management 6. Trend Charts
...relational database design. The primary goal is to deepen my understanding and skills in E-R modeling, functional dependency theories, and database norms, particularly: * Identifying entities and relationships * Applying E-R modeling and normal forms for a well-designed relational database. The chosen candidate should be proficient in the aforementioned areas, plus have the capability to clarify how to use these skills to identify performance issues, validate data integrity, and evaluate scalability. The project scope encompasses E-R modeling, identifying entities and relationships, and applying normal forms. Ideal Skills: * Advanced knowledge in RDBMS * Proficiency in E-R modeling * Understanding of functional dependency theories * Experience in applying normal...
I need a professional who can create a healthcare conc...design diagram and a system design level 0 (High level with systems and subsystems), level 1 (High level with systems and subsystems and main details) and level 2 (very detailed). The diagrams should be colorful and engaging. I am looking for a freelancer who has experience in healthcare system diagram creation and is able to deliver high-quality, visually appealing work. Working in Health is huge plus The diagrams should have better grouping to include the following systems, features, and sub-systems: - Electronic Health Record (EHR) system - Patient Appointment Scheduling system - Laboratory Information Management System (LIMS) - Radiology Information System (RIS) - Electronic Medical Records (EMR) system - Telemedicin...
...efficiently. This is crucial for our decision-making process and maintaining a healthy credit portfolio. - Data Integration: The Algo Credit Risk Manager will need to integrate data from various sources to provide a comprehensive view. Although I didn't specify the exact sources in the questionnaire, experience with integrating Financial Statements, Credit Bureau Data, and Market Data would be a huge plus. - Reporting & Monitoring: The software should offer a range of reports and dashboards including: - Historical Credit Risk Analysis: We need to be able to view and analyze the historical credit risks we've undertaken. - Real-time Risk Monitoring: This is crucial for our proactive risk management approach. Being able to monitor real-time risks is a priority. -...
I am seeking a PHP developer who is experienced in frontend development, and an expert in PHP frameworks and MySQL database integration. The focal point of the project is database management. • Main responsibility of the PHP developer will be to build new databases, thus experience in this is essential. • A background working with PHP frameworks and MySQL is crucial for success in this role. • The role also entails some front-end development tasks. Successful applicants will illustrate these skills throughout their portfolio in relation to past projects. If you are a self-starter with a penchant for database management, I look forward to receiving your bid.
I'm requiring aid in managing and optimizing my SQL database. This database is currently handling a range of information including product details, customer details, and order details. Key Tasks: - Improve the existing SQL database - Ensure efficient handling of product, customer, and order data Ideal experience and skills: - Proficiency in SQL queries - Experience in database management - Familiarity with inventory management processes, specifically handling a limited range of 20 different products. This project will require a keen attention to detail and a comprehensive understanding of SQL database manipulation.
I'm looking for a social media guru who can help me manage my business profiles on Facebook, Instagram, and TikTok. My main objectives are to increase brand awareness, drive traffic to my website, engage with followers, and ultimately generate leads. Key responsibilities and requirements: - Planning and implementing a social media strategy - Creating and scheduling posts tailored fo...Monitoring analytics and adjusting the strategy accordingly - Creating and Maintaining Email Marketing Campaigns Ideal candidates should have experience in managing multiple social media platforms, and have proven success in increasing brand visibility and driving website traffic. Knowledge of the target audience, which includes millennials, business professionals, and property investors, will be a ...
I am seeking a skilled freelancer to manage my MLS listings. Your responsibilities will include: P...projects with this developer (and of course later we will be providing details of other developer websites with their own different projects) it's important to understand that each developer will display the information in a different way so you need to know what information to look for. That's the main purpose of this first exercise….. Before bidding please look at these 2 videos showing the import of the first project “The Bliss Village”…. We have got just less than 5 weeks to get around 200 developments done.
I'm seeking an expert in PrestaShop and data migration who can efficiently perform a full data import from my current PrestaShop 1.7.5 site to the new version, 1.7.8. Specific Requirements: - Absolutly all data should be transferred. - The primary focus will be on migrating 'Customer Data' and 'Order history'. Therefore, these two areas have must be accurately and efficiently imported without loss. There are around 40 items to be imported, 900 customers. The new graphics will need to be set as per my instructions for the "warehouse" theme, The development web space for the new site is already ready with the new wharehouse theme already installed. Ideal Skills: - Proven experience with PrestaShop is a must, particularly with data migrati...
...areas: database design and query optimization. Key Responsibilities: - Database Design: I'm looking for assistance in designing the database to ensure it's well-structured and optimized for performance. - Query Optimization: I need an expert who can help in fine-tuning our queries to ensure they're efficient and have minimal impact on our database. Key Skills and Experience: - Proven experience in MongoDB database design and query optimization, especially for small datasets (less than 1 GB). - Solid understanding of indexing strategies and their role in improving query performance. - Ability to communicate effectively and work collaboratively to understand our specific needs and tailor solutions accordingly. - Familiarity with perfor...
I'm looking for a seasoned blockchain developer to create a robust smart contract for my crypto dapp. The contract should exhibit the following features: - Staking Capability: The smart contract should offer staking functionality, allowing users/holders of the token to lock their tokens in the contract. - Reward Distributio...Mechanisms: A solid grasp of staking mechanisms, particularly those that reward based on the staking duration. - Testing and Deployment: Capable of integrating the developed smart contract with a UI and testing it thoroughly before deploying it on the mainnet. Additionally, if you have experience in building crypto dapps, or have worked on similar staking and reward distribution systems, that would be a huge plus. Please provide examples of previous work...
To fill this position, I am looking for a seasoned Tableau Expert who can efficiently create a dashboard that helps in tracking and visualizing Employment Metrics. Key Project Requirements: - Connect and import data from CSV files - Visual representation of data utilizing Line charts, Bar charts, and Geographical maps - All visualizations must be designed to track Employment data pulled from a pre-existing census Ideal Experience: - Proven experience in creating interactive Tableau dashboards - Proficient in handling CSV data within Tableau - Excellent experience with line charts, bar charts, and geographical mapping - Experience in employment data analysis or HR data visualization is a distinct advantage This is a fascinating project that needs advanced skills on Tableau. I lo...
I'm seeking an experienced PHP developer to help me address some pressing issues with my website. Key responsibilities include: - Resolving error messages that are currently present on the site - Adding a new fu...seeking an experienced PHP developer to help me address some pressing issues with my website. Key responsibilities include: - Resolving error messages that are currently present on the site - Adding a new function to the website: specifically, facilitating the editing of existing customer information in the database The ideal candidate for this role will have: - Proficient in PHP and MySQL - Prior experience in resolving error messages - Knowledge of and experience with customer database management Please provide your bid, along with your relevant ...
Hello! I represent the Five-BN Games company. We are PC and mobile game developers with more than 15 years of experience in the video game market. We need a competent and attentive translator to translate our game texts from English to Dutch (Nederlands). The ability to play this game to check your translation in action will be a huge advantage. We are looking for a real person, not an agency or mediator. People with strong English (C1C2fluentnative) whose mother tongue is Dutch would be our №1 choice. Word count: 4600 words Price: $130-150 Time: 1 week, the deadline is May 15.
...large Telegram channel and groups. The ultimate goal is to invite these subscribers to my own channel. Key Results: - Extract or scrape customer data from specified Telegram channels or Groups. - The type of data required is mainly (phone number - user) - Extracting data from private channels or groups - Provides a complete list of extracted customers - Ensure customer data is ready to easily import into my channels for invitations Ideal Skills & Experience: - Proficiency in web scraping tools and techniques - Experience with Telegram algorithms - Experience with Telegram API or similar platforms - Proven track record in handling and managing large amounts of data - Strong communication skills to provide detailed project proposals Please ensure that your application contai...
I'm seeking an experienced PHP Symfony developer with expertise in Doctrine ORM and MySQL, to help build various functions within our SaaS. - Objective: The main goal of this project is to build up several functions within our existing SaaS platform. - Design Guidelines: You are required to follow specific design guidelines that are already in place for this SaaS platform. Ideal Candidates: - Proficiency in PHP and Symfony with a focus on building and extending SaaS platforms. - Experience with Doctrine ORM and MySQL is a must. - Strong understanding of security principles especially around key/token use. - Experience building headless systems that are for integration with over API. - Ability to follow existing design guidelines while implementing the required functio...
