GROUP 1:
Design a database for a university. The database should consist of at least 12 tables. Relationships between the tables should be well defined using Primary and Secondary keys. Show detail graphical representation of such a relationship using an ERD.
State clearly all business rules represented on your ERD
GROUP 2:
Implement a database for any hotel of your choice using MYSQL. The database should consist of at least 8 tables. Relationships between the tables should be well defined using Primary and Secondary keys. Show detail graphical representation of such a relationship using an ERD.
GROUP 3:
Design a MySQL database for the school’s library. The database should consist of at least 6 tables. Relationships between the tables should be well defined using Primary and Secondary keys. Show detail graphical representation of such a relationship using an ERD.
Perform some MySQL query on your database
GROUP 4:
As a team, you have been invited to develop a system for a hospital. All processes of the hospital need to be automated, as a result, you need to build a database to contain records for each process. Explain the hospital processes you wish to automate, design all tables required for the processes, define clearly all business rules to be implemented and develop an ERD to present to the management team of the hospital