Page 113 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

Database Management Systems/Managing Database Mandeep Kaur, Lovely Professional University

Notes Unit 7: Relational Database Design

CONTENTS
Objectives
Introduction

7.1 Relational Database Design
7.2 Features of Relational Database
7.3 Atomic Domain and First Normal Form

7.4 Functional Dependencies
7.5 Multi-valued Dependencies
7.6 Join Dependencies
7.7 Rules about Functional Dependencies
7.8 Database Design Process

7.8.1 Logical Database Design
7.8.2 Entity Sets to Tables
7.9 Summary

7.10 Keywords
7.11 Self Assessment
7.12 Review Questions
7.13 Further Readings

Objectives

After studying this unit, you will be able to:

 Explain relational database design
 Describe various features of relational database
 Know atomic domain and first normal form
 Describe functional and multivalued dependencies
 Explain join dependencies

 Describe database design process
Introduction

Relational database supports basic database operations in order to provide useful means for
retrieving or manipulating data in tables. Because the relational model has its mathematical
basis upon the relational theory (by thinking tables as sets or relations), the supported database
operators conform to existing operators in relational algebra. In fact, a relational database
software implementation, called DBMS, is said to have higher degree of relational completeness
depending upon the extent to which relational algebra operators are supported.

106 LOVELY PROFESSIONAL UNIVERSITY