Basics of Database Design

A database is an organized collection of data, generally stored and accessed electronically from a computer system. Where databases are more complex they are often developed using formal design and modeling techniques. The course on Basics of Database Design also known as Database Design I will put you true with the required knowledge you need to have as a database designer in a beginners level.

The concept of database system is a must know for every undergraduate and everybody in general. Selecting the best database management system (DBMS) may difficult for a novice. Today, businesses and organisation use relational database management to manage their data.

Learning Objectives

At the end of this course, you will be able to:

  1. Discuss the concept of Database and DBMS
  2. Explain the Models of Database
  3. Characteristics, Advantages and Disadvantages
  4. Know the Components of DBMS and Its Users
  5. Architectures of Database Management System
  6. Understand the Entity Relationship (ER) Model
  7. Terminologies in Relational DBMS Model
  8. Conceptualize Structured Query Language (SQL)

I have prepared this course – Basics of Database Design – in an easy to understand tone. Learners need little or no help to understand the course.

Lecturer/ Course Creator

Uncle Patrick Chigoziri Ugwu

He is a Computer Educationist, Edtech Expert, Course Creator, Blogger, Statistical Data Analyst and Software Tester at Akanne Technologies.

Lessons

The Database Models

Author: Uncle Pat

A Database model defines the logical design and structure of a database and defines how data will be stored, accessed and updated in a database management system. While the Relational Model is the most widely used database model, there are other models too: Hierarchical Model Network Model Entity-relationship Model Relational Model Hierarchical Model This database model organises […]

Characteristics, Advantages and Disadvantages

Author: Uncle Pat

A database management system has following characteristics: Data stored into Tables:Data is never directly stored into the database. Data is stored into tables, created inside the database. DBMS also allows to have relationships between tables which makes the data more meaningful and connected. You can easily understand what type of data is stored where by […]

Components of Database and Its Users

Author: Uncle Pat

The database management system can be divided into five major components, they are: Hardware Software Data Procedures Database Access Language Let’s have a simple diagram to see how they all fit together to form a database management system. DBMS Components: Hardware When we say Hardware, we mean computer, hard disks, I/O channels for data, and […]

Architecture of Database Management System

Author: Uncle Pat

A Database Management system is not always directly available for users and applications to access and store data in it. A Database Management system can be centralised(all the data stored at one location), decentralised(multiple copies of database at different locations) or hierarchical, depending upon its architecture. 1-tier DBMS architecture also exist, this is when the database is directly available […]

Concept of Entity Relationship (ER) Model

Author: Uncle Pat

As we described in the tutorial Database models, Entity-relationship model is a model used for design and representation of relationships between data. The main data objects are termed as Entities, with their details defined as attributes, some of these attributes are important and are used to identity the entity, and different entities are related using […]

Some Basic Terminologies in RDBMS

Author: Uncle Pat

A Relational Database management System(RDBMS) is a database management system based on the relational model introduced by E.F Codd. In relational model, data is stored in relations(tables) and is represented in form of tuples(rows). RDBMS is used to manage Relational database. Relational database is a collection of organized set of tables related to each other, and from which data can be […]

Basic Structured Query Language (SQL)

Author: Uncle Pat

Structure Query Language(SQL) is a database query language used for storing and managing data in Relational DBMS. SQL was the first commercial language introduced for E.F Codd’s Relational model of database. Today almost all RDBMS(MySql, Oracle, Infomix, Sybase, MS Access) use SQL as the standard database query language. SQL is used to perform all types of data operations in […]