A database management system (or DBMS) is essentially nothing more than a computerized data-keeping system. Users of the system are given facilities to perform several kinds of operations on such a system for either manipulation of the data in the database or the management of the database structure itself. Database Management Systems (DBMSs) are categorized according to their data structures or types.

Hierarchical and relational database systems have common benefits. RDBMS has a significant advantage over the hierarchical DB of being non-navigational. By navigational, we mean that in a hierarchical database, the application programmer must know the structure of the database. The program must contain specific logic to navigate from the root segment to the desired child segments containing the desired attributes or elements. The program must still access the intervening segments, even though they are not needed.

1. Create using a Java program a relational database called Lecturer. (10 Marks)

2. Create using a Java program a table called lecturer details in the relational database that will be used to store the lecturer’s first name, last name, and Campus name.

3. Create a query for an application program that inserts the lecturer’s first, last, and Campus names in the lecturer Details table.

Information to be inserted should be taken directly from the HashMap created in question 1.

For each lecturer, generate randomly a campus where he is coming from considering all the university campuses.

4. Write a query to display all the lecturers that are stored in your database.