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
- Describe the potential benefits of developing a prototype database system.(Solved)
Describe the potential benefits of developing a prototype database system.
Date posted: July 4, 2018. Answers (1)
- Discuss the two main activities associated with application design.(Solved)
Discuss the two main activities associated with application design.
Date posted: July 4, 2018. Answers (1)
- Explain why it is necessary to select the target DBMS before beginning the physical database design phase. (Solved)
Explain why it is necessary to select the target DBMS before beginning the physical database design phase.
Date posted: July 4, 2018. Answers (1)
- Discuss what a user view represents when designing a database system.(Solved)
Discuss what a user view represents when designing a database system.
Date posted: July 4, 2018. Answers (1)
- Describe the purpose of creating a mission statement and mission objectives for the required database during the database planning stage.(Solved)
Describe the purpose of creating a mission statement and mission objectives for the required database during the database planning stage.
Date posted: July 4, 2018. Answers (1)
- Briefly describe the stages of the database system development lifecycle. (Solved)
Briefly describe the stages of the database system development lifecycle.
Date posted: July 4, 2018. Answers (1)
- Discuss the relationship between the information systems lifecycle and the database system development lifecycle.(Solved)
Discuss the relationship between the information systems lifecycle and the database system development lifecycle.
Date posted: July 4, 2018. Answers (1)
- Describe what is meant by the term ‘software crisis’.(Solved)
Describe what is meant by the term ‘software crisis’.
Date posted: July 4, 2018. Answers (1)
- What is QBE and what is the relationship between QBE and SQL?(Solved)
What is QBE and what is the relationship between QBE and SQL?
Date posted: July 4, 2018. Answers (1)
- What is the difference between a sub query and a join? Under what circumstances would you not be able to use a sub query?(Solved)
What is the difference between a sub query and a join? Under what circumstances would you not be able to use a sub query?
Date posted: July 4, 2018. Answers (1)
- Explain how the GROUP BY clause works. What is the difference between the WHERE and HAVING clauses?(Solved)
Explain how the GROUP BY clause works. What is the difference between the WHERE and HAVING clauses?
Date posted: July 4, 2018. Answers (1)
- What restrictions apply to the use of the aggregate functions within the SELECT statement? How do nulls affect the aggregate functions?(Solved)
What restrictions apply to the use of the aggregate functions within the SELECT statement? How do nulls affect the aggregate functions?
Date posted: July 4, 2018. Answers (1)
- Explain the function of each of the clauses in the SELECT statement. What restrictions are imposed on these clauses?
a)FROM
b) WHERE
c)GROUP BY
d)HAVING
e)SELECT(Solved)
Explain the function of each of the clauses in the SELECT statement. What restrictions are imposed on these clauses?
a)FROM
b) WHERE
c)GROUP BY
d)HAVING
e)SELECT
Date posted: July 4, 2018. Answers (1)
- What are the two major components of SQL and what function do they serve? (Solved)
What are the two major components of SQL and what function do they serve?
Date posted: July 4, 2018. Answers (1)
- Define the two principal integrity rules for the relational model. Discuss why it is desirable to enforce these rules.(Solved)
Define the two principal integrity rules for the relational model. Discuss why it is desirable to enforce these rules.
Date posted: July 4, 2018. Answers (1)
- Discuss the differences between the candidate keys and the primary key of a table. Explain what is meant by a foreign key. How do foreign...(Solved)
Discuss the differences between the candidate keys and the primary key of a table. Explain what is meant by a foreign key. How do foreign keys of tables relate to candidate keys? Give examples to illustrate your answer.
Date posted: July 4, 2018. Answers (1)
- Discuss the properties of a relational table. (Solved)
Discuss the properties of a relational table.
Date posted: July 4, 2018. Answers (1)
- Discuss the advantages and disadvantages of DBMSs.(Solved)
Discuss the advantages and disadvantages of DBMSs.
Date posted: July 4, 2018. Answers (1)
- Describe the functions that should be provided by a modern full-scale multi-user DBMS.(Solved)
Describe the functions that should be provided by a modern full-scale multi-user DBMS.
Date posted: July 4, 2018. Answers (1)
- Describe the problems with the traditional two-tier client-server architecture and discuss how these problems were overcome with the three-tier client-server architecture.(Solved)
Describe the problems with the traditional two-tier client-server architecture and discuss how these problems were overcome with the three-tier client-server architecture.
Date posted: July 4, 2018. Answers (1)