• We are available for any custom works this month
  • Main office: Springville center X264, Park Ave S.01
  • Call us (123) 456-7890 - (123) 555-7891
  
  
  

Course Info

About this Course

In the information age today, enormous amount of data is kept in files and databases. The knowledge to manipulate and manage these files is beyond doubt. By using a database package, the students will be able to appreciate the needs for database systems rather than the traditional file systems.

Course Syllabus

Database Concepts
1.1 Data and Information
1.2 Introducing the Database
1.3 The Importance of Database Design
1.4 Evolution of File System Data Processing
1.5 Database Systems

Data Models
2.1 The Importance of Data Models
2.2 Data Model Basic Building Blocks
2.3 Business Rules
2.4 The Evolution of Data Models
2.5 Degrees Of Data Abstraction

The Relational Database Model
3.1 A Logical View of Data
3.2 Keys
3.3 Integrity Rules
3.4 The Data Dictionary and the System Catalog
3.5 Relationship within the Relational Database
3.6 Indexes

Entity Relationship (ER) Modeling
4.1 Basic Modeling Concepts
4.2 The ER Model
4.3 Developing an ER Diagram
4.4 A Comparison of ER Modeling Symbols
4.5 The Challenges of Database Design

Normalization of Database Tables
5.1 The Need for Normalization
5.2 The Normalization Process (1NF, 2NF, 3NF)
5.3 Improving the Design
5.4 Normalization and Database Design
5.5 Denormalization

Database Design
6.1 The Information System
6.2 The Systems Development Life Cycle (SDLC)
6.3 The Database Life Cycle (DBLC)
6.4 Database Design Strategies
6.5 Centralized versus Decentralized Design

Structured Query Language
7.1 Introduction to SQL
7.2 Data Definition Commands
7.3 Data Manipulation Commands
7.4 SQL Operators
7.5 Additional Data Management Commands
7.6 Additional Select Queries
7.7 Subqueries
7.8 Joining Database Tables

Current Trends and Issues in Database
8.1 Introduction to Specific Area of Database (i.e. Big Data etc)
8.2 Conceptual model on the Specific Area of Database
8.3 Data Management Issues

Frequently Asked Questions

Q1 : Who can enroll this course?
A1 : Anyone who wants to learn more about database design

Q2 : Can non-IT enroll this course?
A2 : Definitely yes!