In this lesson, we will learn how to create a
database and various database objects such
as tables, indexes etc. using the MySQL
MySQL is an open source DBMS
It comes with a command-line utility for
interacting with the database server
STRUCTURED QUERY LANGUAGE (SQL):
TUTORIAL & PRACTICE QUESTIONS
SQL is the most widely used query language for relational system. SQL
allows the user to create tables and subsequently manipulate them in
INTRODUCTION TO DATABASE
Introduction to Databases
Data vs. Information
File and File-based Systems
Database and Database Management Systems
Relational Database Design Concepts
What is a Dat
Entity Relationship (ER) Model
ER Model which was first developed by Chen in
1976 is a graphical representation of entities and
their attributes, and the relationships among them.
It is a high-level data model that is useful in developing
a conceptual d
Examine the table shown below.
8 Jefferson Way, Portland, OR 97201
City Center Plaza, Seattle, WA 98122
14 - 8th Avenue, New York, NY 1001
INTRODUCTION: CONSIDER THE TABLE BELOW
The table is not very efficient with storage.
The design does not protect data integrity.
The table does not scale well.
The table displays data redundancies which can yield the follo