Customization database trabalhos

Create a relational database for the following data in a single tables with parts store. You may use alphanumeric to represent store and use surrogate key as primary key. Bring a hard copy in class and answer two quires in class. (points Project creation 20 + two query 20) 1. Vendor 1: Low Hardware, 1200 Harding st, Pine Bluff, AR 71602, Phone 870-535-1000 Supplies screw Size Steel Size Unit Price QTY Stainless Steel QTY Unit Price 6-32 Yes ½” .02 300 Yes 100 .04 6-12 Yes 3/4” .03 300 Yes 200 .06 6-32 Yes 1” .04 400 Yes 200 .08 6-32 Yes 1 ¼” .05 300 No 0 .10 6-32 Yes 1 ½” .06 500 Yes 20 .12 8-32 Yes ½” .04 300 Yes 200 .08 8-32 Yes ½” .05 400 Yes 100 .10 8-32 Yes ¾” ...

I'm looking for experienced SAP MM developers to work on procurement, inventory management, and vendor management modules. The project is multi-faceted, requiring a range of specific s...creating customized reports and integrating SAP MM with other systems is crucial. - **Integration:** The project specifically involves integrating the procurement and inventory management modules with a Warehouse Management System. Experience with this or similar integrations is highly desirable. Ideal candidates should have proven experience in SAP MM, with a strong track record in development, customization, and integrations. Experience with Warehouse Management Systems is a plus. Your ability to deliver a seamless system that meets our specific requirements for reporting and integration wil...

...professional with over 30 years experience in the investment markets. I need an experienced tutor in Microsoft Access to assist me with database creation and query design and optimization. The ideal candidate should be able to help me understand: - How to create a well-structured database in Microsoft Access - The best practices for query design and optimization to enhance the efficiency and speed of the database operations You should also be able to provide guidance on: - How to maintain a clean and minimalist design that is easy to navigate - The creation of a user-friendly interface that is intuitive and easy to interact with - The customization of templates to suit specific requirements The completion timeframe is flexible, so I am loo...

...learning platform using Moodle, and while the foundation is solid, there's significant room for enhancement to create a seamless learning experience. We're seeking a skilled freelancer to customize and optimize our platform to leverage its full potential and provide an enriching learning environment for students, teachers, and administrators alike. Project Objectives: 1. Visual and Functional Customization: - Customize the platform's template for enhanced visual appeal and intuitive navigation. - Ensure seamless usability for administrators, teachers, and students. 2. Online Testing Integration: - Implement online testing functionalities to accurately assess learners' current English proficiency levels. 3. Course and Test Samples: - Integrate s...

I'm ...needs to have Product Customization Options added. The desired feature for customization is: - Choice-based customizations: drop-downs or radio buttons Ideal candidates will have a deep understanding of different product types and how to effectively implement them within BigCommerce. Understanding of choice-based customization options is a must for this role. Our product options have cascading drop down selections that are dependent on previous selections. There are also other tasks that will be required to complete the migration of the website. We are looking for a freelancer who can work with us through to launch. Please bid with confidence only if you have previous experience with similar tasks and you're able to tackle advanced product types a...

I'm looking for a skilled developer to integrate a database for our congregation into my Squarespace website. I manage a Hindu temple. Requirements: - The primary purpose of this database will be to store our congregation's contact information. This includes details such as name, email address, and phone number. - The integration should be seamless, with the database easily accessible and manageable through the Squarespace platform (maybe, more like contact information collected from our website). - Prior experience with Squarespace and developing client databases is a huge plus. - We should be able to easily send an email to targeted groups within our database. Please provide your portfolio or examples of similar projects you have completed.

Por favor, Cadastre-se ou Faça Login para ver os detalhes.

We're on the lookout for a proficient Wordpress developer to assist with theme customization, plugin installation, and content update tasks. Experience is pivotal as we're not just looking for someone to get the job done but who can also advise us on better practices and improvements. Key tasks include: - Theme Customization: Help us modify our existing theme to better fit our brand and enhance user experience. It's vital that you have a solid grounding in PHP and CSS. - Plugin Installation: Evaluate, install, and set up necessary WordPress plugins that will add to our site's functionality. - Content Updates: Regularly update site content based on the needs of our evolving business. Given the nature of these tasks, we're not just looking for someo...

