What are the 3 approaches to database development?
• Bottom-up approach: Start by understanding the transactions occurring in an organization, then evolve to understanding the information needs. • Three-level approach: Structure your design approach iteratively. • Conceptual: Create an information model that creates a layout of the information in the domain being studied. • Logical: Created relations between entities in the information model you constructed, and make sure the table relations and structures are normalized. • Physical: Create a physical layout of how the database will store, retreive and process information. Select the type of DBMS to use, and implement it. • Top-down approach: Start with a problem statement, whose solution is “better information”. Proceed to identify your information objectives, and lay down the boundaries of the scope of your database. Understand the symantec dimensions (the meanings of things) of the design, and proceeed to assign entities in the model. Create relationships between the entities that a
