Database for the Hospital
33 USD The application should contain a database layer and an application layer written in PL/SQL, respectively in T-SQL.The goal is not to write a user interface.The application should contain a suitable number of interrelated tables.A suitable number is 7-10 tables plus/minus according to the application type.1 .Table Definition: For your application you need to have a few tables for different substances.Here are a few examples:
- Patients (patient_id, name, address, date_birth, contact)
- Doctors (doctor_id, name, specialization, contact)
- Palaces (room_id, type_palace, capacity, price_for_day)
- Medicines (medicine_id, name, type, price)
- Treatment (treatment_id, name, description, price)
- Connection_Patient_Doctor (patient_id, doctor_id, date_start, date_end)
- List of medications (patient_id, medicine_id, number, date_publishing)
Book_id (booking_id, patient_id, room_id, date_start, date_end)
The 2ndDefinition of primary, external and candidate keys: For example, 'patient_id' would be the primary key in the Table of Patients, while in the Table of Connection_Patient_Doctor 'patient_id' and 'doctor_id' would be the external keys that are referred to in the Table of Patients and Doctors.3 .Indexing: To optimize requests, you can create indices on key columns such as patient_id, doctor_id, etc.and 4.Defining integrity limits: These may be restrictions such as "price cannot be negative", "the start date cannot be later than the end date" etc.and 5.Create triggers: You can use them to automatically update or validate data.For example, you can create a trigger that automatically calculates the number of free rooms when adding or deleting a reservation.6 .Create Types: You can create Types that show complex information, such as "List of Patients and their relevant medications" or "List of Doctors and their Patients".7 .Create procedures and functions: You will need to create a number of procedures and functions for data manipulation.For example, you could have procedures for adding a new patient, planning treatment, calculating total treatment costs, monitoring the patient’s condition, etc.8thScenarios for scheme creation, data input, generations and statistics removal, scheme removal and testing functions: These scenarios are needed to manage the database and demonstrate the functionality of your solution.In the files you can find a few examples of the execution of parts of the project.Other examples can be sent personally through platform restrictions.
Applications 6
-
30 days33 USD
688 7 0 30 days33 USD
Welcome to!
I can make a program on Lazarus/FPC or Delphi, for Windows/Linux, I have great experience in developing programs of this type.
Shortly about myself: I have worked as a programming professional in medicine for almost 19 years, so I know quite well the specification of the program. I have a number of developed programs to work with different databases, the level of knowledge of English - Intermediate (I read technical documentation freely, watch videos in English, lack experience of live communication).
As for prices and deadlines, you can discuss having technical tasks in full volume.
-
40 days891 USD
1880 29 0 40 days891 USD
Hello to you.
Experience in development over 15 years.
Fast databases, client-server applications, convenient interfaces and other technologies.
I can perform your task as a server application client in Windows with all the necessary automation and visualization.
-
1 day33 USD
3526 51 2 1 day33 USD
Good day . My name is Alexander. I have 3 years of business experience using .net technology. I worked as a backend developer, so I often had to deal with the database. Experience in the design of databases. I’m going to do your project quickly and efficiently, write!
-
1 day33 USD
715 3 0 1 day33 USD
and greetings. I am a Python developer for 3+ years. I have experience with relational (sql also orm) bd, web development. We need more details about how it is to be implemented. There should be just a bd or a web service or other service to work with a bd. The time of execution and the cost can be estimated in the messages.
-
1 day33 USD
8193 63 1 1 day33 USD
Hello Catherine,
I have a great experience in developing PHP, mysql (more than 6 years), and I work with JS, jQuery, Vue.js, html, css.
Ready to discuss details to clarify prices and deadlines and begin right now.
I hope for cooperation.
-
Доброго дня, Катерина.
Можливо, вартість в доларах а не гривнях?)
-
Current freelance projects in the category Databases & SQL
Heal the 1C configuration
111 USD
Configuration of CRM & ERP SmartCeiling (2.8.26.0) Protection via Registration Code. Registered until the end of the year. Databases & SQL ∙ 14 hours 23 minutes back ∙ 7 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 5 days 13 hours back ∙ 11 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 6 days back ∙ 6 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 9 days 7 hours back ∙ 16 proposals |
Accounting, planning, and sales system for a mushroom farm
601 USD
Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 11 days 11 hours back ∙ 61 proposals |
Ukraine