Solutions Chapter 6

Solutions Chapter 6 - DQ 6-4 ANS. Several steps required...

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

View Full Document Right Arrow Icon
DQ 6-4 Several steps required when designing a database. List and describe the main steps of this process. ANS. The three main steps are: Prepare the conceptual model o Identify the entities o Identify the relationships between the entities o Prepare the E-R diagram Specify the logical design o Select the logical database model o Transform the conceptual data model using a logical database model Implement the physical design o Decide on particular HW and SW o Decide access methods and physical structures The specific points you might want to emphasize are: 1. The important role of ‘modeling.’ The REA model allows you to simplify the problem by limiting the types of entities to three: resource, event or agent. 2. Using E-R diagramming, each entity in the diagram becomes a relational table in the database. ERDs serve as a pivotal technique as you transition from conceptual design (using REA to identify the entities of interest that you want to collect data on) to logical/physical design (the details needed to implement the design into Access or some other working database, e.g. cardinalities, PK/FK, and linking tables). 3.
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 02/23/2010 for the course ACG ? taught by Professor Bline+pascaerlla during the Spring '10 term at Bryant.

Page1 / 5

Solutions Chapter 6 - DQ 6-4 ANS. Several steps required...

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