Find Jobs
Hire Freelancers

Data mining

£20-250 GBP

In Progress
Posted over 10 years ago

£20-250 GBP

Paid on delivery
Note: The database must be related to a DVD rental company. So please take this into consideration. Futhermore, for part c) the two operations that need to be running using queries are to find "THE MOST POPULAR DVD SOLD" & "CUSTOMERS WHO HAVE LATE FEE CHARGES TO PAY" b) [ROLAP] Draw a star schema diagram including attributes for your data warehouse. Don't forget to underline primary key attributes and include arrowheads indicating the multiplicity of relationships. Write an SQL database schema for your PDA, using the CREATE TABLE commands (Pick suitable datatypes for each attribute). Using INSERT commands to insert tuples. You need to populate the data warehouse with sample data (at least five attributes for each dimensional table and at least three records each table) for manipulating the data warehouse. For this task, you ONLY need to submit the star schema diagram, and the populated tables. c) [ROLAP] Starting with the base cuboid [e.g., student, module, semester, lecturer], carry out two OLAP operations. For example, what specific OLAP operations should you perform in order to list the average grade of the Data Mining module for each university student in the university scenario? Write and run an SQL query to obtain your list resembling the above example. Provide a screenshot as a proof your query worked.
Project ID: 5262236

About the project

9 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Happy to help you out.... i have read the instructions and can deliver this work in couple of days.... please communicate to discuss on the project. Thanks
£100 GBP in 3 days
4.9 (14 reviews)
4.3
4.3
9 freelancers are bidding on average £125 GBP for this job
User Avatar
10+ years experience. 600+ projects completed successfully. I am very interested in this project. Please send me complete details. Ready to start ASAP.
£199 GBP in 7 days
4.5 (15 reviews)
4.0
4.0
User Avatar
Hello I saw your job post for data mining, and I am very interested in this project. I've been creating database for many growing companies and schools that i could let you have a look at as well freelancer writing for 3+ years, and would have no problem providing you with the high quality work you need. All my work is 100% my own, and never copied, spun or plagiarized, so you won’t have to worry about that at all. In addition, I can easily meet your deadlines. I am bidding £180 for this project. If you are interested in discussing it further, please let me know. Thank you Timothy Kamau Kenya
£200 GBP in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hi, Is this some kind of course work? I can help you if you have interest. I have a basic movie rental database. Are you able to tell us a bit more about the limit of number of days a customer can keep the video. Then we could workout the late fees. C is completely different database! may need the database. regards Nizam
£150 GBP in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can help you with this job. I have big experience with VBA in MS Office and I have interested in this type of work.
£90 GBP in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
£55 GBP in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Watford, United Kingdom
5.0
1
Member since Dec 26, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.