Homework

Homework Questions? Ask a Tutor for Answers ASAP

Ask an Expert,
Get an Answer ASAP!

I have an sql assignment due Thursday and i dont even know…

Customer Question
I have an sql...

I have an sql assignment due Thursday and i dont even know how to start by reading the directions

Tutor's Assistant: Have you begun working on a solution? What SQL code do you have so far?

Is there a way to send attachments?

Tutor's Assistant: What are the full requirements for this task? How soon do you need it completed?

4. Modify Marina_Slip to have foreign keys. Marina_Num should reference Marina and Owner_Num should reference Owner. For both, on update cascade and on delete no action.
5. Modify Service_Request to have foreign keys. Category_Num should reference Service_Category and Slip_ID should reference Marina_Slip. On update cascade and on delete no action.
6. List the slip ID, boat name, owner name, category description, and number of hours estimated on each service request for Electrical systems.
7. How many Sprite boats are stored at each marina? List the Marina number and number of Sprite boats.
8. For every service request category, list the category description, the number of requests for that category, the average estimated hours, and the average spent hours (only include spent hours in the average when the number of spent hours is not 0) – be sure to format appropriately.
9. List the names for all owners, in alphabetical order, who have a boat in a slip that is larger than the average slip.
10. List the marina name, length, and calculate the total rental fees Alexamara receives each year based on the length of the slip for each marina.
4. Modify Marina_Slip to have foreign keys. Marina_Num should reference Marina and Owner_Num should reference Owner. For both, on update cascade and on delete no action.
5. Modify Service_Request to have foreign keys. Category_Num should reference Service_Category and Slip_ID should reference Marina_Slip. On update cascade and on delete no action.
6. List the slip ID, boat name, owner name, category description, and number of hours estimated on each service request for Electrical systems.
7. How many Sprite boats are stored at each marina? List the Marina number and number of Sprite boats.
8. For every service request category, list the category description, the number of requests for that category, the average estimated hours, and the average spent hours (only include spent hours in the average when the number of spent hours is not 0) – be sure to format appropriately.
9. List the names for all owners, in alphabetical order, who have a boat in a slip that is larger than the average slip.
10. List the marina name, length, and calculate the total rental fees Alexamara receives each year based on the length of the slip for each marina.

Submitted: 2 months ago.Category: Homework
Show More
Show Less
Ask Your Own Homework Question
Answered in 2 hours by:
5/2/2018
Tutor: LogicPro, Engineer replied 2 months ago
LogicPro
LogicPro, Engineer
Category: Homework
Satisfied Customers: 13,496
Experience: Expert in Java C++ C C# VB Javascript Design SQL HTML
Verified

Hi,

Welcome

Hope you are doing well.

Zip all files; upload the zipped file to http://wikisend.com and post download link here.

Ask Your Own Homework Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a tutorLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask Scott Your Own Question
Scott
Scott
Scott, MIT Graduate
Category: Homework
Satisfied Customers: 3,040
3,040 Satisfied Customers
Experience: MIT Graduate (Math, Programming, Science, and Music)

Scott is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here.

DianeDallas, TX

< Previous | Next >

Meet the Experts:

LogicPro

LogicPro

Engineer

13,496 satisfied customers

Expert in Java C++ C C# VB Javascript Design SQL HTML

Manal Elkhoshkhany

Manal Elkhoshkhany

Tutor

4,556 satisfied customers

More than 5000 online tutoring sessions.

Linda_us

Linda_us

Finance, Accounts & Homework Tutor

3,138 satisfied customers

Post Graduate Diploma in Management (MBA)

Chris M.

Chris M.

M.S.W. Social Work

2,698 satisfied customers

Master's Degree, strong math and writing skills, experience in one-on-one tutoring (college English)

F. Naz

F. Naz

Chartered Accountant

2,190 satisfied customers

Experience with chartered accountancy

Bizhelp

Bizhelp

CPA

1,887 satisfied customers

Bachelors Degree and CPA with Accounting work experience

Seanna

Seanna

Tutor

1,781 satisfied customers

3,000+ satisfied customers, all topics, A+ work

< Previous | Next >

