Question: - Create a star schema diagram using the following attributes or column names Attributes/column names: FacultyID, First Name, Last Name, Department, classroomID , buildingName, Classroom,

- Create a star schema diagram using the following attributes or column names

Attributes/column names: FacultyID, First Name, Last Name, Department, classroomID , buildingName, Classroom, Capacity, StudentID, CourseID, Mark, Grade, Registered, Course name, credit description, classID, academyyear, semester, weekday, time block, sex, major lastName, firtsname

using the following as table names

-DimFaculty

-DimClassroom

-classfacttable

-DimStudent

-DimSchedule

-Dimcourse

- Create a database diagram with relationships between tables that reflect your revised design using the same attributes listed

-Explain the reasons for the new structure i.e Describe the changes you made in the design and why you made those changes

- Show a picture or screenshot/ sketch of the design created

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Provide the $QL for the following data requests. Your SQL should be written as a single script that can be pasted into MySQL and run without edits. Make sure you use the proper notation for your...

[10 pts] What is data normalization? [10 pts] What is the main purpose of data de-normalization? [10 pts] What are the categories of data models? Explain them briefly. [15 pts] What is data...

Narrative/Case Study For this lab, you will be creating SQL statements to build a series of relational tables, using SQL CREATE statements in a script file format for the Student Database. You will...

School of Computing and Information Technology Session: Spring 2023 University of Wollongong Lecturer: Janusz R. Getta ISIT912 Big Data Management Assignment 2 Published on 21 August 2023 Scope The...

Auto Dealership PINEVIEW FORD is organized as follows: - Dealership keeps track of Vehicle Identification number of every vehicle that is for sale, sold, or serviced by the dealership. - Vehicles are...

you will create a star schema for Bobs Fixit case study. The star schema will allow Bob to get a better understanding of his customers. Here are the requirements for the star schema. Bob would like...

In this case, you are given conceptual and relational schema of an operational database in a credit card company for its customers as follows. Figure 3. Creidt Card Company Website Log CustName...

The relational schema below defines an operational system of a university Bold and Capital = Name of Entity Underlined attribute(s) primary key(s) Asteriskede attribute(s) = foreign key(s) 1 m...

STEP 1: Create a star schema diagram that will enable Helping Hand to analyze the donations they receive The fact table will include: for every individual donation - the amount made. The star schema...

Use the star schema you queried last week to create a star schema for the Bob's Fixit Group Case Study. The star schema needs to support the the analysis or measurement of bid dollar amount by...

Random company pays their employees weekly. The following information is for the week ended January 7, 2020. Anything over 40 hours is paid as overtime. FICA-SS rate is 6.2%. FICA-MC rate is 1.45%....

Complete the balance sheet and sales information using the following financial data: Debt ratio: 50% Current ratio: 1.8( Total assets turnover: 1.5( Days sales outstanding: 36.5 daysa Gross profit...

1. Identify the fallacies of relevance committed by the following arguments, giving a brief explanation for your answer. If no fallacy is committed, write no fallacy. Th e position open in the...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...