HOMEPAGE | Award | CV | Course Links - 690 670 775 793 794
(last updated on 11/09)
| Dagobert Soergel | Derric D'Souza | |
| Room 4101 | Room 4111N | |
| Office: 301-405-2037 | Main Office mailbox 22 | |
| Cell: 703-585-2840 | ddsouza AT umd.edu | |
| E-mail: dsoergel AT umd.edu | Meeting by appointment | |
| Office Hours: W 12-1pm & 4-5pm | ||
| Main Office mailbox 22 |
| Database Tutorial | |
| Database Fundamentals | |
| ER Diagram | |
| Building a Sample DB in MS-Access | |
| Assignment - 2 {Self-Graded} | |
| Objective: | Publish your own webpage |
| 1. Get a WAM account | http://www.helpdesk.umd.edu/os/unix/accounts/wam/ |
| 2. F-Secure SSH (for Win FTP) | http://www.helpdesk.umd.edu/documents/4/4313/ |
| 3. Fugu (for Mac OS X FTP) | http://www.helpdesk.umd.edu/documents/4/4528/ |
| 4. Publishing Web Pages | http://www.helpdesk.umd.edu/documents/1/1364/ |
| Assignment - 1 {Self-Graded} | |
| Objectives: | 1. Understand the translation of an entity-relationship conceptual data schema into table definitions for a relational database. 2.Understand how a relational database can be queried, especially, how data from several tables can be combined in an answer. |
| Tasks: | 1. Define a table in Microsoft Access and enter some data 2. Run some SQL queries in a MS Access database |
| Deliverables: | Printouts of the Table T5COFInstructor (showing the data you entered), of the definitions of Queries 4a - c/d, and of the query results. |
| File: | University.mdb |
| Solution_1: | University_Solution.mdb |
| Solution_2: | Queries Solution |
| Solution_3: | Tables Solution |