◆COMPUTER STUDIES 4 － （後）
|
SLOTT KAZUMI
|
| ○科目サブタイトル |
Databases for Academic Computing
|
| ○講義概要 |
You will learn database design and use; flat-file and relational databases; integration of databases with web applications. MS Excel, MS Access, and PHP (Hypertext Preprocessor) and MySQL will be used. The course covers mainstream database concepts such as the entity-relationship model, query languages, database design methodology, tables, and reports.
For the complete syllabus, go to http://www.webspawner.com/users/kslott/index.html
|
| ○評価方法 |
出席状況(20%)、レポート(80%)
|
| ○テキスト |
『No textbooks required.』
|
| ○授業計画 |
| 1 | Go over Syllabus. |
| 2 | Introduction to databases. Create flat-file databases using Excel and Access. |
| 3 | Design relational databases using the entity-relation model; tables, attributes, keys, etc. |
| 4 | same as above |
| 5 | Create relational databases using Access. |
| 6 | Write SQL("SEQUEL" Structured Query Language) statements to create reports using Access. |
| 7 | Create web sites using PHP. |
| 8 | same as above |
| 9 | Write SQL statements to create tables using MySQL. |
| 10 | Incorporate databases using MySQL into the web sites. |
| 11 | same as above |
| 12 | same as above |
|
Copyright (C) 2004 Sophia University
By：上智大学学事部学務課
|
