When installing latex packages for Latex. Users can either install texlive-basics or full version texlive. However, the basic version is light version uses much less strorage. Instead, full version texlive covers most of packages but more storage on disk.
I choose to install texlive-basic and install the packages required for my Latex file.
description: The sql schema we used here is a bar-beer-drinker relational schema. Bars can sell beers, which are from different manufactories have different types. Drinkers frequents bars and like beers.
1.List the number of beers that bars starting with B serve(all bars) 2.The set of bars and manf that have average price for the beers from the same manufacturer more than 5 bucks 3.Unusual beer (A beer that is sold in the least number of bars) 4.Bars that serve all beers 5.Bars that have a beer Mike likes that is cheaper than in any bars Mike frequents 6.Bars that have maximum variety 7.Unusual manf per bar (A manufacturer that the current bar has the least number of beers from)