I'm seeking a skilled freelancer to integrate and customize the Bitrix24 CRM platform for my business. Your task would encompass three main areas: 1. Contact Management: Streamline and automate how we track, manage, and interact with our contacts. 2. Sales Pipeline Tracking: Develop an efficient tracking system to...accountability. Additionally, a customized calendar that syncs with these functionalities is crucial for our business operation. The CRM will be used by 11-50 users, so it should be user-friendly and scalable to accommodate this number. The ideal freelancer for this project would have extensive experience in Bitrix24 CRM implementation and customization. Strong knowledge in contact management, sales pipeline tracking, task management, and calendar customiza...

...knows how to create Restlets, Suitelets, Suitescript, Mapped Reduce Scripts, Schedule scripts and understands Order to Cash, Item management, integrations and who can handle a range of daily tasks focused primarily on customization and configuration. Ongoing job: - Troubleshoot Netsuite integration issues, workflows, scripts etc. - Configuring and customizing record types and fields - Setting up roles and permissions - Streamlining workflows and processes Ideal candidates should be well-rounded, reliable and have extensive experience in Netsuite configuration, customization, and integration with third-party solutions, plus expertise in scripting and automation. User support and training skills will be an advantage. Ratings must be proof of past netsuite work or other pla...

I'm in search of a MailWizz expert Key responsibilities: - Customizing the user interface design to improve the overall user experience and branding. - Devising a mechanism to manage debits of email credits efficiently. We simply want to add emailing credits to our customers mailbox account and we will add emailing credits the account based upon the amo...We then simply like to debit the credits for each email sent. Very simple. If we give the mailbox user 10,000 credits and they emails 3,000 emails the 3,000 is debited from the 10,000 balance and 7,000 credits are left. We have already configured Mail Wizz with Postfix MTA We own our servers and we wish to integrate the emailing server with our MySQL database. This is the first of many jobs that we will require ...

I'm in need of a WordPress developer to help me with my agency site. I'm looking for someone who can show me their past work immediately. The primary goal of the website is to attract new clients. Key Points: - Need expertise in WordPress customization - Experience in website creation is essential - Ability to present a portfolio of past projects is a must I'm looking for a freelancer who can help me with this quickly. Please only apply if you have prior experience in this area and can show me your work right away.

I am looking for a skilled developer to create a Windows-based application that can interact with a remote database. The application should primarily focus on retrieving and generating website sitemaps based on different criteria. The ideal candidate should have: - Proficiency in Windows application development - Strong experience in working with databases, particularly remote databases - Knowledge in data retrieval and data update functionalities - Ability to understand and incorporate additional requirements as the project progresses Please note that the selected freelancer may need to provide examples of past work and project proposals. Note: Application should be able to connect different type of databases such as MS SQL Server, MySQL, Oracle etc.

I'm facing an issue with my Laravel admin panel, specifically a database table owner error that's occurring when uploading a zip file. - The error seems to be centered around the database table ownership. - The error happens during the process of uploading a zip file. - I can provide more details on the issue if required. I'm looking for a professional with experience in Laravel, database management, and debugging to help resolve this issue. The ideal candidate should be familiar with Laravel's database interactions and be able to navigate and troubleshoot these types of issues efficiently.

I'm in need of a skilled WordPress developer to create a Taskrabbit-style website using HivePress. Here are the specifics: - **Theme Customization**: I'll need the theme to be modified according to my brand. This includes custom logo and branding, as well as color scheme customization. The theme should be attractive and user-friendly. A key component of this project will be your ability to work with HivePress. The ideal freelancer will have experience with custom WordPress development and theme customization. Knowledge of e-commerce and payment integration will also be a plus.

I need a script that can bypass security measures on my website which uses Cloudflare. This is not for any malicious intent, but for testing and troubleshooting purposes. Key Points: - The script should be specifically designed for websites - The main purpose is to bypass Cloudflare security measures - I didn't specify the customization level, as I'm open to options that might suit my needs better Ideal Skills: - Familiarity with Cloudflare security measures and how to bypass them - Ability to create a script that can seamlessly integrate with any website - Experience working with security testing tools or scripts Please provide a proposal that outlines your experience in this area and how you plan to approach this particular project.

