In order to write efficient, well engineered programs, it is necessary to understand how programming languages work. The course will focus on syntactic and semantic specification of language constructs and the implementation of data types, control structures, and sub-programs. Examples will be drawn from several languages to illustrate different approaches to solving common programming language problems. An introduction to issues in the design and implementation of database management systems. Major topics include database system components, conceptual modeling, database applications, normal forms and the societal impact of database systems.
Emphasis is given to the relational data model.
Students are required to use a high-level language to write programs to access databases. This course introduces the student to those object models and techniques that are used to provide database access via the Web. The course will briefly cover relevant relational database and HTML topics. Primary emphasis is on client-server model, Visual Basic Script language, Active Server Pages model and ActiveX Data Objects model. Students will develop and use Active Server Pages and VB Script to provide Web access to server-side databases.