Wonderful, you have completed a quarter of the course. Keep up the good work. We hope you are enjoying and find the content useful. In this additional resource lecture for Section two, we will discuss the system development lifecycle, organization roles and key terms. Our database systems development life cycle sdlc is comprised of a requirements analysis stage, where users of the system are interviewed and forms reports business rules queries are identified. From this initial analysis, a data model can be prepared which represents a conceptual representation of the content, relationships and constraints.
Frequently prototypes of the future potential system are created for user information and feedback. Next, the design stage Applied where the conceptual data model is transformed into a logical database design. The design phase includes table names, columns, data types, primary and foreign keys. Any data constraints are captured including limits and business rules. In the final phase, the implementation state, the physical database is constructed. Here the database is populated with data, queries, forms and reports.
User Interfaces called UI screens are created, application programs and documentation is written and the new system is tested for any bugs and the beta testing is released. Many organizations identify another important step in the system development lifecycle, maintenance and updates. The responsibility of this phase is done by the database administrator organization roles applicant developer programs that operate on the database. database administrator loads and maintains the data. database architects creates and manages large expensive databases. Databases designer establishes the structure or schema of the database.
Database implementer builds the database. database managers work with the DBMS and makes top level decisions. data scientists manage big data for strategic decision making. SQL programmers and database programmers write ad hoc queries to report findings from the data. Here are some of the key terms mentioned in section two anomaly column database, database management system, database application, database system, DDL DML entity MS Access relational role schema, SQL and system development lifecycle table and tupple