Tutor profile: Marissa P.
Subject: SQL Programming
What is a foreign key?
A foreign key is a primary key from another table. You can join tables using foreign keys. For example, if you have an "actor" table and a genre table the actor Id, which the primary key of the actor table, could be used in the genre table as the foreign key.
Subject: Microsoft Excel
When would you use a Pivot Table?
A pivot table is used to summarize data. For example, if you are a store owner you may have data such as monthly sales, items sold, customer demographics, etc. You could use a Pivot Table to see what customers by certain types of item and you can also take the average revenue by item. There are various calculation you could do with this data.
Describe the concept of "mutually exclusive".
An event that is mutually exclusive means that it cannot happen simultaneously with another event in the set. For example, you cannot have both a number card and a face card. However, when an event is not mutually exclusive it can happen at the same time. For example, a card can be both a 10 and an ace.
needs and Marissa will reply soon.