Title 02 - DB Design Fundamentals.pdf ✅

Assi.Prof. JOHN MICHAEL LEGASPI Faculty, Computer and Electronics Department 2 Database Design Fundamentals CPET 401 Database Management Systems 01

Objectives (continued) Design a database to satisfy a set of requirements Convert an unnormalized relation to first normal form Convert tables from first normal form to second normal form Convert tables from second normal form to third normal form Create an entity-relationship diagram to represent the design of a database CPET 401 Database Management Systems 01
Introduction Database design: process of determining the particular tables and columns that will comprise a database Must understand database concepts Process of normalization CPET 401 Database Management Systems 01