I require a WordPress developer to create a website with e-commerce functionality for selling physical goods. Requirements: - We need to implement advanced product customization options. This will be a key feature of the website and is crucial for our customer experience. - The website will be selling physical goods, so experience in creating e-commerce platforms for physical goods is crucial. Ideal skills and experience: - Proficiency in WordPress development - Expertise in e-commerce functionality within WordPress - Experience in implementing advanced product customization options - Prior experience in developing e-commerce platforms for physical goods would be ideal.

Dynamic Field Integration: Addition of customizable fields such as text inputs, date pickers, radio buttons, checkboxes, and select dropdowns within the admin panel. User Registration Form Customization: These dynamic fields will be incorporated into the user registration form, allowing for a more tailored data collection process. Admin Panel Search Functionality: Enhancements to the admin panel to include search functionality that utilizes the newly integrated fields. This will enable admins to search user data effectively based on the customized fields.

...team will be having opprtunity to work for long term! Skills and Experience: - Extensive experience in reporting and analytics!!!*** - Extensive experience in Laravel development - Proficiency in Laravel customization and optimization - Strong understanding of Gitlab - version control !* - Strong understanding of web development principles and best practices - Ability to work on a large-scale project and deliver high-quality results - Excellent problem-solving skills and attention to detail - Database Design & Management: The ability to design and manage a highly organized, efficient database is crucial. - API Integration: We expect the team to integrate various APIs appropriately for a seamless integration of different platforms !!!*** Skills that would be be...

I'm looking for a skilled professional who can assist me in utilizing and customizing to conceal specific account information. Key Requirements: - Use and adjust th... to conceal specific account information. Key Requirements: - Use and adjust the website - Hide the following account details: Username, Password, Personal contact information - Conceal the specified details on three key sections of the website: Account settings, Profile page, Listing details Ideal Skills: - Proficiency in web development - Understanding of website customization - Experience in data privacy and security - Familiarity with or similar platforms This is a critical project for me and I'm looking for a freelancer who can handle it with the utmost care and discretion.

...team will be having opprtunity to work for long term! Skills and Experience: - Extensive experience in reporting and analytics!!!*** - Extensive experience in Laravel development - Proficiency in Laravel customization and optimization - Strong understanding of Gitlab - version control !* - Strong understanding of web development principles and best practices - Ability to work on a large-scale project and deliver high-quality results - Excellent problem-solving skills and attention to detail - Database Design & Management: The ability to design and manage a highly organized, efficient database is crucial. - API Integration: We expect the team to integrate various APIs appropriately for a seamless integration of different platforms !!!*** Skills that would be be...

...designer to help me customize a set of photoshop graphics for my sales funnel. The graphics include various psds that need text, colors, and some background images changed. Your goal is to take the photoshop templates and customize them for my business. The psd files are organized and easy to edit. Key Points: - Customization in Photoshop templates - Required changes: Text, Colors, Images Ideal candidates should: - Have prior experience in Photoshop template customization - Be creative and have a good sense of design - Be able to effectively communicate through email....

I'm looking for a WordPress developer adept in theme customization. Specifically, your task will revolve around modifying color schemes and layouts. Ideally, you should be proficient at both implementing my ideas as well as offering creative suggestions based on your experience. Key responsibilities: - Modify existing theme's color schemes and layouts. - Balance of implementing my ideas and providing creative suggestions. Ideal Skills: - Strong grasp on WordPress theme structure and customization. - Excellent knowledge in color theory and responsive design layouts. - Ability to interpret and implement client ideas efficiently. - Excellent communication skills and creativity for influential suggestions.

