Difference between revisions of "DD Class11"
esse quam videri
(→Sub Query) |
|||
| Line 1: | Line 1: | ||
[[Category:Data Design]] | [[Category:Data Design]] | ||
| + | |||
| + | ==Review Data Diagram for final== | ||
| + | |||
| + | *are they normal? | ||
| + | *can the design acomplish your goals? | ||
| + | *are they over engineered? | ||
| + | |||
| + | ==Sql Functions== | ||
| + | |||
| + | AVE MIN MAX COUNT | ||
==Sub Query== | ==Sub Query== | ||
Revision as of 03:20, 11 April 2007
Contents
Review Data Diagram for final
- are they normal?
- can the design acomplish your goals?
- are they over engineered?
Sql Functions
AVE MIN MAX COUNT
Sub Query
Course adder example
http://iam.colum.edu/dd/classsource/class8/student.aspx
SQL Subquery
<sql>SELECT CourseID, CourseName, CourseNumber FROM Course WHERE (
CourseID not in
(
SELECT CourseID FROM StudentsCourses_vw WHERE StudentID = @StudentID
)
) </sql>
Uploader/Email
Mappath
Server.Mappath
upload permissions
HomeWork
Web Skeleton of your site
Demostate one feature
