20 likes | 110 Views
1. 2. 3. +. +. 1. 4. 5. 6. +. +. +. 1. 7. 8. +. +. 9. 10. +. Steps to Build & Run a Database. Step 1 – Conceptual logical design phase Step 2 – Physical design phase Step 3 – Usage design phase Step 4 – Running the database. 1. DB requirements analysis
E N D
1 2 3 + + 1 4 5 6 + + + 1 7 8 + + 9 10 + Steps to Build & Run a Database Step 1 – Conceptual logical design phase Step 2 – Physical design phase Step 3 – Usage design phase Step 4– Running the database
1 DBrequirements analysis by: DB designer + domain experts + users of the domain modeling requirements, functionality requirements, constraints, usage preferences Choose the data model Use the data model to translate the requirements into DB schema Choose the DBMS Design thestorage (physical) structure considering the DB requirements Implement the physical structure using the DBMS Design the access constraints / facilities considering the DB requirements (e.g. views / access rights / constraints, etc.) Implement the usage facilities Validation & modification DB administration 2 3 4 5 6 7 8 9 10