Database concepts and design UE Past Papers Questions.

Define the following terms in brief

1. Database
2. Database Management System (DBMS)
3. Data redundancy
4. Database administrator
5. Data integrity

Answer / Solution

Use the diagrams below to answer the following questions.

1. Give the name of each of the following database models.
2. If you are designing a database , which one will you choose and why ? (Give three reasons)

Answer / Solution

During the database design process one of the main activities in the phase of analysis is how to deal with user view especially if there is need of more than one user view for a certain database. There are three main approaches to managing the requirements of a database system with multiple users. Use the diagram below to answer the following questions.

1. Provide the name of the approach represented in each diagram.
2. Give two differences between the approaches you have provided.

Answer / Solution

UNSOLVED

Database involves a series of phases which are used in designing process. The phases involve planning , analysis, dabase design, implementation and maintenance.

1. During database phase how do you know if the database is complex (answer in short)
2. If it is complex which approach will you use during the design phase ?

Answer / Solution

UNSOLVED

One of the most difficult aspects of database design is the fact that designers, programmers, and end-users tend to view data and it`s use in different ways. To ensure that we get a precise understanding of hte nature of the data and how it is used by the enterprise, we need to have a model for communication that is non-technical and free of ambiguities. The entity-Relationship (ER) model is one such example.

Answer / Solution

UNSOLVED