LOGICAL DATABASE DESIGN OVERVIE1

LOGICAL DATABASE DESIGN OVERVIE1 -...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
LOGICAL DATABASE DESIGN OVERVIEW This chapter deals with the process of deciding how to arrange the attributes of the  entities in the business environment into database structures, such as the tables of a  relational database. Our  goal  is to create well-structured tables that properly reflect the company's business  environment. In previous chapters we created ERD's which represented a conceptual view of our  data. Now we will continue this process by converting our ERD's into logical data  structures which can be implemented in a relational DBMS. An additional process called  Normalization will provide a final check on the validity of our data structures before we  began the implementation process. Refer to notes on Converting ERDs to Logical Data Structures in table of contents  for this module. Important Concepts : Relation : A relation is a table that meets certain qualifications. The tables in our  database will be relations. We have discussed how entities in our ERD's will become  tables in the database--even associative entities. While all relations are tables, not all 
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/21/2011 for the course COP 3330 taught by Professor Staff during the Spring '08 term at University of Central Florida.

Page1 / 3

LOGICAL DATABASE DESIGN OVERVIE1 -...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online