-
Describe the purpose of the data conversion and loading stage.
Date posted:
July 4, 2018
-
Discuss the main activities associated with the implementation stage.
Date posted:
July 4, 2018
-
Describe the potential benefits of developing a prototype database system.
Date posted:
July 4, 2018
-
Discuss the two main activities associated with application design.
Date posted:
July 4, 2018
-
Explain why it is necessary to select the target DBMS before beginning the physical database design phase.
Date posted:
July 4, 2018
-
Discuss what a user view represents when designing a database system.
Date posted:
July 4, 2018
-
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
-
Briefly describe the stages of the database system development lifecycle.
Date posted:
July 4, 2018
-
Discuss the relationship between the information systems lifecycle and the database system development lifecycle.
Date posted:
July 4, 2018
-
Describe what is meant by the term ‘software crisis’.
Date posted:
July 4, 2018
-
What is QBE and what is the relationship between QBE and SQL?
Date posted:
July 4, 2018
-
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
-
Explain how the GROUP BY clause works. What is the difference between the WHERE and HAVING clauses?
Date posted:
July 4, 2018
-
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
-
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
-
What are the two major components of SQL and what function do they serve?
Date posted:
July 4, 2018
-
Define the two principal integrity rules for the relational model. Discuss why it is desirable to enforce these rules.
Date posted:
July 4, 2018
-
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
-
Discuss the properties of a relational table.
Date posted:
July 4, 2018
-
Discuss the advantages and disadvantages of DBMSs.
Date posted:
July 4, 2018
-
Describe the functions that should be provided by a modern full-scale multi-user DBMS.
Date posted:
July 4, 2018
-
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
-
Describe the five components of the DBMS environment and discuss how they relate to each other
Date posted:
July 4, 2018
-
Describe the main characteristics of the database approach.
Date posted:
July 4, 2018
-
Discuss the meaning of each of the following terms:
(a) Data
(b) database
(c) database management system
(d) application program
(e) data independence
Date posted:
July 4, 2018
-
Outline four types of memory as used in data structures.
Date posted:
July 3, 2018
-
Define Data structures.
Date posted:
July 3, 2018
-
Explain the difference between nominal and real gross domestic product (GDP).
Date posted:
July 3, 2018
-
Explain how an interactive DVD can be used to train users of an information system
Date posted:
July 3, 2018
-
An interactive DVD can be used to provide training. Describe how data is written onto a DVD.
Date posted:
July 3, 2018