Find Jobs
Hire Freelancers

Multiple SQL Questions

$30-250 USD

Ditutup
Disiarkan hampir 10 tahun yang lalu

$30-250 USD

Dibayar semasa penghantaran
Database Questions Answering various questions from writing SQL queries, drawing Entity–relationship model (ERR) diagrams, schema design, multiple SQL diagram design patterns, answering various database questions in business English and create simple demonstration applications to showcase database knowledge. A strong knowledge in English and SQL is required. High quality independent work is required. 16 questions in various formats listed above. Some questions have multiple sections. Around 60 questions total. A full list of questions will be sent to the winning bid. Some sample questions: 1. Use Oracle Forms, or write a program (using PL/SQL and/or Java), to display the following report for a given patient (the user will only enter the patient number). Patient Number: _______________ Patient Name: ______________________ Care Centre Name: ___________________ Name of Nurse-in-Charge: ___________________ Treatment ID Treatment Name Physician ID Date ___________ ___________ ___________ ___________ . . . . . . . . . . . . 2. Consider the concurrent execution of the following transactions. List two problems that may occur from the concurrent execution of these two transactions. 3. Consider the following three relations: TRAVEL_AGENT (name, age, salary)

CUSTOMER (name, departure_city, destination, journey_class)

TRANSACTION (number, cust_name, travel_agent_name, amount_paid) Write SQL statements to answer the following questions. Compute the number of different customers who have a transaction. Display the name of the oldest travel agent. List the total number of transactions for each travel agent. Consider only those transactions where the amount paid exceeds 1 000. Display the names and ages of the travel agents who have arranged journeys for customer “John Smith”, in descending order of age (use a subquery). Display the names and ages of travel agents who have arranged journeys for customer “John Smith”, in descending order of age (do not use a subquery). 4. Consider the following dimensions, dimension attributes, and dimension sizes for Farm Coop-Insurance. Member(member_ID, Name, Address). On average, there are two members for each policy and item covered by the policy. InsuredItem(Item_ID, Description, Coverage_Type). There is an average of ten covered items per policy. CoopOffice(Office_ID, Address, Manager_name). Each policy is registered and managed by only one office of the cooperative. Policy(Policy_ID, Type). The company has approximately one million policies at the present time. Approximately five percent of these policies experience some change each month. Period(Date_Key, Fiscal_Period). The length of the fiscal period is one month. The decision system reports are supposed to be based on five years of data. Claim(Claim_ID, Claim_Description, Claim_Type). The facts to be recorded for each combination of these dimensions are: Policy_Premium, Deductible, and Monthly_Claim_Total. 1. Design a star schema for this problem. 2. Using the assumptions stated above, estimate the number of rows in the fact table. 3. Estimate the total size of the fact table (in bytes), assuming an average of 5 bytes per field.
ID Projek: 5974719

Tentang projek

16 cadangan
Projek jarak jauh
Aktif 10 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
16 pekerja bebas membida secara purata $152 USD untuk pekerjaan ini
Avatar Pengguna
Hi, First of all thanks for posting such a project. I am oracle certified developer and dba with more than 7 years of experience. I am expert in database design. ERD, DFD, Physical schema, normalization etc. I did lots of similar projects in freelancer. I am expert in SQL, PL/SQL. I did lots of oracle project in freelancer. http://www.freelancer.com/u/smshafiqulislam.html I am confident on delivering quality. If you wish, I can show you my existing projects. Rgds, Shafiq
$166 USD dalam 3 hari
5.0 (19 ulasan)
4.6
4.6
Avatar Pengguna
La propuesta todavía no ha sido proveída
$155 USD dalam 3 hari
5.0 (10 ulasan)
3.6
3.6
Avatar Pengguna
Hi, I have been working as Database Analyst Programmer more than 10 years. I became OCP, CCNP, RHCE 3 years back. Earlier I completed B.Sc. Enng and M.Sc. Engg both in computer engineering. Check my works here https://www.freelancer.com/projects/Software-Architecture-Engineering/Entity-Relationship-Diagram-ERD.html https://www.freelancer.com/projects/PHP-HTML.1/Database-Project.html https://www.freelancer.com/projects/database-administration/Database-Coursework.html I'm looking forward to hearing from you very soon
$155 USD dalam 3 hari
5.0 (5 ulasan)
2.9
2.9
Avatar Pengguna
I have bachelor and master degrees in IT. My Primary skills include Java, VB/.NET, Delphi, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
$30 USD dalam 1 hari
5.0 (4 ulasan)
1.1
1.1
Avatar Pengguna
A proposal has not yet been provided
$88 USD dalam 3 hari
5.0 (1 ulasan)
0.0
0.0
Avatar Pengguna
Hi.. I am Nikhil. I have working experience of 3+ year in Oracle Queries manipulation. I have done graduation and working on SQL from 3 years since my college days.. Now I am working in a company. I have done work on: 1. Functions and Procedures 2. Triggers 3. Index 4. PL/SQL atleast send me a message... Please give me a chance to work with you. Let start conversation so you get to know about my skills and ability. Please give me a chance to do work with you and I am promising you that you will not disappoint by me. If you need any help after project then I will be here. Please give a chance to conversation with you. I am waiting for your positive response. Thank you Very much.
$100 USD dalam 3 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hi, I would like to take up this task and provide quality result in minimal time. Hoping to hear from you soon Techno Verstand
$50 USD dalam 3 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I have more than 10 years of experience in designing/developing software applications. I have worked on various Databases including Oracle, MS SQL Server and MySQL.
$200 USD dalam 3 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
A proposal has not yet been provided
$333 USD dalam 10 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hi. My name is Javier (from Spain). Strong knowledge of Oracle, DB2 and PostgreSQL database desing, and application build. Serious and I deliver my job on time
$250 USD dalam 7 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I am an experienced, certified Oracle developer. In the past I have worked for 10 years as university lecturer teaching programming, databases, system analysis and design and Object oriented analysis and design. Using my skills and knowledge as both a programmer and teacher, I will use the shortest time possible to deliver the best solutions. contact me ASAP.
$150 USD dalam 2 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
We are a bunch of 20 yrs experience resources in oracle and SQL. We are very well equipped with our own set of questionnaire which can help you on this project requirements... Requesting you to please accept our offer.
$222 USD dalam 3 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
5 years IT profession database developer in china before I came to new zealand. very skillful on sql.
$88 USD dalam 3 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
A proposal has not yet been provided
$111 USD dalam 4 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I am done with such projects and delivered with 100% accuracy. Rest assure you the delivery with as requested. Hope this assignment set our professional relation to work in future.
$111 USD dalam 3 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
18 years of programming experience. I think I am the right person for this project. If you allow me, I should be returned you confidently.
$222 USD dalam 5 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
Hi, I'am a professional database administrator. I can provide high qualty work. sincerely yours, Eric
$150 USD dalam 4 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I am having 6 years of extensive experience SQL server and ERM . I can complete all 60 questions in 5 days.
$177 USD dalam 3 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
A proposal has not yet been provided
$155 USD dalam 3 hari
0.0 (0 ulasan)
0.0
0.0

Tentang klien

Bendera INDIA
faridabad, India
0.0
0
Ahli sejak Ogo 28, 2008

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.