Visit www.teradatauniversitynetwork.comand download the dimensional modeling tool located under the downloadable software section. Use this tool to draw your answers to Problems and Exercises 9-28, 9-30, 9-31, and 9-34. Write a report that comments on the usefulness of this modeling tool. What other features would you like the tool to have? Is this tool better or worse than other database diagramming tools you've used (such as Visio, SmartDraw, ERWin, or others)? Why or why not?

Exercises 9-28

Exercises 9-30

Transcribed Image Text:

CourseSection Attributes: CourselD, SectionNumber, CourseName, Units, RoomlD, and RoomCapacity. During a given semester, the college offers an average of 500 course sections. Attributes: ProfID, ProfName, Title, DepartmentID, and DepartmentName. There are typically 200 professors at Millennium at any given time. Professor 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).