Related Homework Questions
Please Pass To LogicPro I have previously completed project
Please Pass To LogicPro I have previously completed project 1 attached also for your ref... Would like this completed by Wed of this week. In this project you will perform the physical design and impl… read more
LogicPro
LogicPro
Engineer
13,496 satisfied customers
Unit 5 – Creating Extended Classes and Finishing the ProjectHarbor
Unit 5 – Creating Extended Classes and Finishing the Project Harbor View Mooring wants to modify the demonstration program to more closely match their actual setup. Although most of their mooring slip… read more
Mr. Wilson
Mr. Wilson
Teacher
Master\u0027s Degree
200 satisfied customers
HVM wants to keep a list of their customers. The information
HVM wants to keep a list of their customers. The information they store for each customer is their name, a customer identification number, their address, phone number, what boat number they own (which… read more
LogicPro
LogicPro
Engineer
13,496 satisfied customers
1. An Insert command is issued on a table that results in
1. An Insert command is issued on a table that results in the following Oracle error: “Integrity constraint violated – Parent Key not found”. What is the cause of this error and how can it be fixed? 2… read more
LogicPro
LogicPro
Engineer
13,496 satisfied customers
222mk, This assignment has two parts: a. Hands-on lab
This assignment has two parts: a.Hands-on lab b.Course project Part I—Hands-on Lab Write the following SQL statements in Microsoft Access by using the Books database from Week 2 Assignment 2. Once com… read more
Expert
Expert
can you help me with these sql questions. Using the Northwind
can you help me with these sql questions. Using the Northwind database, write a SQL SELECT statement that will retrieve the data for the following questions: 1. Display the character constant 'Greetin… read more
John
John
Software Engineer
509 satisfied customers
In this project you will perform the physical design and implementatio
In this project you will perform the physical design and implementation using SQL Data Definition Language (DDL) and proceed with populating the Mom and Pop Johnson Video Store database via Data Manip… read more
John
John
Software Engineer
509 satisfied customers
The DBA asks for help in planning the data archive for the
The DBA asks for help in planning the data archive for the following Alexamara database. Marina (MarinaNum, MarinaName, Address, City, State, Zip) Owner (OwnerNum, LastName, FirstName, Address, City, … read more
SusanAthena
SusanAthena
Research analyst, tutor
Master\u0027s Degree
24 satisfied customers
CMIS420 – Advanced Relational DatabasePROJECT 2 – Mail-Order
CMIS420 – Advanced Relational Database PROJECT 2 – Mail-Order Database Overview: Use SQL, PL/SQL, and Triggers to design and create a Mail-Order Database System. Please create your own data for testin… read more
TheDoctor
TheDoctor
Software Engineer
Master\u0027s Degree
9 satisfied customers
In this project you will perform the physical design and implementation
In this project you will perform the physical design and implementation using SQL Data Definition Language (DDL) and proceed with populating the Mom and Pop Johnson Video Store database via Data Manip… read more
LogicPro
LogicPro
Engineer
13,496 satisfied customers
Complete the task described in review questions 7.4 - 7.7 on
Complete the task described in review questions 7.4 - 7.7 on pages 299-301 of your textbook. Make sure you read through and follow the instructions preceding the actual questions. (The instructions be… read more
Raj
Raj
SAP ABAP Consultant
Master\u0027s Degree
27 satisfied customers
Create Oracle database tables using using a table given.
Project 2 Details: 1. Create Oracle database tables using SQL Data Definition Language (DDL) for each table listed in Project 1. Make sure that entity and referential integrity are enforced by declari… read more
ehabtutor
ehabtutor
C.E.O
Bachelor\u0027s Degree
12 satisfied customers
Hello,I need help with this project....It is due on Sunday
Project 2 Details: 1. Create Oracle database tables using SQL Data Definition Language (DDL) for each table listed in Project 1. Make sure that entity and referential integrity are enforced by declari… read more
ATLProg
ATLProg
Sr Software Engineer
Master\u0027s Degree
46 satisfied customers
The Mail-Order Database consists of the following tables and
The Mail-Order Database consists of the following tables and attributes. Please ensure that all constraints are created when creating the tables. All constraints other than NOT NULL constraints must b… read more
TheDoctor
TheDoctor
Software Engineer
Master\u0027s Degree
9 satisfied customers
I need the following question answered by Sunday evening? 1. Create
I need the following question answered by Sunday evening? 1. Create an ORDERS_(your initials) table based on the following:. ORDID NOT NULL NUMBER(4) ORDERDATE DATE COMMPLAN VARCHAR2(1) CUSTID NOT NUL… read more
jatechexpert
jatechexpert
Master\u0027s Degree
1 satisfied customers
In this project you will perform the physical design and
In this project you will perform the physical design and implementation using SQL Data Definition Language (DDL) and proceed with populating the Mom and Pop Johnson Video Store database via Data Manip… read more
TheDoctor
TheDoctor
Software Engineer
Master\u0027s Degree
9 satisfied customers
List the marina number, slip number, and boat name for boats
List the marina number, slip number, and boat name for boats whose owner owner lives in Glander Bay but whose type IS NOT Sprite 4000. Find the service ID and slip ID for each service request whose es… read more
ATLProg
ATLProg
Sr Software Engineer
Master\u0027s Degree
46 satisfied customers
I need some assistance on using and running SQL*Plus. Here
I need some assistance on using and running SQL*Plus. Here are the basic steps: Step 1: Within SQL*Plus, list names of the tables that you have created whose name starts with MM. (Hint: use data dicti… read more
C.Martin
C.Martin
IT Consultant
Bachelor's Degree
453 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x