Database management systems UE Past Papers Questions.

With an aid  of a diagram , describe the stages of database development life cycle

Answer / Solution

Mention three ways of retrieving required information from the LibreOffice base database

Answer / Solution

You have been requested to design the database for HAMNAZO FREIGHT AND FOWARDING SERVICES LTD. The database is to hold information relating to customers, orders, suppliers and products. The database should be designed based on the following requirements:

• A customer can have one or many orders
• An order can contain one or many products
• A product can be associated with one or many orders
• A supplier can supply one or many products

Draw the E-R diagram representing the logical design of the database.

Answer / Solution