Find Jobs
Hire Freelancers

Make a project about a dental clinic

$30-250 USD

Kapalı
İlan edilme: 6 yıldan fazla önce

$30-250 USD

Teslimde ödenir
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)
Proje No: 15562337

Proje hakkında

14 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 6 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
14 freelancer bu proje için ortalama $176 USD teklif veriyor
Kullanıcı 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 10 gün içinde
5,0 (25 değerlendirme)
4,7
4,7
Kullanıcı 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 7 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı 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 3 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı 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 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı 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 10 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
I give you complete solution as per your requirement
$200 USD 10 gün içinde
0,0 (0 değerlendirme)
0,0
0,0

Müşteri hakkında

   UNITED ARAB EMIRATES bayrağı
United Arab Emirates
0,0
0
Kas 4, 2017 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.