(a) Changing the design and providing a reason for implementing these changes in the star schema for Millennium college given in problem and exercise 9-37 in order to add new data about course sections as follows: The department offering the course, the academic unit to the department reports, and the budget unit.

Question

Want to see the full answer?

Answer 1

Question

Chapter 9, Problem 9.41PAE

Program Plan Intro

(a)

Changing the design and providing a reason for implementing these changes in the star schema for Millennium college given in problem and exercise 9-37 in order to add new data about course sections as follows:

The department offering the course, the academic unit to the department reports, and the budget unit.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

The management of major-related data is something your department is interested in. Create a data structure that will keep your department's important information current. Of course, the majors list needs to be arranged by last name (and then by first, if there are multiple students with the same last name).

Create an ER model related to the following entities and relationships: Department, Student, Professor, Course, Section, Grade, Major. (For attributes inside each table, you only need to insert several reasonable attributes. No need to have a comprehensive list. For many-to-many relationship, you also need to insert one extra table to handle the many-to-many relationship. The final database design will have more tables than the number of entities listed above.) A given department can offer many courses. A given course can be offered by only one related department. A given course can have many related sections. A given professor can teach many sections. A given section can only be related to one course and taught by one professor. A given professor can have appointment with different departments A given department can have many professors. A given department can offer several majors. A given major can be offered by only one related department. A given student can have several majors. A…

You have been asked to create the logical data model for the Golden Eagle Wholesale Golf Distributors. Golden Eagle distributes golf equipment for various manufacturers to the pro shops at golf courses throughout the state. They store the equipment in a centrally located warehouse and ship to the pro shops based on the purchase orders submitted by their sales staff or ones that are phoned in directly by their customers. Each sales rep is assigned to golf courses within a specific area of the state. What entities, attributes, and relationships would you include in the data model for this organization? You have created an entity relationship diagram (ERD) for an organization's database, and you are preparing to review it with the company's managers to make sure it is complete and correct. The managers do not have technical backgrounds and are unfamiliar with database design. How would you explain the concept of an ERD to these managers to orient them for your review?