Find Jobs
Hire Freelancers

Make a project about a dental clinic

$30-250 USD

Closed
Posted over 6 years ago

$30-250 USD

Paid on delivery
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)
Project ID: 15562337

About the project

14 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
14 freelancers are bidding on average $176 USD for this job
User Avatar
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 in 10 days
5.0 (25 reviews)
4.7
4.7
User Avatar
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 in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I give you complete solution as per your requirement
$200 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED ARAB EMIRATES
United Arab Emirates
0.0
0
Member since Nov 4, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.