I'm in need of an experienced PHP and Wordpress developer to assist with ecommerce website, theme customization, plugin development, and additional tasks relating to Inventory management and Sales tracking. We are embarking on an exciting project to develop an ecommerce website for health products using WordPress, and we need a proficient PHP and WordPress developer who can take on a range of tasks for our ecommerce project. Responsibilities will include: Mastering PHP Coding: Proficiency in PHP coding is essential for customizing and extending WordPress functionality to meet our specific requirements. Customizing WordPress Themes: We require expertise in customizing WordPress themes to ensure they align with our branding and design preferences while maintaining responsive...

I'm in need of an expert web developer to convert my Fi...of an expert web developer to convert my Figma design into a fully functional WordPress website. At this time, I do not have a specific theme selected, suggesting that you'd have the freedom to choose a responsive and compatible theme for the design at hand. Skills & Experience: - Profound knowledge in Figma and its translation into WordPress - Strong understanding of WordPress themes and customization - Ability to preserver design integrity during conversion - Capable of making theme suggestions Please note that I haven't mentioned any specific functionalities - but we can discuss any potential additions later on. Looking forward to receiving your proposals, showing me previous Figma to WordPress con...

I'm seeking a skilled developer who ...main responsibility on the design front involves refining my site's navigation. This implies that you'll need to understand how the navigation menu is currently arranged and accurately remove specific items. - Database Optimization: I am excited to augment the performance of my website. For this, I require optimal reformation of the existing database structure. This task demands proficiency in managing Laravel databases and an understanding of optimization best practices. The ideal candidate for this project is detail-oriented and exhibits a strong understanding of Laravel, database optimization techniques, and UI/UX principles. Knowledge of the latest design trends and how to selectively prune menus for user-frie...

We are an innovative tech company embarking on the creation of SnipeOS, a custom Linux operating system designed to revolutionize user interaction and productivity through a tailored user experience. Project Overview: We are trying to build a custom Linux operating system. The desktop should be almost exactly as follows: to snipesearch, snipepay, snipesocial, auctionit, and TTWRITE in the web menu. Desired Skills and Qualifications: Proven experience in Linux system development, particularly with XFCE. Proficiency in programming languages such as C, C++, Python, and shell scripting. Familiarity with the configuration and deployment of the listed software applications. Experience in system branding and customization for Linux distributions.

...team will be having opprtunity to work for long term! Skills and Experience: - Extensive experience in reporting and analytics!!!*** - Extensive experience in Laravel development - Proficiency in Laravel customization and optimization - Strong understanding of Gitlab - version control !* - Strong understanding of web development principles and best practices - Ability to work on a large-scale project and deliver high-quality results - Excellent problem-solving skills and attention to detail - Database Design & Management: The ability to design and manage a highly organized, efficient database is crucial. - API Integration: We expect the team to integrate various APIs appropriately for a seamless integration of different platforms !!!*** Skills that would be be...

I need assistance adjusting the user access settings on my ITC Protege WX. Specifically, I require help in modifying existing user permissions. This task requires an in-depth understanding of security setup in the ITC Protege WX system. If you possess the mentioned skills and experiences, and can effectively tackle this job, please submit a bid detailing your approach to the task and expected duration.

