Scenario 1.

Samantha is in trouble. Shes in charge of putting on Count Draculas dance parties this year. Now Dracula has outlined four different parties - one for each season (Spring, Summer, Fall, and Winter). Samantha has asked herself, why, exactly was she hired for this job? I mean, Dracula had his parties last year...what, exactly, happened to the person who was put in charge of those events? Samantha really wants to do a good job for the count. She knows that Dracula invites two major types of guests, other vampires and, well, people. She also knows that one type of guest needs cleaning up at the end of the party, and the other type doesnt. She knows the count likes different musical acts to perform at each party (Vampire Weekend, and the Hollywood Vampires were the last two musical acts to perform). But, in addition to the musical acts, Dracula likes some additional form of entertainment. She has heard that the last party the Count didnt like having Jenga as a party game (the Count lost!).

Identify the values of the hierarchy of data for this scenario.

Database:

File:

Record:

Fields:

Field Values:

Scenario 2

James is a small business owner who sells pet novelties. You know, products like Darth Vader sweaters for Dogs, Hello Kitty collars for cats - nick nacks. And business has been good! The Pet Collection by James, thats the name of his store, has done so well that James has opened three different stores. Now heres where he needs your help. Two of the three stores have had solid order tracking, but the store at 2252 Westboro Avenue that his sister, Kathy, manages has repeatedly missed orders. This problem has gotten big enough that Kathys store has gone from a five star Google ranking to a four star Google ranking. James does not want to see that store drop to a three star. So hes going to start taking a more hands on approach to his ordering system. Hes going to start tracking his suppliers, the products each supplier supplies, which employee fills out the products of an order, and which store an order was placed at. Hes hoping this hands on approach will solve his issues and get that store a better Google Ranking.

Identify the values of the hierarchy of data for this scenario.

Database:

File:

Record:

Fields:

Field Values: