Database design and implementation UE Past Papers Questions.

What will happen or what will be the output if the following SQL operations are executed in a table called instructors?

1. DELETE FROM Instructors WHERE Lastname='Mlima' AND Firstname='Kilimanjaro';
2. SELECT DISTINCT City FROM Instructors;

Answer / Solution

UNSOLVED

Giving brief explanations , mention 4 advantages of any DBMS

Answer / Solution

UNSOLVED

Briefly describe the relational database model

Answer / Solution

UNSOLVED

Give the meaning of the following terminologies as used in database analysis:

1. ACTOR
2. Funcional requirements
3. Non- functional requirements

Answer / Solution

UNSOLVED

What is the difference between a relation and a Relationship?

Answer / Solution

UNSOLVED