I need an expert to design a DICOM database specifically for storing and retrieving radiology images. Key requirements are: - Comprehensive understanding of DICOM Standards - Proficiency in database design and administration - Experience in handling medical images, particularly radiology The proposed database should support retrieval of images via Unique Identifier Codes (DICOM's UID). Being well-versed in medical systems integration will be considered a great advantage. This project will require strict adherence to privacy regulations and standards.

...web applications - Strong problem-solving skills and attention to detail Import data from xml sheets into multiple prestashop faced search feature table. Here's an outline of the tasks Script to Parse XML for Nightly Update: This script will run once a night to parse a large XML file provided by the content provider. It will update, add, or remove relevant data in the PrestaShop facet search database tables. The script should be optimized to avoid system slowdowns and long processing times. Script to Parse Product XML Files: The second script. This script will run continuously and parse XML product files located in a specified folder and its subfolders. Mapping of data: Correct mapping between products and relevant categories will be established using XML data and ...

I need skilled SharePoint developer for customization of my SharePoint sites. The focus will be on developing custom web parts, particularly interactive ones. Key Tasks: - Customize SharePoint sites to suit my specific needs - Develop and integrate interactive web parts Ideal candidate would have a strong background in SharePoint site customization, experience in creating custom web parts, and an understanding of interactivity in web elements. Proficiency in SharePoint workflows, lists, and libraries would be a plus.

I need a proficient data specialist to compile a comprehensive database of Romanian companies. - Compatibility: The database must be compatible with Windows and Mac platforms. - Specific Details: Every company's record in the database must contain the company's name, phone number, and email address. - Extent of Database: Aim for a sizable database that contains information about 100,000 companies. Ideal candidates will have experience in data mining and database management, and an understanding of Romanian market dynamics. Strong accuracy and attention to high-quality data is a must.

I need an experienced Wordpress developer who can customize themes and utilize the design builder to give my website a modern and professional look. The site needs to be responsive for mobile devices as well to cater to our members. Key Responsibilities: - Theme customization according to prerequisites - Design Builder implementation Desired Skills & Experience: - Proven experience in Wordpress Development and Design - Expertise in Theme Customization - Ability to design responsive and mobile-friendly websites - Knowledgeable in understanding and aligning with target audience (members) requirements. The desired outcome of these services is not just a visually pleasing interface but also one that resonates with our intended audience. Ideally, my site after completion...

...expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in SQL and MySQL. - Exp...

...expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in SQL and MySQL. - Exp...

Bonjour! I'm looking to lauchand personalize my Houzez Wordpress template. Here's what I need: - Customization: I want to achieve a unique look, so we'll need some color scheme customization and logo and branding integration to align the site with my brand's identity. - Content Restructuring: As part of the launch, the site's structure needs rework. - Setup: The key tasks include installing and configuring the Houzez template. We'll also setup and configure critical plugins including a contact form, an SEO plugin, and a social media sharing plugin. - Custom Design: The header and footer must be customized. Ideally, you're experienced in Wordpress, particularly the Houzez template, PHP, CSS changes, and plugin configuration. Your ability to...

I'm in need of a proficient database specialist to manually collect email addresses and phone numbers, and compile them into an efficient and reliable database system. The leads to be collected are specifically from the Social Media industry. Ideal Skills and Experience: - Proven experience in data collection and management. - Exceptional research abilities, particular in the social media landscape. - Ability to use manual collection methods efficiently and effectively. - Knowledge and understanding of database management and lead generation. - Accuracy and attention to detail in dealing with phone numbers and email addresses. Roles: - Locating and collecting required data from specific direct websites. - Organizing the data into a systematic database...

I'm seeking an expert in Entity-Relationship Modelling and Rational Database Design. Key Requirements: - I need an expert in this particular area. Please only apply if you have a proven track record in both Entity-Relationship Modelling and Rational Database Design. - I'm looking for a high-level overview of the Entity-Relationship Diagram. This means I don't need every minute detail, but rather a clear and concise depiction of the core entities and relationships. - Experience is key. Please share your past work in this field. Ideal Skills: - Proficient in Entity-Relationship Modelling - Experienced in Rational Database Design - Strong track record in this particular project type - Excellent communication and understanding of client needs. Pleas...

Χρειάζομαι άτομο για τη δημιουργία database σε excel

I'm seeking a seasoned freelancer to upgrade my Magento 2.3.1 website to a stable & supported version. The task requires not only the version upgrade, but also ensuring that all existing customizations are well-integrated post-upgrade - preserving their functionality as conceived and constructed. Key Customizations To Be Maintained: - Theme modifications - Extensions integration - Custom modules development Ideal Qualifications: - Experienced in both frontend and backend development - Past experience in similar projects is a strong recommendation. Applicants are encouraged to bolster their proposals with proven instances of their experience. This will greatly assist my selection process. Proficiency in backend and frontend development skills is a firm pre-requisite, as these s...

...team will be having opprtunity to work for long term! Skills and Experience: - Extensive experience in reporting and analytics!!!*** - Extensive experience in Laravel development - Proficiency in Laravel customization and optimization - Strong understanding of Gitlab - version control !* - Strong understanding of web development principles and best practices - Ability to work on a large-scale project and deliver high-quality results - Excellent problem-solving skills and attention to detail - Database Design & Management: The ability to design and manage a highly organized, efficient database is crucial. - API Integration: We expect the team to integrate various APIs appropriately for a seamless integration of different platforms !!!*** Skills that would be be...

I'm in urgent need of a WordPress developer with specif...with specific experience in building dynamic form functionality, available on my home page . Key Tasks: - Develop a dynamic form like my competitor: I require a highly skilled individual to set up a dynamic form on my WordPress website with contact form 7. - Customization: The form needs to be tailored to fit the unique requirements of my website, so experience with theme customization is required. Ideal Skills & Experience: - Proven experience in developing dynamic forms on WordPress - Strong understanding of theme customization - Ability to complete tasks swiftly and effectively. Timeframe: This is an urgent requirement, so we’re looking to have the form fully operational ASAP. Please on...

I need a professional to help me with GST/Billing functionalities in my Tally accounting software. Key Tasks: - Assist in utilizing Tally's GST/Billing features effectively - Ensure my bus...Assist in utilizing Tally's GST/Billing features effectively - Ensure my business's accounting is compliant with GST guidelines - Provide guidance and support on how to manage billing efficiently Ideal Skills and Experience: - Proficiency in Tally accounting software - Extensive experience with GST/Billing - Strong understanding of accounting principles - Good communication and teaching skills Customization of GST/Billing reports is not required, but I appreciate any suggestions or best practices you might have in this area. Your ability to deliver clear, comprehensive guidanc...

I need a Wix expert to finalize my micro website dedicated to promoting a product. I've got a template started, but need professional touch to g...I will provide all text, as well as product descriptions, that need to be incorporated seamlessly and attractively into the site. - *Layout Design*: I will guide you in making modifications to the template's current layout to better showcase my product and fit my vision. - *Page Addition*: We need to create extra pages to organize and present all the information correctly. - *Color & Font Customization*: Though not a must, skills in tweaking colors and fonts to align with my brand's aesthetic are appreciated. A successful freelancer for this project not only has excellent Wix skills, but also an eye for aesthetic app...

I am in urgent need of a Shopify Developer who specializes in product setup. Shopify Store Customization for Mobile Skin Sales Description: We are looking to customize our Shopify store to enhance user experience when purchasing mobile skins. Specifically, we want to add a feature on the product page that allows users to select their mobile phone brand from a dropdown menu. Upon selecting a brand, a second dropdown menu will dynamically populate with models associated with that brand. Users can then select their specific model, providing us with valuable information for their purchase. Requirements: Dropdown Menus: Implement two dropdown menus on the product page—one for mobile phone brands and the other for models. Dynamic Population: Ensure that the model dropdown dynam...

Looking to add a customizable product on our web page so that people can build out their purchase however they see fit, and are able to view what it will look like before they purchase. the website is , and the rose will be the one constant. the customizable add ons are the spirits they choose and the add ons (cigars or chocolates) they choose. theres a video of multiple variations in links below

I'm in need of a WordPress e...is for the purpose of setting up Appointment Scheduling for services on my website. Key responsibilities include: - Installation of the Bookly Plugin - Configuration to facilitate appointment scheduling - Ensuring the plugin functions correctly and integrates seamlessly with my existing WordPress site Ideal skills and experience for this job: - Proven expertise in WordPress development and customization - Experience with installing and configuring WordPress plugins, ideally Bookly - Strong understanding of appointment scheduling systems - Ability to troubleshoot and ensure seamless integration of the plugin with the site This project has the potential for further collaboration on the website based on the successful completion of the Bookly Plug...

I'm seeking a web developer to create a dynamic ecommerce website exclusively for physical jewelry products. Experience in the following areas is desirable: - Ecommerce website development - Understanding of jewelry business - Proficient in creating user-friendly and aesthetic interfaces The website needs to be easy to navigate, with a clear display of our no-customization jewelry products, categorized and detailed properly. It's crucial that it includes standard ecommerce features like a shopping cart, customer reviews, secure checkout, etc. Please only apply if you can demonstrate previous experience in ecommerce website development, particularly for physical products. Your proposal should include samples of your work. Preference will be given to those who have speci...