# |
Announcement |
Date |
1 |
Provide your email in lect#1 |
Oct. 8th, 2018 |
Week |
Topic(s) |
Lab Work |
Notes |
1 |
Course Introduction Introduction to Databases |
Lab Policy Start Microsoft Access: Environment Setup and GUI |
Chapter 1 |
2 |
Database System Concepts and Architecture |
DBMS Access - Experiencing Database System Concepts and Architecture |
Chapter 2 |
3 |
The Relational Data Model and Relational Database Constraints |
Tables and Attributes |
Chapter 3 |
4 |
Basic SQL |
Starting SQL |
Chapter 4 |
5 |
More SQL |
Practicing Complex Queries, Triggers, Views, and Schema Modification |
Chapter 5 |
6 |
Data Modeling Using the Entity-Relationship (ER) Model |
Creating Course Database Project Schema and Instances |
Chapter 7 |
7 |
Tables and Keys |
Create Tables, Properties of Tables, Types of Keys |
Value |
8 |
Forms |
Creating Forms, Design Forms, Form Types, Tools and Properties |
|
9 |
Functional Dependency , Normalization for Relational Database |
First Normal Form ( 1NF ) Second Normal Form ( 2NF ) Third Normal Form ( 1NF ) |
Chapter 15 |
10 |
Queries |
SQL, Quering |
|
11 |
Reports |
SQL, Reporting |
|
12 |
Macros |
Concept of Macros and their creation |
|
13 |
Web-Based Database |
Microsoft SharePoint |