Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Star schema for student database

06/12/2021 Client: muhammad11 Deadline: 2 Day

Star Schema Question

The Scenario
Music University has asked you to help them to design their student performance data mart. Your requirements elicitation with the clients has determined that they are interested in answering questions such as:

· Number of students in each unit in each year

· Number of students who have come to Music from various other institutions (e.g., how many students from Singapore Polytechnic, Republic etc) and which Music courses they have enrolled in.

· Number of students in each unit offering (i.e., ICT394 in Semester 1 2018, is a different unit offering to ICT394 in Semester 2 2018) by year.

· Grade distributions of students in units by year

· Grade distributions of students in units by offering and year

· Grade distributions by Lecturer by unit and offering

· Grade distributions by Course

· Grade distributions by School

· Grade distributions by Previous Institution (e.g., Results for students in IT courses from SP, etc).

There are a number of data sources from which you will need to draw your data. Below are the sources and the tables within them that are/may be of interest to you. These are discussed below (Primary Key, Foreign Key):

Source 1: Course Handbook

The Course Handbook is a FileMaker Pro Database. It contains data regarding all courses, units and offerings of units that are offered by Music University. A course is made up of units, and a unit will have at least one offering each year.:

COURSE (CourseCode, Version, CourseName, SchoolName)

UNIT (UnitCode, CourseCode, Version, UnitName)

UNIT_OFFERING (OfferingNumber, UnitCode, Year, TeachingPeriod)

OFFERING_COORDINATOR (StaffID, UnitOfferingNumber)

Source 2: Student Information System

The Student Information System has its data stored in a relational DBMS (Oracle) at present.

STUDENT (StudentID, StudentName, DateOfBirth)

ENROLMENT (EnrolNumber, StudentID, UnitOfferingNumber, Grade)

Source 3: Human Resources System

The HR System is a proprietary system that is owned by the HR Department.

STAFF_MEMBER(StaffNumber, StaffName, SchoolCode)

SCHOOL(SchoolCode, SchoolTitle)

Source 4: Credit Database

The Credit Database records where students have studied prior to attending Music, and the amount of credit they receive toward their Music degree. The data are stored in a relational DBMS (MySQL) that was developed as a student project at Music.

STUDENT (StudentNumber, Student Name)

PREVIOUS_INSTITUTION (Institution_Code, Institution_Name, Country)

COURSE (Institution_Code, Course_Code, Course_Name)

PREVIOUS_STUDIES (StudentNumber, Institution_Code, Course_Code, Credit_Points)

TO DO:

TASK 1 (): Based on the list of questions the client wants answered (see above), discuss what you see as being the most appropriate level of granularity for your data warehouse. Your discussion will need to explain why you have made this choice, and why the alternatives have been discarded. This should take not more than one (1) page.

TASK 2 (): Design a Star Schema that will support the analyses as listed above.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

24/7 Assignment Help
Instant Assignments
Isabella K.
Homework Guru
Innovative Writer
Peter O.
Writer Writer Name Offer Chat
24/7 Assignment Help

ONLINE

24/7 Assignment Help

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$45 Chat With Writer
Instant Assignments

ONLINE

Instant Assignments

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$40 Chat With Writer
Isabella K.

ONLINE

Isabella K.

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$20 Chat With Writer
Homework Guru

ONLINE

Homework Guru

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$48 Chat With Writer
Innovative Writer

ONLINE

Innovative Writer

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$15 Chat With Writer
Peter O.

ONLINE

Peter O.

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$30 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Nwcs cps staff portal - Final Research Paper - Oak cabbage palm hammocks - Mentee action plan example - Chemical reaction word equations - Intel itanium 2 processor - Mrs frisby and the rats of nimh questions and answers - 3m chrome pinstripe tape - Discussion: Contemplation and Consideration - 900 x 600 paving slabs jewsons - Por qué fueron maru y miguel a un restaurante - Markett com sams club - Do you ever feel like a misfit - Sba sample english - Wicky wacky woo meaning - Journal 1 - The virtual evolution stickleback lab answers - Dorma el 301 price - Pearl products limited of shenzhen china manufactures and distributes - How to read minitab output - 2012 sor hsc paper - Tectonic map of hypothetical ocean basin - Reliance r12 security system - Which adjective best describes lincoln's diction in the gettysburg address - Dekuuna code of the ancients - Reaction paper about magna carta - Frosted flakes marketing strategy - Bmw corporate sales program discount - MGT312T Week 2 Discussion - GGPLOT - How to write an analytical commentary - Ib economics test your understanding answers macroeconomics - 4 characteristics of all living things - Choose a topic from Micro economics that matters to you and find a recent news article covering that topic. - 5a capper place kardinya - G549 continuity of operations program manager course - Excel for supply chain management - Community trust bank ruston - Article critique - Imagery in the second coming - Www mcgraw hill co uk textbooks jobber - Burger king corporation case study - Life after life jill mccorkle summary - Isaca risk it framework - A walk to remember poem - Jill mccorkle her chee to heart - Racial integration - Final Essay - FUNDAMENTALS OF FINANCE - Which one of the following is not clinical decision support - Women and newborn - North face brand analysis - What project management software did arnold palmer utilize? - Hells angels melbourne sgt at arms - Lumo login my account - Recognise and utilise diverse perspectives - Watch a video - 495 week 5 - Annotated the road not taken - Tautology and contradiction in discrete mathematics - Obedience to society's rules crossword clue - How to install metal ceiling battens - Descriptive epidemiology paper - Hardening Techniques Responses - How to create a successful brand speech - Pender's health promotion model explained - A job cost sheet shows information about each of the following items except: - What role do audiences play in creating popular culture - Can someone write an essay for me? Thanks - Lamborghini and ferrari logo - Hurricane katrina the storm that drowned a city quizlet - 10 strategic points grand canyon university - Bulletproof diet food list - Hydrogen bonds between adenine and thymine - Identify the bsha core courses - Alabama airlines case study simulation solution - Wagga csu campus map - Greece uncovered katie and terri - Hogan's heroes season 6 episode 23 youtube - Case study on selection with solution - ME - Online - Dis 3 - Essay - All my own work - Led beer pong table - Clapham manor swimming pool - De quervain's tenosynovitis splint chemist warehouse - Dynamic and pitch ranges expanded and tempi varied dramatically because - Guidelines for data entry screen design - Science Activity - Bluecoat proxy technical interview questions - Aldous huxley writing style - Poem for my 43rd birthday - Formula of manganese iv oxide - Apnea rx harvey norman - Psy 410 week 2 worksheet answers - Topic Selection & Developing a Thesis - Buy Powerful Magic Rings For Money-Fame and Luck IN SOUTH AFRICA - Charles motuzick son of tracey thurman - Assignment - Assessing Client Progress