今天完成：数据库基础，sql语句基础，初步理解了数据库完整性， 任务1中1到10的步骤。

明天完成：

1关系数据理论规范化，范式是什么鬼

2在设计逻辑结构和数据模型优化方面什么都不知道

3数据库运行与维护什么也不知道

4什么数据库恢复技术，并发控制什么的，连了解都没有

5sql查询那块没看完。。。只是用了一个单表查询。连接查询，嵌套查询，集合查询，基于派生表查询都没看。

附：代码

CREATE DATABASE XZYz
GO
USE XZYz
CREATE TABLE TOLLCOLLECTOR(Tname CHAR(20),
                              Tno CHAR(4),
                              QQ CHAR(15),
                              PRIMARY KEY(Tno)
                              );
CREATE TABLE REVIEWER(REVname CHAR(20),
                         REVno CHAR(4),
                         QQ CHAR(15),
                         PRIMARY KEY(REVno)
                         );
CREATE TABLE CLASS(Cname CHAR(20),
                      Cno CHAR(5),
                      DURATION SMALLINT,
                      COST INT,
                      PRIMARY KEY(Cno)
                      );
CREATE TABLE STUDENT(Sname CHAR(20),
                     STUDENTID CHAR(4),
                     QQ CHAR(15),
                     Cno CHAR(5),
                     TimeOfEnrollment INT,
                     University TEXT,
                     Link TEXT,
                     Wish TEXT,
                     REVno CHAR(4),
                     REFno CHAR(4),
                     Tno CHAR(4),
                     REV BIT,
                     PAY BIT,
                     CREATE_AT INT,
                     UPDATA_AT INT,
                     PRIMARY KEY(STUDENTID),
                     FOREIGN KEY(Cno)REFERENCES CLASS(Cno),
                     FOREIGN KEY(REVno)REFERENCES REVIEWER(REVno),
                     FOREIGN KEY(REFno)REFERENCES STUDENT(STUDENTID),
                     FOREIGN KEY(Tno)REFERENCES TOLLCOLLECTOR(Tno)
                     );
GO

USE XZYz
INSERT
INTO CLASS(Cname,Cno,DURATION,COST)
VALUES('前端工程师','1','3','11400');
INSERT
INTO STUDENT(Sname,STUDENTID,QQ,TimeOfEnrollment,University,Cno,Wish,Link,REV,PAY)
VALUES('黄国宝','2406','137872143','20170206','莆田第十中学','1','破釜沉舟，心无旁骛！','http://www.jnshu.com/daily/13280?uid=7339',0,1);
SELECT * FROM STUDENT WHERE Sname LIKE '黄国宝';
UPDATE STUDENT SET Wish='老大最帅' WHERE Sname LIKE '黄国宝';
CREATE UNIQUE INDEX STUSNO ON STUDENT(Sname);