Beverage Buddy (BB) is a diabetes-friendly mobile app to track and share beverage information with friends. BB tracks data about teas, coffees, and other drinks to help individuals with diabetes manage their blood sugar levels. You are designing a database to support the core operations of the BB app. The app will track beverages by many different brewers. For each beverage, the name of the beverage and the type of beverage are stored. The type of beverage can be "Tea", "Coffee", "Cider", or "Other" t this time, but new types may be added later. Each beverage is provided by a single brewer. A "brewer" is a company that provides beverages. Brewers must be added to the system by BB staff. (It is not part of the app that you are helping with, but brewers must sign a contract with the BB parent company; therefore, users cannot add brewers or beverages.) Each brewer is assigned a number by the system that is stored along with the company name, address, and date that they were first added to the BB system. If a brewer provides alcoholic beverages, then the brewer's FDA license number, state of licensure, and license expiration date are also kept in the system. Note that the state of licensure is not necessarily the same as the state of their mailing address. Most brewers provide a large number of beverages to the system that users can see. Brewers do not typically provide their menu of beverages to be added to BB until after the contract issues are settled, so it is possible for a brewer to appear in the system before any of their beverages have been added. It is not possible to enter a beverage without specifying which brewer provides that beverage. BB also tracks data on the venues that sell the beverages. Most beverages are available from a wide range of venues. A venue may be any type of bar or restaurant. (Just like brewers, venues also have to contract with the BB parent company to appear in the system, but this is outside the app that you are helping with.) Each venue has a name and address. Venues can also specify a "preference", which is a means of identifying themselves as primarily a coffee shop, tea house, or bar. 

The preference does not limit which beverages are sold at that venue but allows users to easily specify that they are searching for coffee preference venues or tea preference venues. A venue will normally provide many different beverages. Again, due to delays in the entering of data related to venues and beverages outside the BB app, it is possible for a venue to be entered in the system before specifying which beverages it carries. It Iso possible to enter beverages in the system before specifying which venues carry that beverage user of Beverage Buddy must register before using the app. Registration requires providing the user's name (first name and last name), an email address, and date of birth. Users can change or update any of this information later without having to re-register. Users can view all the beverages in the system as well as search for beverages from individual brewers. Beverages can be searched by name, type, color, grams of sugar, total carbohydrates, and sweetener (if any) used in the beverage If a user tries a beverage that is listed in the BB app, they can add it to their "drink list". A drink list is simply the list of all the tracked beverages that the user has ever tried. When a user adds a beverage to their drink list, the date the beverage is added is also recorded. Users can mark beverages on their drink list as a "favorite", if they want Users can connect with each other through the BB app by adding each other as friends. When a user requests to friend another user, the friendship is marked as "requested" in the system. When the other user accepts the request, the friendship is marked as "confirmed" in the system. When users become friends in the app, the date of the friendship is recorded. Friends in the app can see each other's drink lists and favorites. Users can "friend" as many other users of the BB app as they wish, but users are not required to friend any venues that can occasionally sponsor events. Venues are not required to sponsor any events, but some venues sponsor many events each year. The events are tracked in BB. Each event has a name, sta rt date, and end date. Some events have an admission fee associated with them, but some do not. Only ents sponsored by venues appear in the BB app. Each event is sponsored by a single venue. Users can e upcoming events within the app. If the user plans to attend the event, they can sign up for the vent through the app. 

The BB app does not handle payments so if the event has an admission fee payments for the admission fee the date that they sign up is recorded. Users do not always attend the events that they sign up for. If a is not done or tracked within the app. If a user signs up for an event attends the event, then they can "check-in" at the event when they get there. Checking in at the simply indicating in the app that they actually attended the event. A user can, and hopefully will, sign up and attend many different events. An event will hopefully be attended by dozens of user The event needs to be able to be entered into the system before the users can sign up for it. Some users have never signed up or attended any events For example, Aziz installs the Beverage Buddy app on his phone and registers as a user. He houses named "Topical Teas" after work one day. While there, he looks on BB for a black tea that has fewer than 3 grams of sugar and fewer than 5 total carbohydrates that are sold at this tea house. Looking through the results, he decides to try a beverage named "Cabo Crisp" that is brewed by "World Tea Market" After he orders with the waiter and the tea is brought to him, Aziz adds Cabo Crisp to his drink list in BB and marks it as a favorite. While he is drinking his tea, he looks for his friend Kayla on the system by her email address and sends a friend request. Almost immediately, Kayla accepts his request and they are now friends in BB. Looking at Kayla's drink list, he sees that she has also tried Cabo Crisp and marked it as one of her favorites. Looking at her drink list, he sees that Kayla has tried over 50 different drinks Aziz notes that Kayla also marked the coffee drink named, "Butter Blend," as one of her favorites. Aziz finds that Butter Blend is not available at "Tropical work. He can see that GrindHows is sponsoring a free book reading event next Tuesday from 4 pm u 7 pm with 50% off all coffees. Aziz signs up to attend the book reading event goes to a tea (not to be confused with the "Cabo Crisp" that is a cider brewed by "Greenhouse Brewers") Teas", but s available at "GrindHows" near his until. 

Note: to help protect user privacy, BB does not store data about any searches that users make

Answer in LucidChart with Crow's Foot notation.