Homework

Homework Questions? Ask a Tutor for Answers ASAP

Ask an Expert,
Get an Answer ASAP!

Homework
This answer was rated:

Based on our operational database, movie distributing and renting

system (focus on movie distribution...
Based on our operational database, movie distributing and renting system (focus on movie distribution and sale), build a data mart (star schema) which can answer the following questions:

1) Which movie and\or movie category has the better sales by months and\or quarters?

2) Which distributor had best or better earnings (suppose profit margin is 12% for all the distributors) by months and\or quarters??

3) Which store should be the better sale target for movie sale?
Show More
Show Less
Ask Your Own Homework Question
Answered in 3 hours by:
5/4/2013
TheDoctor
TheDoctor, Professional w/Adv. Degree
Category: Homework
Satisfied Customers: 1,757
Experience: M.S. in Internet Information Systems
Verified
Hello and thank you for using JustAnswer. It would be my pleasure to assist you with this.

In order to do this, I will need to see the original database, the "movie distributing and renting system."

Please provide whatever SQL you have for this system. If you have a functional database, you can send me the dump/export of that database.

Which DBMS are you using for this project? (e.g., MS SQL Server, MySQL, Oracle)

When you gather your documents, please zip them up and upload them to http://ge.tt

Once uploaded, you will be given a link on the right. Click on the 'Copy Link' option and then paste it here.

Thank you
Ask Your Own Homework Question
Customer reply replied 4 years ago


hi,


I uploaded them. It is oracle with sqlplus

Customer reply replied 4 years ago

http://www.ge.tt/7CBvXqf/v/0?c

Thank you,

I will contact you once this is complete.
Ask Your Own Homework Question
Customer reply replied 4 years ago

Also, could you help me with the last part of same assignment?




    • usethe movie distributing and renting system database as the data resource to extract the useful data for your data warehouse. Data range is about 1 year or 365 days.



 




    • based on the requirement to extract data and manipulate the data in a way to fit your dimension and facts tables. For example, there is no cost data for each movie distributor bought. You need to calculate it based on assumed profit margin.



 




    • build a temporary data stage area to store the data generated from the data extraction and manipulation from the database.



 




    • design and build a star schema with dimensions and facts tables. Poopulate the tables with the data in the data stage area.

    • develop stored procedures or SQL scripts to show the answers to the business intelligence questions. This is in fact to analyze the data in your data warehouse and generate Business intelligence reports to support a mission-critical decision making process.


Hello again,

 

Generally, if you have additional work to your original question, you should enter it as a second question. This addition about triples the amount of work to be done. If you need this other part along with your original request, then I will not have the time to assist you.

 

When asking a question, please enter the entire question. Had I seen this other part, I would have known that I would not have enough time to assist. If you would still like the first part from your original question, just let me know. I apologize that I cannot complete all of these additional requirements for you. I simply do not have the necessary availability to provide you with the excellent service that you deserve.

 

Again, let me know if you would still like me to send you the first part. Have a wonderful day.

Ask Your Own Homework Question
Customer reply replied 4 years ago


yes...thank you. please assist with 1 part

Hello again!

You can download the star schema for the original question here:

http://wikisend.com/download/297096/star.sql

It includes three dimension tables and one fact table. Let me know if you have any questions. I'm here to help.

Please remember to rate my answer. Thank you so much!
Ask Your Own Homework Question
Customer reply replied 4 years ago


Thank you so much. Great, but what about the sql queries to answer this


 


1) Which movie and\or movie category has the better sales by months and\or quarters?


2) Which distributor had best or better earnings (suppose profit margin is 12% for all the distributors) by months and\or quarters??


3) Which store should be the better sale target for movie sale?

The question was not for SQL statements for those question. The question you entered was:

"build a data mart (star schema) which can answer the following questions:

The dimensions that exist with a star schema are highly dependent on what the desired data will be. In no place in your question did you ask for queries for each of those questions. You asked for a star schema that will support those questions, which is what I provided. Do you also need queries? I don't see that anywhere in your question.
Ask Your Own Homework Question
Customer reply replied 4 years ago


yes

Alright, I will send you queries. Although, that is rather abnormal. You wouldn't just write queries in a data warehouse. You would create views.

Building a star schema to support desired data and building the views/queries for the desired data are completely different tasks.
Ask Your Own Homework Question
Customer reply replied 4 years ago


thank you.

This answer is protected
Would you like to ask this question?
If you've already paid for this answer, simply Login.
TheDoctor
TheDoctor, Professional w/Adv. Degree
Category: Homework
Satisfied Customers: 1,757
Experience: M.S. in Internet Information Systems
Verified
TheDoctor and 87 other Homework Specialists are ready to help you
Ask your own question now
Customer reply replied 4 years ago


hi,


 


SELECT DISTINCT
FIRST_VALUE(td.ORDER_MONTH) OVER (ORDER BY mof.TOTAL_SALES DESC) AS Month,
FIRST_VALUE(mof.MOVIE_TITLE) OVER (ORDER BY mof.TOTAL_SALES DESC) AS TITLE,
FIRST_VALUE(mof.TOTAL_SALES) OVER (ORDER BY mof.TOTAL_SALES DESC) AS SALES
FROM MOVIE_ORDER_FACTS mof
JOIN TIME_DIMENSION td
ON mof.TIME_ID = td.TIME_ID;


 


what do you mean with first_value is that the name of the variable

Ask TheDoctor Your Own Question
TheDoctor
TheDoctor
TheDoctor, Professional w/Adv. Degree
Category: Homework
Satisfied Customers: 1,757
1,757 Satisfied Customers
Experience: M.S. in Internet Information Systems

TheDoctor 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

5,731 satisfied customers

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

Manal Elkhoshkhany

Manal Elkhoshkhany

Tutor

4,551 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,636 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,161 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
Just wanted to see if you would be interested in helping me
Hello Again! Just wanted to see if you would be interested in helping me with two more programs? I will attach the Program outlines and the Word documents. Please let me know if you would like to help… read more
George Sibiya
George Sibiya
PhD
217 satisfied customers
6. How many worksheets display in the Excel window when you
6. How many worksheets display in the Excel window when you create a new blank workbook? A. 3 B. 2 C. 4 D. 1 Student Answer: A Answer: Incorrect Reference: Objective 2.17. What would be a situation in… read more
AnswersByEric
AnswersByEric
Software Developer
Associate Degree
37 satisfied customers
Question 18 of 20: Select the best answer for the question.
Question 18 of 20 : Select the best answer for the question. 18. What size paper should you use for a legal document? A. 3″ × 5″ B. 8½″ × 11″ C. 7¼″ × 10½″ D. 8½″ × 14″… read more
JA Engineer
JA Engineer
Broadcast Engineer
Diploma (Honors)
163 satisfied customers
I need help with Exam Number: 00701400 Lesson Name: General
I need help with Exam Number: 00701400Lesson Name: General Math I, Study Unit 2 Pennfoster test… read more
GLENN
GLENN
Master of Mathematics
343 satisfied customers
Answer all three questions and don't exceed 600 words for
Answer all three questions and don't exceed 600 words for each answer while using at least two references to support your answers for each question adopting APA citation in the text and in the referen… read more
F. Naz
F. Naz
Chartered Accountant
CA Finalist & Completed B.com
2,161 satisfied customers
QUESTION 1 A(n) _________________ policy are codified as
QUESTION 1A(n) _________________ policy are codified as standards and procedures that are used when configuring or maintaining systems.0.10000 points Save AnswerQUESTION 2In systems analysis and desig… read more
F. Naz
F. Naz
Chartered Accountant
CA Finalist & Completed B.com
2,161 satisfied customers
I need all the questions answered inthis pdf! I need all
I need all the questions answered inthis pdf! I need all sixty questions on all 21 pages answered!… read more
Steven, M.Acc.
Steven, M.Acc.
Instructor
Master\u0027s Degree
252 satisfied customers
Exam Number: 584002RR I need all t he questions answered in
Exam Number: 584002RR I need all t he questions answered in excel in this pdf file now! Asap!… read more
The-PC-Guy
The-PC-Guy
Bachelor\u0027s Degree
629 satisfied customers
How do you differentiate between an expression and an
How do you differentiate between an expression and an equation? Provide an example of each, where the two are either related to or similar to each other. … read more
GLENN
GLENN
Master of Mathematics
343 satisfied customers
Duane will use an open system LAN because he knows the open
Duane will use an open system LAN because he knows the open system will support varieties of hardware and software components made by different vendors. Steve will use a closed system LAN because he k… read more
F. Naz
F. Naz
Chartered Accountant
CA Finalist & Completed B.com
2,161 satisfied customers
IT 278 Network Administration 1. Server roles and features
IT 278 Network Administration 1. Server roles and features can be added and updated through both a GUI installation and a Server Core installation. In a short essay, explain how to use Windows PowerSh… read more
David L.
David L.
Bachelor\u0027s Degree
6 satisfied customers
For LogicPro only. need help with this debugging to input it
For LogicPro only.need help with this debugging to input it into raptor// A high school is holding a recycling competition // This program allows a user to enter a student's // year in school (1 throu… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,731 satisfied customers
I need the answer key to penn american literature, 986174RR
I need the answer key to penn foster american literature, 986174RR 986175RR 986176RR 986177RR 986178RR … read more
GLENN
GLENN
Master of Mathematics
343 satisfied customers
For LogicPro only * Reading data strings from a file *
For LogicPro only* Reading data strings from a file * Convert from int based container to templates or generics based * Accommodate dynamic resizing using this algorithm: 1. Starting with a dynamic si… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,731 satisfied customers
Question 1 of 20: Select the best answer for the question.
Question 1 of 20 : Select the best answer for the question. 1. For what type of document would you use the landscape page orientation? A. Three-column brochure B. Business letter C. Legal contract D. … read more
Cher
Cher
JustAnswer Expert & Mentor;Teacher/Tutor
Masters Degree
1,381 satisfied customers
5 - 5 x 5 +5. What is the answer to 5 - 5 x 5 + 5? Only that
no, only that two people using order of operations keeps getting different answers… read more
GLENN
GLENN
Master of Mathematics
343 satisfied customers
Only for F.Naz Tutor. Kindly help with a research report,
Only for F.Naz Tutor.Kindly help with a research report, the links is http://www.mediafire.com/file/bmcea6dt278nw8w/report.txt… read more
F. Naz
F. Naz
Chartered Accountant
CA Finalist & Completed B.com
2,161 satisfied customers
If I did not look at the description which says 4 cpu cores
if I did not look at the description which says 4 cpu cores and 6 gpu core to make TEN I wonder if you can bundle the two to make an advertisement that says 10 core I also have others in the same fiel… read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,124 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