Tamamlanmış

Oracle, sql and database experience

Using the data model and the database design which depicts the following entities:

• PATIENTINFO table with the following columns:

1. PatientID

2. FirstName

3. LastName

4. Address

5. City

6. State

7. ZipCode

8. Phone

9. Email

10. MemberID

Select the proper data type, size and the proper null/not null constraints as needed. In addition you need to assign primary key.

• PATIENTMHIS table with the following columns:

1. RecordID

2. TreatmentHist

3. CardioHist

4. PulmoHist

5. AlergyHist

6. BloodHist

7. Hospitalization

8. CurrentMedication

9. SurgeryHis

Select the proper data type, size and the proper null/not null constraints as needed. In addition you need to assign primary key

• IMAGINGORDER table with the following columns:

1. OrderNumber

2. ImDate

3. Organ

4. Reason

5. Diagnosis

Select the proper data type, size and the proper null/not null constraints as needed. In addition you need to assign primary key

• LABORDER table with the following columns:

1. LabOrderNumber

2. OrDate

3. ReqBloodTest

4. Reason

Select the proper data type, size and the proper null/not null constraints as needed. In addition you need to assign primary key

• INUSRANCEINFO table with the following columns:

1. MemberID

2. GroupID

3. Provider

4. ProviderPhone

5. ProviderAddress

Select the proper data type, size and the proper null/not null constraints as needed. In addition you need to assign primary key

1. Write the proper SQL Code to create all tables shown in the design above. Remember to include the Null/NOTNULL, Primary Key, and Foreign Key constraints, and use the proper data type with the proper size. Use the proper columns to connect the tables with each other creating relational database (Hint: I used the MemberID to connect PATIENTINFO and INSURANCEINFO, you need to connect the other tables the way you properly see it)

2. Write the proper code to insert at least three lines in each table.

3. Add CHECK constraints to the INSURANCEINFO to limit Provider column to be within the following group only (United, AvMed, Blue Cross Blue Shield, Medicare, Medicate)

4. Create a view (using VIEW statement) that displays patient name from the PATIENTINFO table and lab order information from the LABORDER table.

5. Take a snap shot of Oracle showing all the previous steps been created successfully and paste in the word document.

Beceriler: Veri Tabanı Yönetimi, Veritabanı Geliştirme, Microsoft SQL Server, Oracle, SQL

Daha fazlasını gör: add multiple users sql database, use bids import csv sql database, export sql database csv using vb6, oracle database, oracle sql database, oracle sql tutorial, oracle sql live, oracle sql database download, oracle sql developer tutorial, oracle sql vs mysql, oracle sql download, accessing sql database aspnet web form using, primavera use sql database, import csv sql database using dts, rdbms experience using sql server 2005, add fields existing sql database, add sql database joomla, sql server database manipulation using macro, use google map api sql database, import data sql database using fifo

İşveren Hakkında:
( 19 değerlendirme ) port orange, United States

Proje NO: #19289976

Seçilen:

usman1493

Hello Sir A database design and development is here I have good advance expertise in database design and SQL queries Feel free to message me This is an initial bid Regards

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(21 Değerlendirme)
4.7

Bu iş için 19 freelancer ortalamada $113 teklif veriyor

truongnguyen86

Hello there, i'm expert on Oracle, i've been working with Oracle for over 9 years, let me help you with this. 5 task i think i can finish it soon as well as i can make the report if you wish to. Waiting for your respon Daha Fazla

$150 USD in 3 gün içinde
(181 Değerlendirme)
6.9
AliSafder

Dear Sir, My name is Ali and I can complete the project with immediate availability. Let me create entities and show you desired results and pasting them to word. Let us have a quick discussion over the projec Daha Fazla

$40 USD in 3 gün içinde
(27 Değerlendirme)
4.5
kipdev13

Hi, Sir. I am very interested in your work. I am expert in Database. I have 9 years of experience in Database. I love web. If you hire me, i'll do my best for you and I'll finish in time. Best regards.

