Republic of the Philippines
ILOILO STATE UNIVERSITY OF FISHERIES SCIENCE AND TECHNOLOGY
COLLEGE OF INFORMATION AND COMMUNICATIONS TECHNOLOGY
MAIN CAMPUS-Poblacion Site, Barotac Nuevo, Iloilo | email:
website: iscof.edu.ph | Contact No: (033) 3672-786 Local 1012
INSTRUCTIONAL MATERIAL IN IT210 - FUNDAMENTAL OF DATABASES
CHAPTER 1
INTRODUCTION TO DATABASE MANAGEMENT SYSTEM
1.1 Introduction to the Course
1.2 Introduction to Databases
1.3 Types of Database Models
1.4 Business Requirements
1.1 Introduction to
the Course
Course Description:
This course introduces students to basic relational database
concepts. This also covers relational database terminology, as well as
data modeling concepts, building Entity Relationship Diagrams (ERDs),
and mapping ERDs.
Course Intended Learning Outcomes
Learn the fundamental of relational, object-oriented and
distributed database systems including data models, database
architectures and learn database manipulations.
Discuss the database management system.
Use database command effectively.
Perform basic Data Base administrator’s function.
Develop conceptual models using the Entity-Relationship model.
Design database using data models.
Use database programming languages to manipulate or process
data efficiently.
Use MS Access or SQL Developer Data Modeler and Application
Express.
Relate current issues in the development of database
technologies and applications.
Appraise various implementations of database management
systems.
Appreciate the value of good database design and to follow the
best practices.
Instructional Material Created by: Renante A. Diamante, DIT
Assistant Professor IV
Version 1.0 – 08/2023
1
, Republic of the Philippines
ILOILO STATE UNIVERSITY OF FISHERIES SCIENCE AND TECHNOLOGY
COLLEGE OF INFORMATION AND COMMUNICATIONS TECHNOLOGY
MAIN CAMPUS-Poblacion Site, Barotac Nuevo, Iloilo | email:
website: iscof.edu.ph | Contact No: (033) 3672-786 Local 1012
INSTRUCTIONAL MATERIAL IN IT210 - FUNDAMENTAL OF DATABASES
1.2 What is a
database?
A database is a collection of data that is stored in a computer system.
Databases allow their users to enter, access, and analyze their data
quickly and easily. They're such a useful tool that you see them all the time.
Ever waited while a doctor's receptionist entered your personal information
into a computer, or watched a store employee use a computer to see
whether an item was in stock? If so, then you’ve seen a database in action.
The easiest way to understand a database is to think of it as
a collection of lists. Think about one of the databases we mentioned
above: the database of patient information at a doctor's office. What lists are
contained in a database like this? To start with, there's a list of patients'
names. Then there's a list of past appointments, a list with medical history
for each patient, a list of contact information, and so on.
This is true of all databases, from the simplest to the most complex. If
you like to bake, for example, you might decide to keep a database
containing the types of cookies you know how to make and the friends you
give these cookies to. This is one of the simplest databases imaginable. It
contains two lists: a list of your friends, and a list of cookies.
Instructional Material Created by: Renante A. Diamante, DIT
Assistant Professor IV
Version 1.0 – 08/2023
2
, Republic of the Philippines
ILOILO STATE UNIVERSITY OF FISHERIES SCIENCE AND TECHNOLOGY
COLLEGE OF INFORMATION AND COMMUNICATIONS TECHNOLOGY
MAIN CAMPUS-Poblacion Site, Barotac Nuevo, Iloilo | email:
website: iscof.edu.ph | Contact No: (033) 3672-786 Local 1012
INSTRUCTIONAL MATERIAL IN IT210 - FUNDAMENTAL OF DATABASES
However, if you were a professional baker, you would have many more
lists to keep track of: a list of customers, products sold, prices, orders, and so
on. The more lists you add, the more complex the database will be.
Instructional Material Created by: Renante A. Diamante, DIT
Assistant Professor IV
Version 1.0 – 08/2023
3
, Republic of the Philippines
ILOILO STATE UNIVERSITY OF FISHERIES SCIENCE AND TECHNOLOGY
COLLEGE OF INFORMATION AND COMMUNICATIONS TECHNOLOGY
MAIN CAMPUS-Poblacion Site, Barotac Nuevo, Iloilo | email:
website: iscof.edu.ph | Contact No: (033) 3672-786 Local 1012
INSTRUCTIONAL MATERIAL IN IT210 - FUNDAMENTAL OF DATABASES
In Access, lists are a little more complex than the ones you write on
paper. Access stores its lists of data in tables, which allow you to store even
more detailed information. In the table below, the People list in the amateur
baker’s database has been expanded to include other relevant information
on the baker’s friends.
If you are familiar with other programs in the Microsoft Office suite, this
might remind you of Excel, which allows you to organize data in a similar
way. In fact, you could build a similar table in Excel.
Instructional Material Created by: Renante A. Diamante, DIT
Assistant Professor IV
Version 1.0 – 08/2023
4
ILOILO STATE UNIVERSITY OF FISHERIES SCIENCE AND TECHNOLOGY
COLLEGE OF INFORMATION AND COMMUNICATIONS TECHNOLOGY
MAIN CAMPUS-Poblacion Site, Barotac Nuevo, Iloilo | email:
website: iscof.edu.ph | Contact No: (033) 3672-786 Local 1012
INSTRUCTIONAL MATERIAL IN IT210 - FUNDAMENTAL OF DATABASES
CHAPTER 1
INTRODUCTION TO DATABASE MANAGEMENT SYSTEM
1.1 Introduction to the Course
1.2 Introduction to Databases
1.3 Types of Database Models
1.4 Business Requirements
1.1 Introduction to
the Course
Course Description:
This course introduces students to basic relational database
concepts. This also covers relational database terminology, as well as
data modeling concepts, building Entity Relationship Diagrams (ERDs),
and mapping ERDs.
Course Intended Learning Outcomes
Learn the fundamental of relational, object-oriented and
distributed database systems including data models, database
architectures and learn database manipulations.
Discuss the database management system.
Use database command effectively.
Perform basic Data Base administrator’s function.
Develop conceptual models using the Entity-Relationship model.
Design database using data models.
Use database programming languages to manipulate or process
data efficiently.
Use MS Access or SQL Developer Data Modeler and Application
Express.
Relate current issues in the development of database
technologies and applications.
Appraise various implementations of database management
systems.
Appreciate the value of good database design and to follow the
best practices.
Instructional Material Created by: Renante A. Diamante, DIT
Assistant Professor IV
Version 1.0 – 08/2023
1
, Republic of the Philippines
ILOILO STATE UNIVERSITY OF FISHERIES SCIENCE AND TECHNOLOGY
COLLEGE OF INFORMATION AND COMMUNICATIONS TECHNOLOGY
MAIN CAMPUS-Poblacion Site, Barotac Nuevo, Iloilo | email:
website: iscof.edu.ph | Contact No: (033) 3672-786 Local 1012
INSTRUCTIONAL MATERIAL IN IT210 - FUNDAMENTAL OF DATABASES
1.2 What is a
database?
A database is a collection of data that is stored in a computer system.
Databases allow their users to enter, access, and analyze their data
quickly and easily. They're such a useful tool that you see them all the time.
Ever waited while a doctor's receptionist entered your personal information
into a computer, or watched a store employee use a computer to see
whether an item was in stock? If so, then you’ve seen a database in action.
The easiest way to understand a database is to think of it as
a collection of lists. Think about one of the databases we mentioned
above: the database of patient information at a doctor's office. What lists are
contained in a database like this? To start with, there's a list of patients'
names. Then there's a list of past appointments, a list with medical history
for each patient, a list of contact information, and so on.
This is true of all databases, from the simplest to the most complex. If
you like to bake, for example, you might decide to keep a database
containing the types of cookies you know how to make and the friends you
give these cookies to. This is one of the simplest databases imaginable. It
contains two lists: a list of your friends, and a list of cookies.
Instructional Material Created by: Renante A. Diamante, DIT
Assistant Professor IV
Version 1.0 – 08/2023
2
, Republic of the Philippines
ILOILO STATE UNIVERSITY OF FISHERIES SCIENCE AND TECHNOLOGY
COLLEGE OF INFORMATION AND COMMUNICATIONS TECHNOLOGY
MAIN CAMPUS-Poblacion Site, Barotac Nuevo, Iloilo | email:
website: iscof.edu.ph | Contact No: (033) 3672-786 Local 1012
INSTRUCTIONAL MATERIAL IN IT210 - FUNDAMENTAL OF DATABASES
However, if you were a professional baker, you would have many more
lists to keep track of: a list of customers, products sold, prices, orders, and so
on. The more lists you add, the more complex the database will be.
Instructional Material Created by: Renante A. Diamante, DIT
Assistant Professor IV
Version 1.0 – 08/2023
3
, Republic of the Philippines
ILOILO STATE UNIVERSITY OF FISHERIES SCIENCE AND TECHNOLOGY
COLLEGE OF INFORMATION AND COMMUNICATIONS TECHNOLOGY
MAIN CAMPUS-Poblacion Site, Barotac Nuevo, Iloilo | email:
website: iscof.edu.ph | Contact No: (033) 3672-786 Local 1012
INSTRUCTIONAL MATERIAL IN IT210 - FUNDAMENTAL OF DATABASES
In Access, lists are a little more complex than the ones you write on
paper. Access stores its lists of data in tables, which allow you to store even
more detailed information. In the table below, the People list in the amateur
baker’s database has been expanded to include other relevant information
on the baker’s friends.
If you are familiar with other programs in the Microsoft Office suite, this
might remind you of Excel, which allows you to organize data in a similar
way. In fact, you could build a similar table in Excel.
Instructional Material Created by: Renante A. Diamante, DIT
Assistant Professor IV
Version 1.0 – 08/2023
4
