could you please help me with drawing an complete e r gram including every entity an 5150635

Cool Spot 1 minute INFO90002 - 2019 sem2 - Assignment One COFFEE CLUB Coffee Club is a social platform for coffee lovers. UCOFFEE CLUB nearby cafes Posting to the Timeline The Coffee Club app has a social media-style timeline, to which users can po

Could you please help me with drawing an complete E-R gram including every entity and relationship! (please do not divided the E-R gram into small part)

Drawing the compelete E-R graph to solve the problem! Cool Spot 1 minute INFO90002 – 2019 sem2 – Assignment One “COFFEE CLUB” Coffee Club is a social platform for coffee lovers. Users connect via a smartphone app to the Coffee Club server. Your job is to design a database that will support these software features. = COFFEE Cafes CLUB The names, addresses, map locations and opening hours of about nearby cafes ten thousand cafes are visible in the app. Users can browse cafes either via an alphabetical list or a map interface. Only cafes located in Australia are covered in this app. Cups Are Us 1 minute When viewing a cafe's profile, a user can see the café's average Wake Up Time 2 minutes rating, as well as reviews and photos uploaded by other users. For each café we record the opening and closing time for each Hip Star 3 minutes of the seven days of the week. (For example, a cafe might open reviews Sundays 8am to 3pm, Mondays 9am to 7pm, and so on. We can Bean There minutes ignore exceptions like public holidays.) Each cafe stores a menu of the drinks it sells and their prices. Costs-A-Lot min Drink names must be drawn from a standard list of about 100 drinks maintained in the system. Some cafés may also sell other items (such as cakes) but we don't record these in our system. reviews 2 reviews Users The app will have up to 20 million users. This assignment is concerned only with features for customer users: café staff and system administrators will access the system in other ways. To use the system, users must first install the Coffee Club app on their phone, then set up a user profile that contains: a login name (email address), password (encrypted and stored as a string of 64 characters), short screen name (a single string less than 20 characters long which other users will see), and optional profile photo. Each user can display a “My Brew”, which is their favourite coffee drink, chosen from the list of standard drink names mentioned above. Users tend to change their choice of “My Brew” over time: we want to keep track of these changes as the data yields valuable intelligence about coffee preference trends. Ratings, photos and favourites Users can rate cafes. A rating consists of a whole number of stars” between 1 and 5 inclusive, along with an optional piece of text (up to about 20 words). A user can only rate a given cafe once. Users can also upload photos they take of a cafe: these can later be browsed by other users. Users can also mark particular cafes as “favourites”. A user's app will beep if they pass within 500m of one of their favourite cafés, or if another user they are following checks in at a favourite cafe. Users can later “unfavourite” the cafe if they wish, and still later, “favourite” it again, and we need to keep a history of these actions. INFO90002 2019s2 Assignment One COFFEE CLUB nearby cafes Posting to the Timeline The Coffee Club app has a social media-style timeline, to which users can post text and photos. A post consists of a short piece of text (up to 1000 characters) with an optional photo. We expect users to post once per day each on average. Other users can “like” a post, and if they wish, later “unlike” it. Users can also “comment” on posts, adding a short piece of text (again up to 1000 characters). However users cannot comment on comments: i.e. commenting is depth one”. The app allows users reading their newsfeed to sort the list of posts, either by the time each post was entered, or by the number of likes each post has received. Social Graph Users can follow other users. The social graph works like Twitter's: user A can follow user B, without B needing to approve, nor B automatically becoming a follower of A. Users might for example choose to follow people they know offline, or celebrities, or expert members of the user community. If a user decides to follow another, they can later choose to “unfollow” them if they wish: we need to keep track of these actions for later analysis. Locations While a user's phone is switched on, the Coffee Club app sends the user's current location to the server every minute. Locations are recorded as a pair of numbers representing latitude and longitude. We use a precision of 4 decimal places: for example, the Doug McDonell building is at latitude -37.7990, longitude 144.9630. COFFEE CLUB cafe news Sale !!! posted 15:30 Tuesday This weekend only at Cool Spot cafe gotten percent of all coffee between 11 and 11:30 am This will be the morning e vent of the year so don't miss out Check-ins Users can use their app to check in” at cafes that they visit. Optionally, the user can tag one other user in the checkin. Checkin data is used to enable the user's followers to see when the user is present at the café. We mine checkin data periodically for business intelligence. New Beans posted 10 Tuesday Last you a new species of the was discovered in a remote ngle in Antarctica One of Coffee Club's favourite cafes. Cups Are Ushave obtained a quantity of this mysterious bean and are selling it only to Coffee Club members. Go to Cups Are Us and mention the password antarctic ungle Health News posted 300 Monday Coffee Club members will be pleased to hear that scientists have a n d that drinking là thành News The app has a 'news' page where users can browse system- generated stories about significant events such as sales or parties. A story consists of a heading and a short body of text (max 1000 characters) and a photo. Stories can be browsed either in date order or by café. We allow customers to like news stories, but not comment on them. (end of case) INFO90002 201982 Assignment One

"Get 15% discount on your first 3 orders with us"
Use the following coupon

Order Now