Lukket

Make a project about a dental clinic

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)

Evner: Software Arkitektur, Testning / QA, Windows Skrivebord

Se mere: project dental clinic, dental clinic code, dental clinic project source code, wordpress, c# programming, asp.net, hospital management project java source code, dental clinic logo maker, dental clinic computerize system vb6, windows mobile project gps source code, grid computing project visual basic code, project calorie calculator code, dental clinic world, dental clinic design, dental clinic logo samples, java project ffmpeg source code, automated system dental clinic vb6

Om arbejdsgiveren:
( 0 bedømmelser ) United Arab Emirates

Projekt ID: #15562337

14 freelancere byder i gennemsnit $176 på dette job

$250 USD in 3 dage
(39 bedømmelser)
5.6
carlosperezit

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 Flere

$222 USD in 10 dage
(25 bedømmelser)
4.7
$155 USD in 3 dage
(4 bedømmelser)
4.3
imagicaworld

Hi! While reading your project description, It’s proud to say that we can demonstrate our professionalism on the highest level. we are ready to assist you day and night, 24/7. Relevant Skills and Experience >>>>Please Flere

$155 USD in 3 dage
(27 bedømmelser)
4.3
$155 USD in 3 dage
(3 bedømmelser)
3.2
durgesh8527

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 Flere

$150 USD in 7 dage
(0 bedømmelser)
0.0
CodingWorld90

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 ha Flere

$222 USD in 3 dage
(0 bedømmelser)
0.0
$111 USD in 7 dage
(0 bedømmelser)
0.0
maboulmagd

Hi, this is an already existed endoscopy information system with code and database [login to view URL] I can turn it to a dental management system in few days if interested please contact me Relevant Skills a Flere

$222 USD in 3 dage
(0 bedømmelser)
0.0
$155 USD in 7 dage
(0 bedømmelser)
0.0
AhmadKhaled99

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 Flere

$155 USD på 1 dag
(0 bedømmelser)
0.0
s250030iva

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 appl Flere

$155 USD in 10 dage
(0 bedømmelser)
0.0
vishalrchauhan

I give you complete solution as per your requirement

$200 USD in 10 dage
(0 bedømmelser)
0.0
datotahost

Hi, We will do this for [login to view URL] have oracle expert ready to do this work. Please let me know the Relevant Skills and Experience oracle Proposed Milestones $155 USD - oracle

$155 USD in 3 dage
(0 bedømmelser)
0.0