Get premium membership and access questions with answers, video lessons as well as revision papers.

Discuss the main activities associated with the implementation stage.

      

Discuss the main activities associated with the implementation stage.

  

Answers


kelvin
The database implementation is achieved using the Data Definition Language (DDL) of the selected DBMS or a graphical user interface (GUI), which provides the same functionality while hiding the low-level DDL statements. The DDL statements are used to create the database structures and empty database files. Any specified user views are also implemented at this stage.

The application programs are implemented using the preferred third or fourth generation language (3GL or 4GL). Parts of these application programs are the database transactions, which we implement using the Data Manipulation Language (DML) of the target DBMS, possibly embedded within a host programming language, such as Visual Basic (VB), VB.net, Python, Delphi, C, C++, C#, Java, COBOL, Fortran, Ada, or Pascal. We also implement the other components of the application design such as menu screens, data entry forms, and reports. Again, the target DBMS may have its own fourth generation tools that allow rapid development of applications through the provision of non-procedural query languages, reports generators, forms generators, and application generators.

Security and integrity controls for the application are also implemented. Some of these controls are implemented using the DDL, but others may need to be defined outside the DDL using, for example, the supplied DBMS utilities or operating system controls.

kevowmuchiri answered the question on July 4, 2018 at 16:07


Next: Describe the potential benefits of developing a prototype database system.
Previous: Describe the purpose of the data conversion and loading stage.

View More Computer Science Questions and Answers | Return to Questions Index


Learn High School English on YouTube

Related Questions