Multiple SQL Questions

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.

Habilidades: Inglês (Britânico), Inglês (EUA), Oracle, SQL

Veja mais: writing problem statements, writing patterns, writing agents, user experience design salary, travel smith, travel agent salary, ten questions, system err, sql oracle pl sql, sql in pl sql, sql database business, schema design, sample problem statements, problem statements, pl sql statements, pl sql in oracle, pl sql and oracle, pl sql and, paid travel writing, oracle sql pl

Acerca do Empregador:
( 0 comentários ) faridabad, India

ID do Projeto: #5974719

16 freelancers estão ofertando em média $152 para esse trabalho


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 d Mais

$166 USD in 3 dias
(19 Comentários)

La propuesta todavía no ha sido proveída

$155 USD in 3 dias
(10 Comentários)

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 Mais

$155 USD in 3 dias
(5 Comentários)

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 a Mais

$30 USD em 1 dia
(4 Comentários)

A proposal has not yet been provided

$88 USD in 3 dias
(1 Comentário)

A proposal has not yet been provided

$111 USD in 4 dias
(0 Comentários)

I am having 6 years of extensive experience SQL server and ERM . I can complete all 60 questions in 5 days.

$177 USD in 3 dias
(0 Comentários)

Hi, I'am a professional database administrator. I can provide high qualty work. sincerely yours, Eric

$150 USD in 4 dias
(0 Comentários)

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 in 5 dias
(0 Comentários)

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 in 3 dias
(0 Comentários)

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 off Mais

$222 USD in 3 dias
(0 Comentários)

5 years IT profession database developer in china before I came to new zealand. very skillful on sql.

$88 USD in 3 dias
(0 Comentários)

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 wor Mais

$100 USD in 3 dias
(0 Comentários)

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. Us Mais

$150 USD in 2 dias
(0 Comentários)

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 in 7 dias
(0 Comentários)

A proposal has not yet been provided

$333 USD in 10 dias
(0 Comentários)

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 in 3 dias
(0 Comentários)

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 in 3 dias
(0 Comentários)

A proposal has not yet been provided

$155 USD in 3 dias
(0 Comentários)