[Stanford] Introduction to databases (week 1)

进度贴 && 讨论帖

课程汇总 && 介绍：http://www.1point3acres.com/bbs/thread-79690-1-1.html

本周任务：

截图规范：

在Progress里面每次把本周的Assigned Work截图截下来，包括Quiz和Exercises

会有版主给大家加分，每周1学分（50大米）

Sorry to reply to this old theme, but I really got in trouble. Because I use the library's computer, I don't know how to change the language to Chinese. Anyway, I have a problem for exercise one.
The exercise one is:
In this question, you are to create a DTD for a small XML data set drawn from the Stanford course catalog. There are multiple departments, each with a department chair, some courses, and professors and/or lecturers who teach courses. The XML data is here.

Write a DTD for the XML data set.

Important: Do not include <!DOCTYPE Course_Catalog [...]> in your DTD. Your DTD should start with <!ELEMENT Course_Catalog (Department*)>.

What I wrote is:
<!ELEMENT Course_Catalog (Department*)>
<!ELEMENT Department (Title, Chair, Course*)>
<!ELEMENT Department Code (#PCDATA) #REQUIRED>
<!ELEMENT Title (#PCDATA)>
<!ELEMENT Chair (Professor)>
<!ELEMENT Professor (First_Name, Last_Name)>
<!ELEMENT First_Name (#PCDATA)>
<!ELEMENT Last_Name (#PCDATA)>
<!ELEMENT Course (Title, Description?, Instructors, Prerequisites?)>
<!ELEMENT Course    Number PCDATA #REQUIRED
                    Enrollment CDATA #REQUIRED>
<!ELEMENT Title (#PCDATA)>
<!ELEMENT Description (#PCDATA)>
<!ELEMENT Instructors (Lecturer | Professor)*>
<!ELEMENT Lecturer (First_Name, Middle_Initial, Last_Name)>
<!ELEMENT Middle_Initial (#PCDATA)>
<!ELEMENT Prerequisites (Prereq)>
<!ELEMENT Prereq (#PCDATA)>

The error is:
Incorrect

Error messages from xmllint: /tmp/tmpdPII0D.dtd:3: parser error : xmlParseElementDecl: 'EMPTY', 'ANY' or '(' expected

<!ELEMENT Department Code (#PCDATA) #REQUIRED>

^

/tmp/tmpdPII0D.dtd:3: parser error : Content error in the external subset

<!ELEMENT Department Code (#PCDATA) #REQUIRED>

^

Could not parse DTD /tmp/tmpdPII0D.dtd

Did anyone know the reason for this error? Thank you so much!

啊啊啊初学者求问！！
Department元素下的属性Code定义哪里出错了啊？
源代码是：<!ATTLIST Department  Code (CS|EE) "CS">
编译器显示错误如下：
Error messages from xmllint: /tmp/tmpGWnbEC.dtd:3: parser error : '(' required to start ATTLIST enumeration

<!ATTLIST Department Code CS|EE) 'CS'>

^

/tmp/tmpGWnbEC.dtd:3: parser error : Content error in the external subset

<!ATTLIST Department Code CS|EE) 'CS'>

^

求教，怎么看视频，我只能看到文字的介绍，没有视频的链接的？

视频load不出来下载也木有速度。。。>.<

甯甯 发表于 2014-1-7 15:54
视频load不出来下载也木有速度。。。>.

翻墙试试？是挺慢的，不过我后来就好了

打不开视频啊，翻墙也开不了。怎么破！

miumiu218 发表于 2014-1-7 20:07
打不开视频啊，翻墙也开不了。怎么破！

如果在墙内Stanford Online的视频必须翻墙看的
我用goagent翻墙还行，这个取决于你的网速了

我怎么没有找到课程的视频啊，只有课程介绍，第一次上公开课，有人指点一下吗~~~~~~~

EroicaCMCS 发表于 2014-1-7 21:14
如果在墙内Stanford Online的视频必须翻墙看的
我用goagent翻墙还行，这个取决于你的网速了

为什么我不翻墙也可以看视频？

qujingan1987 发表于 2014-1-7 22:45
我怎么没有找到课程的视频啊，只有课程介绍，第一次上公开课，有人指点一下吗~~~~~~~

你把图截下来吧……我也不清楚你现在遇到的是什么问题==

sanguine 发表于 2014-1-7 23:18
为什么我不翻墙也可以看视频？

我刚刚试了一下，竟然可以！！
Stanford Online可是基于youtube的，墙内竟然能看了！！之前是不行的！！
神奇了！！

EroicaCMCS 发表于 2014-1-8 00:16
我刚刚试了一下，竟然可以！！
Stanford Online可是基于youtube的，墙内竟然能看了！！之间是不行的！！ ...

你一说我才发现是基于youtube的==

诡异！！！