Week 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
Database Concepts
Upon successful completio of this unit, you will be able to:
- Explain and discuss the terminology and concepts of structured database systems
- Explain and discuss the concepts of queries and how to extract information.
- Discuss future directions in databases in large information systems
- Build a simple table to be linked to existing tables.
- Perform various simple queries using SQL and QBE skills.
| Week 1 | March 31 | Touring Access |
Deliverables | ||||
|---|---|---|---|---|---|---|---|
ReadingsMacDonald, Chapter 1: Creating Your First Database Lecture
|
| Unit Introduction |   |
| Touring Access | |
Readings
MacDonald, Chapter 2: Building Smarter Tables
Lecture
| What's a database? |
|
Readings
MacDonald, Chapter 5: Linking Tables with Relationships
Lecture
| Tables and Relationships | |
Readings
Preface to William Kent's Data and Reality
Lecture
| Database Modeling | |
Quiz 1: Databases, tables and relationships. Must be completed by Friday of this week at 11:45 PM. You have 1/2 hour to complete it. When you start you have to finish.
Readings
MacDonald, Chapter 6: Queries That Select Records
Lecture
| SQL Queries | |
| Feedback on your feedback on the DB & Web Units | |
Readings
MacDonald, Chapter 7: Essential Query Tricks
Lecture
| Access Queries | |
RDB Project Part 1 due by 11:45 PM on May 9th
Please submit a copy of Scaleup.accdb with all the additional tables, relationships, and data that RDB Worksheets 1 and 2 ask you to create.
Readings
MacDonald, Chapter 12: Creating Simple Forms
Lecture
| Input Forms | |
Readings
MacDonald, Chapter 10: Creating Reports
Lecture
| Reports | |
Quiz 2: Database modeling, forms and queries. Must be completed by Friday of this week at 11:45 PM. You have 1/2 hour to complete it. When you start you have to finish.
Readings
none
Lecture
| Database Systmes and Applications | |
RDB Project Part2 Due
Must be completed by Friday of this week at 11:45 PM.
Please submit a copy of Scaleup.accdb with all the Queries, forms and reports and data that RDB Worksheets 3,4, and 5 ask you to create.
PLEASE DELETE ANY COPIES OF YOUR FORMS OR REPORTS THAT ARE NOT THE ONES YOU WANT ME TO REVIEW
Readings
none
Lecture
| None |
Site is maintained by