Giovanna Corridoni

I think that the star schema approach is a good one but I think that the type of arrangement used depends on the task that needs to be accomplished. I do not think that one is better than another but have […]

In week 6, I learned about dimensional modeling and how it helps to serve a business. We also learned about data cubes and data marts and how they are used to gather and organize specific data. We also looked at […]

In the third week of class, we focused on ERD models and their relationships. We discussed attributes, entities and the cardinalities between attributes. Using tick marks, we represented many to many and one to […]

MGM’s customer interaction model differentiates between the three categories above the comp line: Whales, High rollers and low-level gamers. The whales are treated with the most interaction with the executives as […]

Whales are those who spend thousands to millions of dollars per visit to resorts. The idea of the whale is a person who contributes to all aspects of the resorts profitability and not just one segment. In turn […]

Referential Integrity helps to keep things consistent among tables. If one table has a foreign key linked to another table, it will not allow you to add information that will alter the consistency of the […]

A multi-value attribute can hold more than one value in a field. For example a person has only one age or date of birth. A multi-value attribute could be phone numbers or emails where one person can have multiple.

In the second week of class, I learned a great deal about ERD ( Entity Relationship Management). I have a better understanding of how different entities are linked together. We learned about different types of […]