Millennium College (see Problem and Exercise 9-28) now wants to include new data about course sections: the
Question:
Millennium College (see Problem and Exercise 9-28) now wants to include new data about course sections: the department offering the course, the academic unit to which the department reports, and the budget unit to which the department is assigned. Change your answer to Problem and Exercise 9-28 to accommodate these new data requirements. Explain why you implemented the changes in the star schema the way you did.
Transcribed Image Text:
Attributes: CourselD, SectionNumber, CourseName, Units, RoomlD, and RoomCapacity. During a given semester, the college offers an average of 500 course sections. CourseSection Professor Attributes: ProfID, ProfName, Title, DepartmentID, and DepartmentName. There are typically 200 professors at Millennium at any given time. Student Attributes: StudentID, StudentName, and Major. Each course section has an average of 40 students, and students typically take five courses per period. Period Attributes: SemesterID and Year. The database will contain data for 30 periods (a total of 10 years).
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 47% (19 reviews)
Another dimension table was added with the department information This wi...View the full answer
Answered By
Sheikh Muhammad Ibrahim
During the course of my study, I have worked as a private tutor. I have taught Maths and Physics to O'Level and A'Level students, as well as I have also taught basic engineering courses to my juniors in the university. Engineering intrigues me alot because it a world full of ideas. I have passionately taught students and this made me learn alot. Teaching algebra and basic calculus, from the very basics of it made me very patient. Therefore, I know many tricks to make your work easier for you. I believe that every student has a potential to work himself. I am just here to polish your skills. I am a bright student in my university. My juniors are always happy from me because I help in their assignments and they are never late.
4.90+
14+ Reviews
24+ Question Solved
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Question Posted:
Students also viewed these Computer Sciences questions
-
Simplified Automobile Insurance Company would like to add a Claims dimension to its star schema (see Problem and Exercise 9-30). Attributes of Claim are ClaimID, ClaimDescription, and ClaimType....
-
Transform the relational schema developed in Problem and Exercise 9 into an EER diagram. State any assumptions that you have made.
-
Take the query you scrapped from Problem and Exercise 9-45 and modify it to show only the U.S. region grouped by each quarter, not just for 2005 but for all years available, in order by quarter....
-
Ghana Water Company Limited (GWCL) Profile Ghana Water Company Limited (GWCL) is a utility company, fully owned by the State. The company is responsible for potable water supply to all urban...
-
The mean age of the 43 presidents of the United States (as of 2011) on the day of inauguration is 54.6 years, with a standard deviation of 6.3 years. A researcher constructed a 95% condence interval...
-
A cylindrical rod of diameter 14.7 mm fabricated from a Ti-5Al-2.5Sn titanium alloy (Figure 8.20) is subjected to a repeated tension-compression load cycling along its axis. Compute the maximum and...
-
A healthcare company decides to market a hand warmer. It is basically a palm-size plastic pouch containing a supersaturated aqueous salt solution; that is, the amount of dissolved salt exceeds its...
-
Adcock Company issued $600,000, 9%, 20-year bonds on January 1, 2014, at 103. Interest is payable semiannually on July 1 and January 1. Adcock uses straight-line amortization for bond premium or...
-
Applying analytical synthesis of mechanisms, design a four-bar mechanism to move the object shown in the figure, through the three positions indicated in their numbered order without taking into...
-
Jimmy owns a garden in which he has planted N trees in a row. After a few years, the trees have grown up and now they have different heights. Jimmy pays much attention to the aesthetics of his...
-
You are to construct a star schema for Simplified Automobile Insurance Company (see Kimball, 1996b, for a more realistic example). The relevant dimensions, dimension attributes, and dimension sizes...
-
As mentioned in the chapter, Kimball (1997), Inmon (1997, 2000), and Armstrong (2000) have debated the merits of independent and dependent data marts and normalized versus denormalized data marts....
-
Object A has ten times the inertia of object B. They approach each other with relative velocity \(\vec{v}_{A B}\) and collide elastically. For each object, draw a velocity-versustime graph for the...
-
Consider the utility function U(X,Y) = 2X+2XY+2Y. (a) Does the marginal utility of X diminish, remain constant, or increase as the conomer buys more X, holding Y constant? Use derivative(s) to...
-
On June 10, Sheridan Company purchased $7,850 of merchandise on account from Pronghorn Company, FOB shipping point, terms 2/10, n/30. Sheridan Company pays the freight costs of $490 on June 11. Goods...
-
LR decision by a comp firm 1 @ $ Which Q* is chosen? How much is total profit/total loss? MC AC P=AR=MR
-
Please show all work. FINA Inc. considers a project with the following information: Initial Outlay: 1,500 After-tax cash flows: Year 1: -$100 Year 2: $1000 Year 3: $700 FINAs assets are $500 million,...
-
What is a pipeline bubble and why might a branch instruction introduce one or more bubbles? [4 marks] (b) Explain, with the aid of an example, how conditional instructions may be used to reduce the...
-
Initially, 1 lb m of water is at rest at 14.7 psia and 70 F. The water then undergoes a process where the final state is 30 psia and 700 F with a velocity of 100 ft/s and an elevation of 100 ft above...
-
Using the theoretical sampling strategy, how many samples of size 4 (n = 4) can be drawn from a population of size: (a) N = 5? (b) N = 8? (c) N = 16? (d) N = 50?
-
1. Many computer magazines and Web sites present comparisons of several DBMSs. Find one such DBMS comparison and compare the functions in this chapter to the listed features and functions in the...
-
1. The log shown in Figure 7-19 includes four transactions that completed successfully. For each of the four transactions, list the transaction ID and the table(s) modified. Also, list whether the...
-
What is a DBA? Why is this position necessary?
-
Carmaker produces small cars. As production emits pollution, Carmaker needs to buy pollution permits. It also needs to hire labour. Carmaker's production function is given by: (1) q = min{0.05L,...
-
Describe the three key differences between the North American Free Trade Agreement (NAFTA) NAFTA and United States-Mexico-Canada Agreement (CUSMA). Support your answer by providing specific examples.
-
Discuss what is Brexit. Why did the United Kingdom decided to leave the European Union? What is the impact of trade between the U.K. and the E.U. post-Brexit?
Study smarter with the SolutionInn App