Chapter 1: Introduction to Databases
File based Systems
Limitations of File-based Approach
Database Approach
Database – Definition
Entity, Attributes, Relationships
ER- Diagram
Database Management Systems (DBMS)
Data Manipulation Languages (DML)
-Uses of DML
-Procedural (record by record) & Non-procedural Languages (based on sets of records)
Components of DBMS Environment
-Hardware, Software, Data, Procedures, People
Roles of Data and Database Administrators
DBMS
Advantages
Disadvantages
Chapter 2: Database Environment
Three Level Architecture
External Level
Conceptual Level
Internal Level
Data Independence
Data Manipulation Languages
Procedural
Non-Procedural
4GL
Record Based Data Models
Relational Model
Network Data Model
Hierarchical Data Model
Multidimensional
Object based Data Models
Functions of a DBMS
Benefits of System Catalog
Components of a DBMS
Query Processor, Database Manager, File manager, DML preprocessor, Catalog Manager
Server Types
File Server
Client Server
Database Server
Summary of Client Server Functions
Chapter 5 Entity –Relationship Modeling
Entity
Attributes
Attribute Domain
Composite Attribute
Single-valued
Multi-valued
Derived
Keys
Candidate
Primary
Composite
Relationship Types
One-to-One
One-to-many
Many-to-Many
Chapter 3 Relational Model
Relation, Attribute, Domain, Tuple, Degree, Cardinality, Relational Database
Database Relations (Attributes with domains)
Properties of Relations (Tables)
Relational Keys
Super Key
Candidate Key
Primary Key
Foreign key
Relational Integrity
Nulls
Entity Integrity
Referential Integrity
Addition of record
Deletion of record
Projection
Selection
Cartesian Product operation
Union Operation
Set Difference Operation
Natural Join operation
Views
Purpose of views
Chapter 13: Introduction to SQL
Create tables
Data manipulation
Select
Insert
Update
Delete
Simple Queries
Retrieve all columns
Retrieve specific columns and rows
Use of Distinct
Calculated Fields
Comparison search condition
Range search condition
Set membership search (IN/NOT IN)
Pattern match search (LIKE/ NOT LIKE)
Sorting Results (ORDER BY)
Single column ordering
Multiple column ordering
SQL aggregate functions
Grouping Results (GROUP BY)
Use of HAVING
SubQueries
Any and All
Any/Some
Join
Left Outer Join
Right Outer Join
Full Outer Join
UNION, INTERSECT, Updates
Lab:
Chapter 15: Query-By-Example
Intro to Access
Database Window
Query Design View
-Equivalent SQL statement
Creating Multi table Queries
-Relating multi tables
Calculating Totals
Using Advanced Queries
Parameter Query
Update action Query