Database Design Jobs

130 were found based on your criteria {{ paging.total|number:0 }} were found based on your criteria

show all
  • Hourly ({{ jobTypeController.getFacetCount("0")|number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("1")|number:0}})
Hourly - Intermediate ($$) - Est. Time: 1 to 3 months, Less than 10 hrs/week - Posted
I require a database containing approximately 10 tables, I will require simple forms for data entry aswell. I also need the database to be accessible via the web, only for myself, not customers. I have Design tables and relationships already. I can also provide screen mockups of the form layouts. This database is for a new food processing business, and will require ongoing work with modifications and editing as business grows. Please note the attached images depict parts of the database I have started in Access just to show my ideas. Access does not have to be used for this project, freelancer can make database in any software.
Skills: Database design database programming Microsoft Access Administration Microsoft Access Programming
Fixed-Price - Intermediate ($$) - Est. Budget: $100 - Posted
I am looking for an experience FileMaker developer who can take our existing (non-filemaker) app and create a fully functioning application. The system will essentially be a CRM system. I have found a template a developer could use (FM Starting Point). You can use this place to start or build a new one from scratch. Please give me details on your experience and be able to show your previous work. Give me ideas, suggestions and let me know what you can do for us! Or perhaps, is there anything better than filemaker? I might consider it too. DON'T mind the budget as it will be set based on what we decide to do. Please use the Keyword FMAPP when responding so I know you read the description.
Skills: Database design Database Modeling database programming FileMaker
Fixed-Price - Intermediate ($$) - Est. Budget: $50 - Posted
Problem description: A DVD rental shop requires a database to be created to keep track of its business. Within this database, it needs to keep track of its customer (called "members") details. This includes their name, address, telephone number, membership number and the date they joined on. The shop only rents DVDs to registered members. Each rental lasts for one day only, so a DVD can be rented at most once per day. To help customers search the database, the shop also wishes to record details about the films. This includes the film’s name, the year it was released, the director, the actors that starred in the film, and the price of renting it. The shop will frequently stock multiple copies of popular films. As some customers like to search for the name of the characters that actors play in each movie, the shop wishes to record this information also. The same character can appear in different movies, in each movie it can be stared by different actor. In addition to renting DVDs, the shop will sell ex-rental DVDs after they have been rented for a period of time. Unlike rentals, DVDs can be sold to anybody. Obviously, once a DVD is sold it is no longer available to rent. This should be reflected in the database in some way. Your database should enable to calculate the amount of money they received whenever a DVD was rented or sold, for revenue purposes. Task 1. Develop an ER Model of the above situation. Show clearly the process of developing the model and document any assumptions you make. When developing your model, you should state the attributes that each entity type has, but do not include them in the ER Diagram itself. 2. Map the ER Model developed on to a Relational Model. Clearly show the process used and state the reasons for the choice of primary and foreign keys in your model. Again, document any assumptions made. 3. Check if the model follows the 3rd Normal Form. Even if it does, state why. If it does not, change the model appropriately. 4. Create the database in Oracle and attach all SQL statements in the order of execution, with the output. Note that this database does not need to contain any data.
Skills: Database design
Hourly - Expert ($$$) - Est. Time: 1 to 3 months, 30+ hrs/week - Posted
Looking for someone proficient in website scraping, data scraping for 3 classified-styled websites. Information must be gathered and sorted in a structured website. Must have knowledge of Java Script, databases and must speak fluent English. North Americans and Europeans preferred. This is a project with potential for ongoing work as the business grows. If you feel you have what it takes, please call me directly at 416 899 2409 to get started. John
Skills: Database design AngularJS Data scraping JavaScript
Fixed-Price - Intermediate ($$) - Est. Budget: $250 - Posted
The job is an app for an adress-database. I want to search for persons by zip-code/postal-code (Postleitzahl)/town, city or get location - all with area (Umkreis) in km. Also search is possible by art of job (Tätigkeitsart - 5 types) and by company (Gesellschaft) (select one, multiple choice or all) If you click on one person you see details and you are able to complete data - for example phone-number, mobile, e-mail, company (Gesellschaft), art of job (Tätigkeitsart). Route schedule. It must be possible to edit records and save data. I need also a royalty system for the users. Be creative.
Skills: Database design Android App Store database programming
Fixed-Price - Intermediate ($$) - Est. Budget: $2,000 - Posted
Apply if you had experience building 2-way integration with OTA's such as Expedia, Booking.com or Agoda. You obviously have to be really good with RESTful API development. More specifically, we already have Channel Manager built that integrates with Expedia and Booking.com. We need you to build integration on top the existing app that communicates with myAllocator & Siteminder.
Skills: Database design MySQL Programming
Fixed Price Budget - Expert ($$$) - $250 to $600 - Posted
We are trying to find a solution for a small publisher that owns four websites. Our goal is to create a dashboard for them so they can access their reporting easier. Please see the link for further details and provide us with the information needed. It describes the process that is needed to get the result we need for each month of reporting. We need to create and easier solution for entering the data in the backend. Then a user friendly front end for the client. https://drive.google.com/file/d/0BySt42-L-GoQZXBfaVd2cm91TEk/view?usp=sharing
Skills: Database design Microsoft Access Programming Microsoft Excel
Fixed-Price - Intermediate ($$) - Est. Budget: $80 - Posted
basically, it is the relationship that confuses me and i couldn't fix it. The requirement is when the tyre of the truck needs to be changed and when the truck is fueled, i need to record them - those are the number of tyres that each truck has (extended later), truck number, driver,.............First, i need the access expert, so that i can describe my requirement more in details.
Skills: Database design Data Entry Database testing Microsoft Access Administration
Fixed Price Budget - Expert ($$$) - $4,000 to $6,000 - Posted
The project will deliver a centralised company intelligence repository that enables easy storage and rapid retrieval of information relating to the activities, specialities and geographic scope of companies operating within the international real estate and investment sector. To ensure compatibility with other systems, the database will need to be developed in SQL Server, with all data tools coded in .NET. Over time, the database will provide a universal backbone for a number of public and private directories, intelligence systems and CRM tools and while these will not all form part of the initial phase of development, the long term context of the project may require some consideration. Database Structure The business already holds significant data in various data silos and non-integrated systems. Once the new structure and tool set is complete, the existing data will be migrated, system-by-system. The new database will initially hold 5 types of information: - Company: company-wide information stored at organisation level - Office: branch-level information for one or more offices in a Company - Contact: information pertaining to an individual within an Office or Company - Account: data that defines the parameters of any relationship with our business - Activity: enquiries, meetings, event attendance and other transactional logs During 2015, a piece of work was started to define the database table structure and the relationships between them. While this project was not fully completed, it does provide a useful starting point for the project. Data Associations Companies may have one or multiple office IDs, Account IDs or Contact IDs associated with them. Office IDs have a fixed association with a Company, but may have multiple Account or Contact IDs. Each Contact ID may potentially move between Offices, Companies and/or Accounts. Activity may be specifically associated with a Contact, Account, Office or Company. Database Tools 1. Add Record Critical to the organic growth of the system is the capability for research staff to quickly and easily add new contacts, offices and companies, with minimal effort or cross-checking of records. - Mandatory Fields Very few fields should be mandatory: Company Name and either email or telephone. - Assumed Data Where only one Contact or Office is added for a Company, data can be cross-populated automatically, in order to populate fields such Email, Phone 1 and 2 across both tables. - Potential Matches While the Company ID is the primary key for this data, there should be Ajax matching on certain fields, such as Company Name, URL, email and telephone number, to automatically check for existing records with the same value. 2. Bulk Import A function should be created that allows bulk importing of data, provided it is in a compatible structure. This should be a CSV or Excel file, formatted to match a specified set of column headings. 3. Merge Records As disparate data sources are cleaned up over time, it may be necessary to merge specific records. Ideally, where there are different values for the same field, it should be somehow possible to select which value to retain and which to overwrite 4. Edit Record A single page input form should be used to for editing any data that can be modified manually by the user (with a log of any changes). There is already an existing page for managing our customer information - it may make sense to restructure this page to accommodation any new data fields. 5. Auto Create New data is available daily, as a result of our client campaigns, our outreach activity and our internal marketing. Where responses are created and no match can automatically be found, a new record should be created in the Company / Office / Contact table. 6. Search Database The search module is a key component of the initial functionality. A simple form should allow fast retrieval of matching records, using a variety of parameters to filter the results set, with matches displayed in an easy to digest format. Search fields should at a minimum include the following: Company Class, Country, Geographic Focus, Specialisation, Geographic Areas, Priority, Call List, Status (see below). The results should be presented in a snapshot view, with key data compiled into an easy to digest format, with additional information available as an Ajax call on hover, allowing the user to expand on the information initially presented. Tick a tickbox to add new matches to the pre-selected Call List. 7. Call List Call lists are lists of companies to contact in relation to a specific piece of work. These should be managed from a Job Management page, where they can be created, deleted or retrieved. The retrieve function should be exactly the same as the Search Database results, wwith an additional status filter and a status for each record in relation to the job in question. The statuses should be a simple traffic light system, with Success, Progress, Fail as the 3 settings.
Skills: Database design ASP.NET ASP.NET MVC C#