Find Jobs
Hire Freelancers

Make a project about a dental clinic

$30-250 USD

Cerrado
Publicado hace más de 6 años

$30-250 USD

Pagado a la entrega
I need you to develop some software for me. I would like this software to be developed for Windows using SQL. Project, dental clinic database 7 sections (1) .cover page and table of content *What's the nature of the business *what kind of data they need to keep and manage *what's the business rules they want to implement (2) . Overview of the dental clinic and case scenario (3) . Diagram * Er diagram * at least 6 entities (events or objects) that describe the business environment * the attributes or facts about each of the entities identified. (make sure that you include all important attributes) * the relationship that exists between the entities (1:1, 1:M or M:M relationship) * suitable names for the relationships in your ER diagram ) * the primary key for each table in your model *the foreign key(s) where applicable (4) . The relational model Convert the er diagram into relational model (with foreign keys identified correctly. Make sure you convert all entities into relational tables. (5) . SQL statements (DDL&DML) In this you need to use [login to view URL] to create an oracle database according to the relational model in section 4. To create this database,and do all the following *write the required DDL statements to create the database tables *choose a suitable data type for each one of your fields *create the needed primary key constraints *create the needed FK constraints *show your understanding of using the following constraints (NOT NULL, CHECK and UNIQUE) *Populate the database tables with a reasonable number of records (6) . SQL statements (query) *For each one of the queries, explain what the query does by writing a question that the query should answer, the question should be logical and meaningful *write an sql statement that can answer the question *10 different queries should include the use of the following 1. Arithmetic operations 2. Distinct 3. Concatenation 4. Comparison operations 5. BETWEEN... AND 6. AND 7. OR 8. NOT 9. IN 10. LIKE *PROVIDES SCREEN CAPTURES AS EVIDENCE OF COMPLETING THE TASKS (7) . SQL script file (code of the above)
ID del proyecto: 15562337

Información sobre el proyecto

14 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
14 freelancers están ofertando un promedio de $176 USD por este trabajo
Avatar del usuario
I'm an expert in .Net technologies and SQL Server. I have been working in software development for the last 20 years I'm a specialist in web solutions and desktop applications Habilidades y experiencia relevante I'm an expert in .Net technologies and SQL Server. I have been working in software development for the last 20 years I'm a specialist in web solutions and desktop applications Htos propuestos $222 USD - Milestone
$222 USD en 10 días
5,0 (25 comentarios)
4,7
4,7
Avatar del usuario
Hi, I am Pallavi here, Hope you doing well ! I have gone through the project detail and i want to discuss on some points for the clear understanding. I believe in quality work and timely deliver. Relevant Skills and Experience I have 8 years experience in Web Design & Development. Dedicated to Wordpress, Joomla, HTML5, CSS3, E-Commerce-Websites, PHP, Laravel, MySQL and Graphic design. Proposed Milestones $150 USD - Open
$150 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
NO UPFRONT PAYMENT REQUIRED..! Hello, Sir I can do this job.I am Software Engineer and Good Web developer, Please visit my portfolio. i can make the dental clink software for you. Relevant Skills and Experience I have hands-on experience in HTML5, CSS3, Bootstrap 3, jQuery, PHP, MYSQL, Wordpress, Magento, NopCommerce, ASP.Net, C#, VB.NET, Angular JS, Desktop Applications, SMS Solutions and more.... Proposed Milestones $222 USD - For milestone we need to first discuss and create road-map of all features if you are Looking for some quality person who knows the importance of quality and timely delivery
$222 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have good experience in projects like as this business ( EMR "Electronic medical records " , EDR "Electronic dental records" ) at health care business Relevant Skills and Experience Testing / Qa Desktop testing Database testing Proposed Milestones $155 USD - Testing / Qa Desktop testing Database testing
$155 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
As per your request I can able to finish on time using the given below tools Oracle Apex with Express data base (Free Version) No need to Pay any license (Purely free Tools) Relevant Skills and Experience These application can work on browser itself,It can able to connect through Lan system can able to connect multible system. Proposed Milestones $155 USD - Oracle Apex Additional Services Offered $1 USD - Free support after implementation (Next Three Months),Meantime we can give training to user. $1 USD - They can able to develope further requirement $1 USD - Able to develope number of reports from user itself Waiting for your confirmation Thanks Siva
$155 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I give you complete solution as per your requirement
$200 USD en 10 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED ARAB EMIRATES
United Arab Emirates
0,0
0
Miembro desde nov 4, 2017

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.