CS224 Chapter 3 Notes

• ❑ Database System Development
• ❑ Write a detailed and accurate description of business operations
• ❑ Develop an extensive set of business rules
• ❑ Define major transaction modules
• ❑ Create the initial ERD segments
• ❑ Create a basic data dictionary
• ❑ Perform normalization checks
• ❑ Modify ERD segments if necessary
• ❑ Link all the ERD segments to produce the initial ERD
• ❑ Check normal forms again
• ❑ Complete the final ERD
• ❑ Perform final review of data dictionary
• ❑ Implement the database
• ❑ Create end-user interface
• ❑ Create database system by connecting all system components
• ❑ Verify the implementation and app development for each module against the business rules
• ❑ Create a security system for the database
• ❑ Test system thoroughly
• ❑ The Description of Operations
• ❑ Business Type - helps determine
• ❑ number and types of entities
• ❑ Data types and characteristics
• ❑ Business Objectives
• ❑ Organizational Hierarchy
• ❑ Data Environment
• ❑ How much data will the db contain?
• ❑ How frequently are data updated?
• ❑ What data types exist?
• ❑ Current Operations
• ❑ Current problems and Proposed Solutions
• ❑ Available Resources
• ❑ Editing the Description of Operations
• ❑ Business Rules and the ERD Segments
• ❑ The Invoicing Module
• ❑ The Product Order Module
• ❑ The Back-Order Module
• ❑ The Product Return Module
• ❑ Putting the ERD segments together
• ❑ Design Limitations