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