Chapter 5 Notes

Capture business rules step 4 define physical model

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Identify Relationships Define Entities & Relationships Review Entity-Relationship Model Design Example: Music CD collection Entities: the CD, Tracks, Composer Attributes: CD (ID, title, musician, cost, etc.) Track (song title, length, order number) Composer (name, genre, DOB, DOD) Relationships: CD to Track, Composer to Track Step 2: Defining an Attribute Model List Candidate Attributes for each Entity Add KEYS to model Attribute & Normalize Model Define Attributes Review Logical Model Step 3: Identify & Capture Business Rules Review & Verify Cardinalities Define Referential Integrity Identify Business Domains Identify Attribute Default Values Step 4: Define Physical Model Select Target DBMS Name Tables & Columns Name & Define Indexes Define Columns Verify/Update Triggers A trigger defines a program that is called with a delete, insert, update or read operation occurs for a file. Generate Reports & Document Design Step 5: Review Final Design Verify Entities & Definitions Verify Relationships & Definitions Verify Attributes & Definitions Verify Business Constraints Approve Schema Design A Review of the Advantages of Database Processing Lower cost… (relative it what?) More Information from same amount of data Data Sharing is easier Controlled or elimination of redundancy Consistency, Integrity, Security Increased Productivity Some Disadvantage of Database Processing Greater Complexity Possibly a greater impact of a failure Recovery is more difficult Although these are all debated issues, opportunities for complete failure are often reduced with the latest database products, but reliability results in higher investment costs. Database Management Systems Database Management Systems (DBMSs) Provide a user view Provide tools to create & modify the database Store & retrieve data Manipulate data Produce reports Fig 5.11 Fig 5.12 Fig. 5.13 Fig 5.14 Fig 5.15 Fig 5.16 Fig 5.17 Selecting a DBMS Features Vendor Cost Database Developments Fig 5.18 Elements of Data Warehouse Database Developments Data warehouses Data marts Data mining Online analytical processing (OLAP) is an approach to answering multi-dimensional analytical (MDA) queries swiftly. OLAP is part of the broader category of business intelligence, which also encompasses relational database, report writing and data mining. Table 5.4 Table 5.5 Table 5.6 For next class… Chapter 7: E-Business Systems. Transactions and Operations. Notations for the Database Project: REC Regional Epidemiology Center; develop the Notations. Submit in drop box DB Notations in DOC format; Due – Oct 9 Principles of Information Systems, Fifth Edition...
View Full Document

This note was uploaded on 04/04/2014 for the course MIS 351 taught by Professor Lokshina during the Spring '11 term at SUNY Oneonta.

Ask a homework question - tutors are online