2015-09-19
Advanced Sql Programming Problems and Solutions

Advanced Sql Programming Problems and Solutions

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)

Read More

2015-06-20
Ubuntu给桌面环境注册程序

sublime 在ubuntu下不支持中文输入法,这对于开发来说难免有很多不方便的地方

使用自定义程序方法启动sublime2./sublime3

首先,我们进入sublime的配置目录下:

cd /opt/sublime-text2

这里,我们新建一个代码文件来进行编译生成我们的自定义程序

sudo touch sublime-imfix.c

Read More

2015-05-31
Ubuntu给桌面环境注册程序

ubuntu dash home中每个图标对应/usr/share/applications当中的一个配置文件(文件名后缀为.desktop)。所以要在dash home中添加一个自定义程序启动器,需要在该文件目录下创建对应的配置文件。至于配置文件的语法,参考该目录下的配置文件即可明白。
以eclipse为例,方法如下。

Read More

2014-11-02
组建内外网文件服务器

目标


最近实验室老板要求,要将实验室内部的文件共享服务器能够通过实验室域名进行访问。因此,我们的目标是组建一个内网可以访问并且在内网各个主机都能通过smb协议来对文件服务器进行维护,外网网页能够访问文件内容。

权限说明


内网: 对服务器读写权限,通过smb协议进行文件访问,即共享文件夹的方式;

外网: 能够通过域名在网页上访问内部文件进行下载,仅有读的权限

Read More