MySQL RDBMS

The purpose of this assignment is to analyse a system and go through design steps using MySQL RDBMS$,$ and perform very simple data entry and database backups. You are not expected to develop any application or login on top of the database.

A college has decided to develop a database for $$admins$,$teachers$,$students$$ and $$courses$.$ The database needs to support an application that enables students to select from the offered courses.

Here are the features of the application:

Course availability for each semester is decided by college admins and students can only see the offered courses.

Admins, assign courses to teachers.

Teachers can pass or fail students.