$50 USD in 3 gün içinde
(9 Değerlendirme)
3.9
prakash2813

Hi there, I have strong expertise in database management, plsql, dynamic queries, pivot tables, database normalization, umls and more. I have read the details. This is an easy job for me. Message me, I would like t Daha Fazla

$150 USD in 2 gün içinde
(4 Değerlendirme)
3.8
MHassanBedor

Hi, I'm Oracle developer for many years. I developed many applications using many tools like Toad, Oracle Form Builder, Oracle Report Builder. Looking forward to work with you. Regards.

$100 USD in 5 gün içinde
(7 Değerlendirme)
3.1
AlexeyKala

Web(WordPress, CSS, HTML, PHP, Website Design, CI, Laravel ) expert whom you find is here. I have 5+ years rich experience in developing web sites using various frameworks. You can see my skill through these sites wh Daha Fazla

$150 USD in 3 gün içinde
(1 Yorum)
2.2
MichealSMoreno

Dear client. I've read your project description carefully and very interested. Have tiny questions on your project. Let's discuss over chat and get started. Waiting for your reply. Best regards.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
1.7
bluestar1027

You just got good luck. Don't worry about your project. I have over 7 years experience of this field. I have enough passion , strength and endurance. I will my best to make clients satisfied with Daha Fazla

$50 USD in 3 gün içinde
(2 Değerlendirme)
1.4
kournilam91

Hello, Hope your doing well! I am Senior Software developer having more than 5 yrs of experience. My skills are PHP, Codeigniter, Laravel, Node JS, MySQL, HTML, CSS, Bootstrap, Wordpress, Javascript/jQuery,MySQL. Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
ergauravgupta07

My name is Gaurav Gupta I have 7.5 years of experience in asp.net c# SQL server technology I have done my Sitecore certification. Currently I m working with niit technologies Relevant Skills and Experience Asp.net c# Daha Fazla

$222 USD in 5 gün içinde
(0 Değerlendirme)
0.0
contactmejayw30

I am a post graduate and have my specialization as Information Security.I am aware of SQl, No SQl etc Please consider my candidature.I have 3.5 years work experience with SQl databases.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
osrootofos

An Oracle DBA / Apps DBA with 8+ years of experience on Windows / Unix platforms. I have strong DBA skill and have worked on multiple Oracle Technologies. I have experience on production support, upgrades, platform m Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
sagom

Software engineer with a postgraduate in software development and I have extensive experience in the development of web and mobile software, I have worked with business intelligence projects based on Microsoft technolo Daha Fazla

$133 USD in 2 gün içinde
(0 Değerlendirme)
0.0
marianakuzmich

Hi. Nice to meet you here. Before I worked on database engine development team. I have 5+ years experiences. So I know database engine source code well. like mysql, postgresql, mongodb, oracle, sqlite... Database ma Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
OneStopTech

we have expert team of oracle and data base Hi our team is ready for this work we will provide you quality service More than 400 project completed 50 people working in our team all are highly professional our team is Daha Fazla

$155 USD in 3 gün içinde
(0 Değerlendirme)
0.0
pandakjm

Hi Thanks for job posting and I read your description carefully. really database dev expert. I hope work with you because my skill set is very suitable to your Job and i can start now. I am confident to finish proj Daha Fazla

$155 USD in 3 gün içinde
(0 Değerlendirme)
0.0
albertpopov46

Dear sir. I have read your description with great interest. I have experiences with many project. Also I am able to finish the task in time. If you send me a message, we can discuss more. I am waiting for your r Daha Fazla

$150 USD in 3 gün içinde
(0 Değerlendirme)
0.0
vippyshrm

I am having 6+ yeqrs of experience in PLSQL development and Database Development. Designing and Data flow control are the main aspects of my primary skills. Love to work with you.

$111 USD in 2 gün içinde
(0 Değerlendirme)
0.0